Macro - Copy Specific Cells in 1 workbook and paste in another.

Hi guys,

I am not too good with macros, so please help.

I am designing 2 spreadsheets and to help transfer numbers from 1 spreadsheet to another I need a macro which will help me do that.

I would probably need 8 macros, as I need:
- To copy particular cells (not the whole row) from Row 6, 8, 11, 14 separately (i.e there needs to be an option to copy cells from row 6, but not 8 etc)

- To paste to a particular place in the other spreadsheet (i.e. if I copied cells from row 6 is spreadsheet 1, I would need to paste it in the identical place in spreadsheet 2).

Let me know whether this is feasible please.

Many thanks,

Peter

Welcome to the forum, Peter.

Why dont you attach a sample file?

To Attach a File:

1. Click on Go Advanced.
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Could you explain this

To copy particular cells (not the whole row) from Row 6, 8, 11, 14 separately (i.e there needs to be an option to copy cells from row 6, but not 8 etc)

What do you mean by copy 6 but not 8?

Ok, in that case, you do not need 8 separate macros. All you need to do is select the data and then run the macro. The macro will pick up your row numbers and copy them to the corresponding row numbers in the other file.

Will this work?

Originally Posted by liybpg

What I meant was that I need to be able to copy 4 different sets of cells separately. As in: option to copy only cells in row 6, then only cells in row 8 etc.

On 2nd thoughts, maybe i didnt understand this part initially, are you trying to say you do not want to copy the cells in row 7 but copy the cells in row 6 first and then copy the cells in row 8? But everything should be in 1 macro.

Ok, this part is understood.

So should the copy paste to all rows happen at the same time?

Ok, i can provide you a macro that will do the copy paste once the button is pressed.

But you said there are multiple rows. So should the macro just take the row number which the user selects? In other words, will it be ok if the user selects the area or the row to be copied and then triggers the button? Then the macro will do the copy paste.