Gift2women
New Member
- Joined
- Jun 25, 2005
- Messages
- 33
I have a spreadsheet with multiple tabs: Sheet1 is Summary and Sheet2 - Sheet20 are all the details (but from here on, we will focus on Sheet1 and Sheet2 as Sheets3-20 will follow the same logic as Sheet2, but I don't want to be told that if it is only one sheet why waste my time). Sheet1!B1:L1 contains the header that is used on all sheets. I am using the Camera tool so that a snap of the data can sit in B2 in Sheet2 (as I cannot use macros and (for cell sizing reasons) I don't want to do merged cells). Now in B3 in Sheet2 I want a snap of the detail row (Sheet1!B:L) where Sheet1!A:A matches Sheet2!A3; I added the snap manually and then tried to change the formula as =Index(Sheet1!$B:$L, Match(A3, Sheet1!$A:$A, 0)), but it says "This formula is missing a range reference or defined name." I tried this a couple of additional ways including with an Indirect/Match but was greeted by the same error message. Is there a way to add a formula to a camera reference?
Any help would be greatly appreciated. Thank you.
Any help would be greatly appreciated. Thank you.