J
JL Taylor
I have a spreadsheet listing payments received on a specific day of the
month. My workbook contains an individual sheet for each day of the month. I
would like to filter some of that specific data from the daily sheets into a
new sheet.
My daily sheets have the following set up: division, customer, invoice
number, amount of check, salesperson (there's more but not necessary to
list). My summary sheet needs to have these basic fields linked or pulled to
it for only ONE division.
I've tried doing a lookup, vlookup, and IF statement to extract the data.
The only one that worked was vlookup, but it only pulled one row of data. I
have multiple rows and multiple people at that division.
Here's my statement: =VLOOKUP("regional",'1st'!1:65536,9,TRUE)
where "Regional" is my division; "1st" is my daily sheet, and 1:65536 is the
table array, and 9 is the column from which to pull the first piece of info -
in this case the salesperson's name. I have separate columns to set up the
formula to pull the invoice number, the dollar amount, etc.
But this only pulled one salesperson's name and when I try to copy the
formula to pull other salespeople, it doesn't work.
Note: I believe I have to use the full range of the entire spreadsheet for
that day because there's no way of knowing which rows are going to be the
Regional market from day to day. It could be rows 135-150 on the 1st; and
rows 335-360 on the 2nd.
Also, if there's a better function to pull this data please let me know.
month. My workbook contains an individual sheet for each day of the month. I
would like to filter some of that specific data from the daily sheets into a
new sheet.
My daily sheets have the following set up: division, customer, invoice
number, amount of check, salesperson (there's more but not necessary to
list). My summary sheet needs to have these basic fields linked or pulled to
it for only ONE division.
I've tried doing a lookup, vlookup, and IF statement to extract the data.
The only one that worked was vlookup, but it only pulled one row of data. I
have multiple rows and multiple people at that division.
Here's my statement: =VLOOKUP("regional",'1st'!1:65536,9,TRUE)
where "Regional" is my division; "1st" is my daily sheet, and 1:65536 is the
table array, and 9 is the column from which to pull the first piece of info -
in this case the salesperson's name. I have separate columns to set up the
formula to pull the invoice number, the dollar amount, etc.
But this only pulled one salesperson's name and when I try to copy the
formula to pull other salespeople, it doesn't work.
Note: I believe I have to use the full range of the entire spreadsheet for
that day because there's no way of knowing which rows are going to be the
Regional market from day to day. It could be rows 135-150 on the 1st; and
rows 335-360 on the 2nd.
Also, if there's a better function to pull this data please let me know.