yani17crem
New Member
- Joined
- Apr 24, 2013
- Messages
- 1
i'm working on a template for the sales report and i'm being given the soft copies of the consolidated forms for each branch. this is the sample format:
A1:H1 = DAILY SALES REPORT //merged
A2:H2 = name of branch
A3 = FINAL
G3:H3 = Page 1
A4 = 4/17/2013 9:21
F4:H4 = Date: Apr 01, 2013 (Mon)
A5:B5 = PARTICULAR
C5 = REY
D5 = ARIA
E5 = BETH
F5 = TOTAL
A6:B6 = FOOD SALES
A7:B7 = EDIS
A8:B8 = SRDIS
A9:B9 = PWD
A10:C10 = DOCUMENTS TRANSMITTED
A11 = DOCUMENTS
B11 = QTY
C11 = AMOUNT
A12 = Refund
A13 = Void
A14 = GC
A15 = Credit Card
C6:F9 are different amounts
B12:C14 are quantities and amounts
the scenario here is that this format is not consistent. there may be additional rows and/or columns which would make the TOTAL column be placed in any column depending on the number of cashiers. it can also be that there will be a row inserted after PWD which would affect those information below it. my goal is to find the TOTAL for each particular, the QTY and AMOUNT for each DOCUMENT. can someone please help me without the need for VBA?
A1:H1 = DAILY SALES REPORT //merged
A2:H2 = name of branch
A3 = FINAL
G3:H3 = Page 1
A4 = 4/17/2013 9:21
F4:H4 = Date: Apr 01, 2013 (Mon)
A5:B5 = PARTICULAR
C5 = REY
D5 = ARIA
E5 = BETH
F5 = TOTAL
A6:B6 = FOOD SALES
A7:B7 = EDIS
A8:B8 = SRDIS
A9:B9 = PWD
A10:C10 = DOCUMENTS TRANSMITTED
A11 = DOCUMENTS
B11 = QTY
C11 = AMOUNT
A12 = Refund
A13 = Void
A14 = GC
A15 = Credit Card
C6:F9 are different amounts
B12:C14 are quantities and amounts
the scenario here is that this format is not consistent. there may be additional rows and/or columns which would make the TOTAL column be placed in any column depending on the number of cashiers. it can also be that there will be a row inserted after PWD which would affect those information below it. my goal is to find the TOTAL for each particular, the QTY and AMOUNT for each DOCUMENT. can someone please help me without the need for VBA?