-
Copy columns based on cell value
I am trying to create a macro that will copy entire column based on a cell value.
For example, In workbook "1", cell "a1", I have a value "A" . That will copy the entire A column in workbook 2, and paste it into workbook 3 cell a1.
Thank you for any help with this
-
I'm guessing you have more than one column to copy. Are you looking to check cells in a range? How do you determine what should be copied and to where it should be pasted?
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