Hello guys, how's it going?
I have attached a very simple worksheet that describes what I am trying to do (in reality my worksheet is slightly more advanced).
Anyway, I have a table for which values are entered from different sheets (basically each sheet is a month from which I enter data into the table).
The thing is that I can only enter the data manually, and it takes a lot of time.
*Note, in this attached file, I can simply use auto-fill across rows since all values are located in the same spot - without any interference. In reality (I cannot attach that worksheet), some values are located differently across the various sheets, because each month is slightly different.
The bottom line, I would like Excel to recognize the 'Names' (Josh, David, Sarah, Judy) so that it can automatically refer to each name and its corresponding value in each sheet - when I use auto-fill. Does it make sense?
Thank you!!
Bookmarks