Forum Discussion

KTagg's avatar
KTagg
Copper Contributor
Aug 18, 2023

#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.

Resources