I have the above data in two spreadsheets.
- I receive the top rows. (raw data)
- Then total them using formulas. (middle rows)
- Then need to move them into a separate spreadsheet. (bottom rows,
But the 1st spreadsheet changes every month. Can I do this with vlookups?
I'm currently manually copying as the formatting is so tricky, but I'm sure there must be a better way!