asked on
Save Excel as individual workbook
Hello EE,
Can someone please help me with excel macro to save excel tabs as individual workbooks? My large excel file has formulas and charts. I will like a macro to copy and paste values prior to saving as individual workbooks into the same path.
Thanks in advance for your help.
Can someone please help me with excel macro to save excel tabs as individual workbooks? My large excel file has formulas and charts. I will like a macro to copy and paste values prior to saving as individual workbooks into the same path.
Thanks in advance for your help.
Microsoft Excel
Last Comment
fb1990
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
xtermie, thanks for the solution. Is there a way to just save the spreadsheet out after the paste value and not take away my formulas from the master file?
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Good comment and suggestions provided but not feedback on final outcome or awarding of point from the author
ASKER
Hello xtermie,
Please accept my apology. I have been out of pocket for a while now. I needed to award the point and close the request. I can't seem to find where to do that
Please accept my apology. I have been out of pocket for a while now. I needed to award the point and close the request. I can't seem to find where to do that