M
mrhartwig
Hi there! I have 2 spreadsheets that I'm working on. Spreadsheet A
has data that is being exported from an Access query. I would like to
be able to use Spreadsheet B to relay the information from A (sort of
a template/dashboard). Spreadsheet A has each month listed and the
data for 3 different locations. Also, as the year progresses
Spreadsheet A will change so I cannot simply link Spreadsheet B to a
particular cell in Spreadsheet A. Does anyone have any ideas on what
formula I could use in Spreadsheet B to only get data for a certain
month? I'd like to be able to enter the month and it automatically
update the data for the 3 locations? Any information would be greatly
appreciated.
Spreadsheet A
LOCATION MONTH PROCESSED PAID
Burbank 1/1/08 110190 32104
Burbank 2/1/08 152601 49090
Fairfield 1/1/08 128009
51313
Fairfield 2/1/08 92301
23115
Fresno 1/1/08 141253
50143
Fresno 2/1/08 160561
50548
So, for example, I would like to enter a date and it automatically
populate each location with the Processed and Paid for a given month.
Thanks!
has data that is being exported from an Access query. I would like to
be able to use Spreadsheet B to relay the information from A (sort of
a template/dashboard). Spreadsheet A has each month listed and the
data for 3 different locations. Also, as the year progresses
Spreadsheet A will change so I cannot simply link Spreadsheet B to a
particular cell in Spreadsheet A. Does anyone have any ideas on what
formula I could use in Spreadsheet B to only get data for a certain
month? I'd like to be able to enter the month and it automatically
update the data for the 3 locations? Any information would be greatly
appreciated.
Spreadsheet A
LOCATION MONTH PROCESSED PAID
Burbank 1/1/08 110190 32104
Burbank 2/1/08 152601 49090
Fairfield 1/1/08 128009
51313
Fairfield 2/1/08 92301
23115
Fresno 1/1/08 141253
50143
Fresno 2/1/08 160561
50548
So, for example, I would like to enter a date and it automatically
populate each location with the Processed and Paid for a given month.
Thanks!