G
Guest
here is my problem.
I have 12 spreadsheets with information on monthly sales to different
customers A, B , C. For example January spreadsheet will have, say 10 sales
to A, 15 sales to B, 8 sales to C etc. And February spreadsheet will have say
12 sales to A, 5 sales to B, 11 sales to C
I want to create an automated spreadsheet that selects sales to Customer A
from January spreadsheet, February Spreadsheet, March Spread
Sheet....December Spreadsheet. Is there a way to use V lookup to do this.
I have 12 spreadsheets with information on monthly sales to different
customers A, B , C. For example January spreadsheet will have, say 10 sales
to A, 15 sales to B, 8 sales to C etc. And February spreadsheet will have say
12 sales to A, 5 sales to B, 11 sales to C
I want to create an automated spreadsheet that selects sales to Customer A
from January spreadsheet, February Spreadsheet, March Spread
Sheet....December Spreadsheet. Is there a way to use V lookup to do this.