Here's my issue:
I have one sheet that will have data entered; for example, a staff member's name, a specific date, etc. Along with lots of other data.
On a second sheet (separated by a tab - within the same workbook), I need that data to carry over automatically. So, say, if a staff member's name is entered into a cell in sheet one, I need that to show up in sheet two automatically; the date entered in sheet one should also carry over. Basically so the rows more or less match, which sheet two will have the same info with totals.
So the question is - how do I get this info to carry over from one sheet to another? I've tried a few different formulas: just using an = sign and then clicking over to the other sheet and the other cell, but it doesn't work, it just gives me something like "=Table1[[#This Row],[Technician]]". I've tried using the =VALUE and =TEXT. I assume I'm missing something; I just need the name of the staff, the date, etc. to move over from one sheet to the next exactly as entered. How do I do this? Please help!
Bookmarks