Macro to Copy data from one sheet and paste to another sheet based on a condition

**SaurabhShri1** · 03-20-2013, 04:44 AM

Hi Everyone,

I am new to Macro and need a help for creating it. Below is the scenario.

The Example sheet in the attachment has 2 tabs ALM and AIS and both the tabs having attribute name,attribute definition, table & column & transformation logic for a particular source system. Apart from this it also has EDR & EDXF Schema details(Table & column name). The table name in EDXF has 2 tables(having suffix MONTH & DAY).

The Desired Output sheet is the result which I need. I want that for attribute A1,A2 etc we should get one row(having details for A1) for each Table (MONTH & DAY) corresponding to source system SRC1 in tabs ALM & AIS.

Please see the attachment "Desired Output" sheet which is the resultant sheet.

Please refer the attachments for the scenario.

Any Help or any direction would be highly appreciated.

**SaurabhShri1** · 03-20-2013, 08:15 AM

Any suggestion Guys...

**JohnnySix** · 03-20-2013, 09:14 AM

I was looking for exactly the same thing and dug up a fair few orphaned threads from 2008 -

Please Login or Register  to view this content.

This is what I ended up using- there are probably more elegant ways of doing it, but this worked.

**SaurabhShri1** · 03-20-2013, 09:30 AM

Thanks for Replying Johnny,
But here in my case there is some condition which is shown in the attachments.
Here I dont need to copy the contents (entirely) and paste it to another sheet.