Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste macro needs to paste to a changing cell reference
1.User picks options from combo boxes to create a plan
2.User then runs a macro to copy finished plan. 3.Then selects the correct location within a database to paste. 4.Then runs another macro to paste data I want to specify the paste location by using a cell reference generated by the user entering a week number which then uses VLOOKUP to return the correct cell within the database. My aim is to run one macro to copy and paste the data to the correct location |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How will hyperlink cell reference update after copy paste? | Excel Worksheet Functions | |||
Copy & Paste Forumla - but reference cell is changing | Excel Discussion (Misc queries) | |||
copy-paste started misbehaving (cell reference wrong) | Excel Discussion (Misc queries) | |||
Reference an identical cell on a different page using copy/paste? | Excel Worksheet Functions | |||
Macro to Copy/Paste then Paste to Next Line | Excel Programming |