-
Solved: paste to specific cell resulting from formula
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
-
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
-
query the day and period, paste cell to intersect
I put comments on the pages.
I have the file named stats.xls
Thanks for any advice direction or coding.
Mark
-
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
-
This seems to have slipped through the net. Glad you found your solution
Regards
MD
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules