mperrah
03-12-2005, 01:22 PM
my question is how to copy and paste the input data into the formula result cell
2 sheets: "recap" and "45508"
"45508" has sales for each day arranged in an array matrix
"recap" has totals and goals summerized using formulai
I want to enter sales info on "recap" and have it populate "45508" in the correct row and column based on the day entered.
every 2 weeks is a different period (1-26) in rows
i have named the range period_01, period_02, etc
every day of the 2 week period has a route day number in columns
1-6 monday to saturday (off sunday)
then 7-12 mon-sat (off sunday) i have named the range day01col, day02col, etc
i can find the intersect of the two ranges
to locate the cell I want the data to be pasted
based on the today() function,
my question is how to actually copy and paste the input data from "recap" into the formula result cell on "45508"
VBS or formulai are welcome
2 sheets: "recap" and "45508"
"45508" has sales for each day arranged in an array matrix
"recap" has totals and goals summerized using formulai
I want to enter sales info on "recap" and have it populate "45508" in the correct row and column based on the day entered.
every 2 weeks is a different period (1-26) in rows
i have named the range period_01, period_02, etc
every day of the 2 week period has a route day number in columns
1-6 monday to saturday (off sunday)
then 7-12 mon-sat (off sunday) i have named the range day01col, day02col, etc
i can find the intersect of the two ranges
to locate the cell I want the data to be pasted
based on the today() function,
my question is how to actually copy and paste the input data from "recap" into the formula result cell on "45508"
VBS or formulai are welcome