Changing destination of macros output

[jeck876]

I am not that advance VBA but I found a long complicated VBA code that solved a major issues i had. I needs 3 excel files to be combined into one large file.

The issues i have is that it gives me the output as a new work book. When i need it to be included in the current workbook, specifically on a sheet called "Formatting Macros" starting in cell B1.

I am lost in the code and do not know how to change this.

Please Help! and thanks in advance.

He is a copy of the VBA code:
_____________________________________________________________________________________________

Please Login or Register  to view this content.

[xladept]

Hi jeck,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Like This:

Please Login or Register  to view this content.

*See if that works

[jeck876]

thanks for the info about how to properly post code....and thanks that worked perfectly!!!

[xladept]

You're welcome and thanks for the rep! Glad it worked perfectly, because I often overlook something

[jeck876]

i spoke too soon. lol. i have formulas that began at column I of the formatting macros sheet... they are getting deleted now... (the data in the workbooks that are being consolidated only go up to column H.) any solutions?

[xladept]

Try changing that red "B" back to "A"

[jeck876]

figured it out...had to change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

thanks for your help

[xladept]

You're welcome! Glad you got it!