Need code to copy cells from various worksheets in WorkbookA to a row in WorkbookB

[thecdnmole]

Hi, is there a simple way to copy cells from WorkbookA (Sheet1.range("A1"), Sheet2.range("B1"), Sheet3.range("C1")) to WorkbookB row A(A1,A2,A3)? Thanks.

[Richard Buttrey]

Hi
Why not just link from WB B to A. e.g.

=[WorkbookA.xlsx]Sheet1!$A$1

However I suspect this isn't the whole story and this may be a much simplified example and probably doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.

[thecdnmole]

Hi Richard, yes, not as simple as that, as WorkbookA changes as it's a live form that changes every shift, therefore I want to capture that info onto another workbook in which the list will grow every shift.

[Richard Buttrey]

It seems you're doing a simple Transpose. i.e. copying from a row of cells to a column of cells.

Why not record a macro in wb B to do that and upload it. We can then generalise it for you.

[thecdnmole]

What I've decided to do which seemed to be the easiest, is link all the cells on the six worksheets that I want( which amounts to 35) to a row off to the side of one worksheet, then I will just copy that range of cells to the new workbook. I also used a very simple example, it may look like I am transposing but in reality the cells are all over the worksheet, but that I can figure out, just need a basic code to get me started. Thanks for your suggestions.