Rdhostetler
New Member
- Joined
- Feb 2, 2015
- Messages
- 34
hello
i am working on a project where i have an order entry system and i need vba code to look at the qty of the order on sheet1 range a1 for example and then go over to sheet2 (which is my sheet that keeps track of my totals) and find the current year in column A and then use that row and offset 1 cell to the right (column B) and increase the current value of that cell by the amount of the value of Cell A1 in sheet1. if it does not find the current year in column A in Sheet2 then it needs to add the current year in the first empty cell in column A.
my biggest problem that i cant figure out is how to get it to lookup the current year and use the correct row for the data or create a new row with the current year...
hope this all makes sense!
is there anyone that has any ideas on how to do this?
i really appreciate any help you can give!
thanks
i am working on a project where i have an order entry system and i need vba code to look at the qty of the order on sheet1 range a1 for example and then go over to sheet2 (which is my sheet that keeps track of my totals) and find the current year in column A and then use that row and offset 1 cell to the right (column B) and increase the current value of that cell by the amount of the value of Cell A1 in sheet1. if it does not find the current year in column A in Sheet2 then it needs to add the current year in the first empty cell in column A.
my biggest problem that i cant figure out is how to get it to lookup the current year and use the correct row for the data or create a new row with the current year...
hope this all makes sense!
is there anyone that has any ideas on how to do this?
i really appreciate any help you can give!
thanks