Forum Discussion
KTagg
Aug 18, 2023Copper Contributor
#REF!
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.
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?
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.