I am trying to keep a weekly log of rail cars trans-loaded for my company. I have a tab for each week, and i'd like that data from those weekly tabs to populate over into a monthly tab. I have tried a few formulas, but i've had no luck
The data I would like to copy from my weekly tabs is in cell range J:M of each tab (formatted exactly the same). I need the data from each of the weekly tabs to populate into cells A:D of the monthly tab. How can I make that populate so that I only have to input the data into the weekly tabs?
I can get the data to populate over, but it required me to add that formula every time I want to copy data, that is very time consuming.
Bookmarks