PDA

View Full Version : Solved: paste to specific cell resulting from formula



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

mdmackillop
03-12-2005, 01:30 PM
Hi,
Welcome to VBAX.
If you can "sanitise" and post a zipped copy of your file (using the Go Advanced button), it would be a great help.
MD

mperrah
03-13-2005, 04:26 PM
I put comments on the pages.
I have the file named stats.xls
Thanks for any advice direction or coding.
Mark

mperrah
04-25-2007, 10:07 PM
I hadn't noticed how to search my own threads before. Looking at this unsolved thread I think sumpoduct and weeknum() can solve this, thanks to MD's help :)

mdmackillop
04-25-2007, 11:38 PM
This seems to have slipped through the net. Glad you found your solution
Regards
MD