I cannot seem to find information about what i need a VBA code to do.
If anyone can help me, that would be greatly appreciated.
I have this spreadsheet to log the customers that recieve service, date of service, amount they owe, and if i recieved payment or not.
(Income sheet)
Date Customer Service Amount Payment
22-Apr Blah Blah Mow $ 40.00 Cash
22-Apr Blah Blah Mow $ 40.00
22-Apr Blah Blah Mow $ 45.00
22-Apr Blah Blah Mow $ 40.00
23-Apr Blah Blah Mow $ 85.00 Partners
I need to create a formula or code that will automatically insert this information in the invoice sheet when the customers name is inserted in the Bill To section.
(Invoice Sheet)
Bill To: Blah Blah
55555 Red Oak Dr
Egypt
DESCRIPTION DATE QUANTITY AMOUNT
landscape 20-Apr 1 $ 500.00
TOTAL $ 500.00
Essentially:
When the customers name is entered, I need it to take the invoice date, which will be the day that the invoice is being prepared, lets say (May 1, 2015), and look for all information from that one customer in the Income sheet from May 1 back 31 days (so the month before the invoice date).
I need it then to return:
1. the date of service in the date column of the invoice sheet
2. the type of service in the description column of the invoice sheet
3. Quantity is always one.
4. the amount from the service in the amount column of the invoice sheet.
I do not want it to return any information that would be green in the payment column of the income sheet being that that means that service has already been paid for.
Is this possible?
If anyone can help me, that would be greatly appreciated.
I have this spreadsheet to log the customers that recieve service, date of service, amount they owe, and if i recieved payment or not.
(Income sheet)
Date Customer Service Amount Payment
22-Apr Blah Blah Mow $ 40.00 Cash
22-Apr Blah Blah Mow $ 40.00
22-Apr Blah Blah Mow $ 45.00
22-Apr Blah Blah Mow $ 40.00
23-Apr Blah Blah Mow $ 85.00 Partners
I need to create a formula or code that will automatically insert this information in the invoice sheet when the customers name is inserted in the Bill To section.
(Invoice Sheet)
Bill To: Blah Blah
55555 Red Oak Dr
Egypt
DESCRIPTION DATE QUANTITY AMOUNT
landscape 20-Apr 1 $ 500.00
TOTAL $ 500.00
Essentially:
When the customers name is entered, I need it to take the invoice date, which will be the day that the invoice is being prepared, lets say (May 1, 2015), and look for all information from that one customer in the Income sheet from May 1 back 31 days (so the month before the invoice date).
I need it then to return:
1. the date of service in the date column of the invoice sheet
2. the type of service in the description column of the invoice sheet
3. Quantity is always one.
4. the amount from the service in the amount column of the invoice sheet.
I do not want it to return any information that would be green in the payment column of the income sheet being that that means that service has already been paid for.
Is this possible?
