Need dynamic macro to reformat data from one tab to another

**s4driver** · 01-24-2013, 02:42 PM

Can someone share the code I can try to reformat the data in the attached file from Sheet1 to the format in Sheet2?

The code needs to work on source files that are dynamic, the number of rows and the number of columns in the file(on Sheet1) can change.

Sheet1 would be the source data and Sheet2 represents the desired output. See notes on Sheet2 for other details about the output.

Thanks in advance, S4

**p24leclerc** · 01-24-2013, 05:47 PM

Do you want data to be erased from Sheet2 when macro is run?

**s4driver** · 01-24-2013, 07:28 PM

No, Sheet2 would originally be blank. Looking to keep source data on Sheet1.

thanks

**p24leclerc** · 01-24-2013, 10:06 PM

Will column "Charges" be always at column S? This means there will always be only 15 PO columns.
Is that right or when you say DYNAMIC you mean column CHARGES can be anywhere in the sheet?
Can you make sure there will always be an empty column between the last PO and CHARGES columns?

**s4driver** · 01-25-2013, 09:02 AM

No not necessarily, Charges will not all\way be column S. The there won't always only be 15 PO columns. That is one part of the file that will be dynamic, number of PO columns will always vary. The CHARGES column will always be to the right of the PO columns and yes there will always be a empty column between them.

thanks

**p24leclerc** · 01-25-2013, 12:43 PM

Please try this macro. It seems to work with the data you supplied and with some test I also performed. I assumed that multiple POs where gathered on the left inthe columns like they are in your sample. If you have empty cells between PO in a row, the macro will not work. It is programmed to stop at the first empty colomn.

Please Login or Register  to view this content.

I also attached a workbook with the macro. Remark that the macro will erase any data on Sheet2 to make sure it starts from scratch.

**s4driver** · 01-25-2013, 01:12 PM

thanks, it works great. I just needed to remove one line,

Range("PO_R").ClearContents

and it was quick. great job.

S4

Need dynamic macro to reformat data from one tab to another

LinkBack

Thread Tools

Rate This Thread

Display

Need dynamic macro to reformat data from one tab to another

Re: Need dynamic macro to reformat data from one tab to another

Re: Need dynamic macro to reformat data from one tab to another

Re: Need dynamic macro to reformat data from one tab to another

Re: Need dynamic macro to reformat data from one tab to another

Re: Need dynamic macro to reformat data from one tab to another

Re: Need dynamic macro to reformat data from one tab to another

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions