Copying cells from one spreadsheet into another

[Pantego]

Hello:

I want to copy the contents of cells from one Workbook into another workbook. For example. I have cells in Workbook A that I want to copy into Workbook B. The cells in Workbook A are in different locations than they will be in Workbook B. I am currently copying and pasting the contents of each cell (one at a time) into the Workbook B. Isn't there a macro that will do this for me?

Thanks

 

[balajayan]

Hi Pantego,

Welcome to board!

Please put your requirement in detail. Unless your requirement is not clear, helping you would be difficult.

 

[Pantego]

OK I will try to explain this in more detail. Let's say for example I have data in Worksheet A. On row 64 I have 30 columns but I only what to copy the contents in the first 4 columns. I will then take that data and post in into Worksheet B. The only problem is, in Worksheet B, this data will be copied in different rows and different cells. For example the data from "Worksheet A" A64, will be copied to Worksheet B C1, the data from Worksheet A B64 will be copied to Worksheet B E5, etc. I hope this makes it somewhat clearer.

 

[balajayan]

You should remeber, Formulas or macro can be developed for a logical requirements but not for a judgemental activity.

If you have any logic for copying the content from Worksheet A A64 to Worksheet B C1 and then Worksheet A B65 to Worksheet B E5, then post your requirement.

 

[rpaulson]

This should get you a start. Adjust ranges and sheet names as needed.

Sub Quick_copy()
Worksheets("To").Range("A2:A9")= Sheets("From").Range("A2:A9")
End Sub

Ross