Hello to the forum.
I have an excel question and need guidance.
I have a large amount of data that weekly needs to be massaged and formatted so that it can be effectively utilized.
I will do my best to lay out the scenario
sheet 1: These are the column headings
Customer # Customer Name Date of service Amount Paid
1111111 John Doe 04/18/2011 500.00
1112211 Jane Doe 04/17/2011 750.00
Sheet 2:
column 1 column 2 column 3,4,5 etc. (dates)
Customer # Customer name Days of the week extended for calender year
I would like to have one master (sheet 2) with the customer # and Customer Name - then have each day for the hwole year running accross the sheet.
The formula I am seeking help is to pull from Sheet 1 the paid amount to drop into Sheet 2 by date of service mathcing cust # and Cust Name.
I appreciate any help and maybe the concatenate/sumif is not the best way to go but I dont have an alternative yet.
Thank you
I have an excel question and need guidance.
I have a large amount of data that weekly needs to be massaged and formatted so that it can be effectively utilized.
I will do my best to lay out the scenario
sheet 1: These are the column headings
Customer # Customer Name Date of service Amount Paid
1111111 John Doe 04/18/2011 500.00
1112211 Jane Doe 04/17/2011 750.00
Sheet 2:
column 1 column 2 column 3,4,5 etc. (dates)
Customer # Customer name Days of the week extended for calender year
I would like to have one master (sheet 2) with the customer # and Customer Name - then have each day for the hwole year running accross the sheet.
The formula I am seeking help is to pull from Sheet 1 the paid amount to drop into Sheet 2 by date of service mathcing cust # and Cust Name.
I appreciate any help and maybe the concatenate/sumif is not the best way to go but I dont have an alternative yet.
Thank you
