Copper Contributor

I have (2) sheets in one workbook.

The first sheets acts as a summary of the second sheet.  I have formulas set up on sheet 1 to gather data from the 2nd sheet.  These formulas are basic (=Sheet2!A1)

The 2nd sheet has an area where I have set up names and equipment (Bill, Bob, Truck 1) in merged cells (2 columns/1 row).  I want to click and drag these names and equipment into certain spots (A1 fir example) on sheet 2 and have them show up on Sheet 1.  However; when I do this, I am only get #REF! errors on sheet 1.  All cells are formatted to be the same height and width and there are no other complexities involved.

2 Replies


Moving the cell you cut it and paste over another cell, that causes #REF error How to correct a #REF! error - Microsoft Support. Formatting doesn't matter.

If copy and paste (or drag holding Ctrl) it shall work.


Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?