Copy and paste using Macros

[Melyssa18]

Hi All,

I've seen a few of the answers to previous questions relating to my issue, but haven't quite found the one to solve my problem. (could be my bad macro skills talking).

I am tying to copy and paste 2 rows of data, assuming that another row is greater than 0.
I have attached an example of the data.

In my Worksheet "Book1" I want to copy and paste the values in Row 2 and Row 3 into another Worksheet "ExportData" if the value in Row 4 is >0.

eg if D4 is > 0, then copy and paste values of D2 and D3, and then repeat this process across the row until there are no more values left

I have also added in the worksheet how I expect it to look if it was copied and pasted into my other worksheet.

[Trebor76]

Hi Melyssa18,

Welcome to the forum!!

See how this goes (just change the 'strSourceTab' and 'strOutputTab' variables to suit):

Please Login or Register  to view this content.

Regards,

Robert

PS Can I make my payment in VB?

[Melyssa18]

Thanks for your reply Robert...it almost makes sense!!

Let's pretend you're writing a macros for dummies handbook..and I'm the dummy.

I think my "sample" didn't quite accurately reflect what my actual spreadsheet looks like, so I have copied and pasted a more "realistic" version, including exactly where my columns and rows start and stop...I've tried to adapt your macro to these measurements but have failed...I thought a more proper look may help you explain it to me better!!

So...I want to copy the range AS2:BC2 and range AS8:BC2 into a completely different workbook (not another tab in the same workbook) as long as the corresponding cell in range AS28:BC28 >0, otherwise ignore.

Eg...based on the sample..I would have copied and pasted AS2 and AS8 into another workbook with a sheet name of "BDM Summary"..but not necessarily into exactly the same place in the new tab (eg. AS2 would be copied to B4 and AS8 would be copied to be B5...and we woudl continue this process across the rows until we got to column BC (assuming that's where the values end).

Does this make sense? I'll send VB???

[Trebor76]

Hi there,

Might be best to start a new thread as the requirements you have now stated are quite different from you're original post.

Good luck,

Robert