Hello!
I have a little experience with VBA and from time to time i have created my own macros.
Now i need something a little bit more complicated and even though i read quite a lot of examples, i could find something matching to my requirements.
So here is what I'm trying to achieve:
Consider Workbook "Source" with two worksheets: "Info1" and ""Info1" which have data in columns from A to Z. [all worksheets have the same headers].
Another Workbook "Destination" with worksheet "Data" to which I want to paste my selected values from Workbook "Source".
My requirement is to find the Rows in Workbook "Source" - search at all worksheets - which in Column R the values is equal to "X001".
Then copy from those Rows only the values of cells at columns R and W and paste to the other Workbook "Destination" at Row 2 Column A and B (Row 1 has headers.)
Just to let you know that both Workbooks will be open when i would like to run the macro.
Any idea is more that welcome!
Thank you!
I have a little experience with VBA and from time to time i have created my own macros.
Now i need something a little bit more complicated and even though i read quite a lot of examples, i could find something matching to my requirements.
So here is what I'm trying to achieve:
Consider Workbook "Source" with two worksheets: "Info1" and ""Info1" which have data in columns from A to Z. [all worksheets have the same headers].
Another Workbook "Destination" with worksheet "Data" to which I want to paste my selected values from Workbook "Source".
My requirement is to find the Rows in Workbook "Source" - search at all worksheets - which in Column R the values is equal to "X001".
Then copy from those Rows only the values of cells at columns R and W and paste to the other Workbook "Destination" at Row 2 Column A and B (Row 1 has headers.)
Just to let you know that both Workbooks will be open when i would like to run the macro.
Any idea is more that welcome!
Thank you!