I need to create a summary sheet from input into different worksheets. Original sheet is the input sheet, summary will automatically pull from Original into summary from just certain cells. The problem is, the original worksheet changes, the person inputting uses the last sheet he created and renames it.
I think if I name the cells I need to be on the summary sheet and but the formula to copy the cell range it will work. How far off am I. I also want to be able to have the summary automatically start a new row after each sheet finishes. So if I have 12 columns pulling from the original after the 12th column is complete start a new row.? :eek:
I just want to know that I'm on the right track or do I need to start over in my thinking.
Thanks