TAB B DATA IS AS FOLLOWS:
COLUMN A = COMPANY (THIS IS THE HEADING)
COLUMN A1 = EFI (THAT IS THE ACTUAL NAME OF THE COMPANY)
COLUMN B1 = STORE( THIS IS THE HEADING)
COLUMN B2 = EFI (THIS IS THE ACTUAL STORE NAME)
COLUMN C1 = FROM (THIS IS THE HEADING FOR THE DATE SALES RANGE STARTING DATE)...
Is not working is comming back with a value error....
Let me try again.....
This is from tab B: where the manual data will be imputed:
A1 - Company B1 STORE C1 D 1 F1
EFI EFI SALES FROM SALES TO ME (UTILITY CO.)
07/01/11 07/15/11 $100.00
Tab A should feed from tab b and look like this...
Is not working is comming back with a value error....
Let me try again.....
This is from tab B: where the manual data will be imputed:
A1 - Company B1 STORE C1 D 1 F1
EFI EFI SALES FROM SALES TO ME...
The person that I am doing this for is not "friendly" with pivot tables and want to have the data accruing that she can see every day of the month as i am putting the data sales daily. the problem that I am having is combining the sum of all the sales daily in tab b to be collectively sumarized...
Hi,
I am working in a spreadsheet in which I want to sum totals from a second tab that have daily sales to an specific company and specific store but that belongs to an specific month. I enter sales daily in the second tab and i want the first tab (the master) to automatically sumarize this...