Aug 18 2023 11:26 AM
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.
Aug 18 2023 01:07 PM
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.