Need Help modifing a MAS to Excel Report - THX!

Hello there,

Can you tell me how you know that an entry is a store?

Thanks!

Try the following:

Please Login or Register  to view this content.

To insert the code:

1. Make a copy of the worksheet you want to format, so if it doesn't turn out correctly you aren't messing up your original data
2. Press Alt+F8 on your keyboard to bring up the macro window.
3. Clear the macro name field and then type FormatMacro and select the Create option
4. In between the Sub FormatMacro and End Sub copy and paste the above code. Anything that appears in green is a comment meant to help you understand.
5. Close out of Visual Basic
6. Press alt+F8 again and this time select the FormatMacro macro and then select Run.

Let me know if this works for you!

Hello there,

Okay I adjusted the code to reflect your first request but am a little confused by your second.

I could probably do in an easier not macro way.
If you notice that ex4.gif 50-05C, 05-50F, 05-50S and etc are the same salesman person and the C, F, S, etc.. only state the closeout, Fall, Summer, etc... but could you possible integrate all in to one and leave the C, F, S out?

Could you please provide an example of what you are trying to do with the second request?

Thanks!

Try updating the code to look like the following:

Please Login or Register  to view this content.

Alright, thanks.

These a Run-time '91': Object variable or With block variable not set error in the script.

error.gif

Please press the debug button and tell me which line is highlighted. Thanks!

Line 62: rng.Select 'select the columns defined in the rng range

error1.gif

I'm trying to outline and group rows and column but I do it nothing happens Is there something restricting it?

Trying placing

Please Login or Register  to view this content.

above the errored line

If you have already ran the code to delete all the empty rows then the code will error out because there's no rng to access.