Format data with macro

[vijanand1279]

Hi,

I need some help with a macro to format the excel report on the first tab, I have shown the sample output in “Sample” tab. This will be the regular format that is downloaded from the ERP system. However they are not formatted and it requires manual intervention to format as desired. Please help with a macro to format.

Regard,
Anand

[Olly]

Try:

Please Login or Register  to view this content.

[vijanand1279]

Hi Olly,

This works fine. Is it possible to include the respective CHECK # in column G under the confirmation number in col D. Sorry I forgot to mention in my last comment.

Regards,
Anand

[Olly]

Sure. Try this:

Please Login or Register  to view this content.

[vijanand1279]

This worked. Thank you so much.

[Olly]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You can also 'Add Reputation' to those who helped you. Thanks.