Need Help to Combine Two Macros Into a Single Macro

[gaspower]

Hello,
I have the below two Macros, but I would like to convert into a single Macro.

Macro 1

Please Login or Register  to view this content.

Macro 2

Please Login or Register  to view this content.

Thank you
Jr

[k1dr0ck]

like this? it will run the RAW and then the SETUP macro

Please Login or Register  to view this content.

[gaspower]

Hello,
thank you for the reply. I tried to use the example, but it does not work. I do not believe the "Function GetHeaderColumn" can be at the end. I do believe it has to run before the Dinnerware_setup portion.

Thank you

[scottiex]

I note this part of the code is "ugly".

Please Login or Register  to view this content.

you select raw data and delete it then you are on some un specified sheet where you change the number format 3 times and select a column?

maybe instead

Please Login or Register  to view this content.

But that probably wont fix your issue - maybe we need a sample file and maybe that personal.xlsb code.

[gaspower]

Hello,
I just uploaded some samples.

Running Macros in this order
Dinnerware_Raw
Dinnerware_Setup

Setup is the final output.

[scottiex]

looks like it works aside from your personal xlsb macros, which i think i see what they are doing...

are you putting the code in module1?
what error (incorrect data) did you get when you ran Kidrock's code?

[k1dr0ck]

i would try scottiex's suggestion put all the code in module 1

[bakerman2]

Please Login or Register  to view this content.

[gaspower]

Hello,

Thank you. I have tried scottiex and bakerman2, but I seem to get the attached error. I am getting the carry over to Final Data, but it does not seem to be running,

Columns("C:C").NumberFormat = "0"
Application.Run "PERSONAL.XLSB!RemoveTags.RemoveTags"
Application.Run "PERSONAL.XLSB!SeparateDataBySemiColon.SeparateDataBySemiColon"

But if I run the original macros separate, it all works and I end up with the correct final output.

Thank you,
JR

[scottiex]

looks like an acess privilege error.
do you have a protected worksheet/book here? (although I don't know why merging the macros causes it to suddenly occur)
if so have you set it to user interface only?

Please Login or Register  to view this content.

[scottiex]

Also if we have the personal xlsb code we could just put it in these macros instead of calling it from the personal.xlsb.
then if we gave you code we could know it works in it's entirety.

[gaspower]

Hello,

Sorry about that issue. I have included a text file which shows the other two macros in question.

Thanks Jr

[scottiex]

Does this work for you?

Please Login or Register  to view this content.