dudeomagic
New Member
- Joined
- Feb 26, 2009
- Messages
- 1
Here's what I'm trying to do: I am in sales and I sell three products. My first workbook which tracks sales has three columns, A, B, C, each with 31 rows which represent the number of days in the month. The next workbook tracks production vs. goals. I want the sales for each day from the first workbook go to the corresponding day in the correct week of the second workbook so that the user doesn't have to input the sales numbers twice. Here's an example:
Book 1:
Prod A Prod B Prod C
1 100.00 0.00 45.00
2 111.00 40.00 55.00
.
.
.
31 200.00 15.00 25.00
Book 2:
*I want to have the user input on which day of the week the first day of the month falls. in this example we'll assume that the first day of the month falls on Friday*
Friday Saturday
A 100.00 111.00
B 0.00 40.00
C 45.00 55.00
Not sure if what I want to do is possible, but figured I'd hang it out there to see if someone can help. Let me know if you need more info. Thanks in advance for any help you folks out there can give!!!
Book 1:
Prod A Prod B Prod C
1 100.00 0.00 45.00
2 111.00 40.00 55.00
.
.
.
31 200.00 15.00 25.00
Book 2:
*I want to have the user input on which day of the week the first day of the month falls. in this example we'll assume that the first day of the month falls on Friday*
Friday Saturday
A 100.00 111.00
B 0.00 40.00
C 45.00 55.00
Not sure if what I want to do is possible, but figured I'd hang it out there to see if someone can help. Let me know if you need more info. Thanks in advance for any help you folks out there can give!!!