I have a number of worksheets and need to move data from the same cells of each work sheet to a summary worksheet. I manually entered the cell id's for the first sheet.
example =Jan!M6, =Jan!N7, =Jan!O9 etc. I know I should be able to automatically enter these same cells for the remainder of my worksheets with out mannualy going in and typing each one (there are a lot of entries.) But for the life of me I just can not remember how to do it. The next sheet is named "Feb" and "Mar" etc.
Can anyone point me in the right direction before I start typing????
Bookmarks