How do i save a shet independently from the excel book
Hello, im having an issue with a inventory book that ive created, basically i have 2 sheets, one of them its the inventory one that gets updated wen i get a sale on the second sheet (the sales one), but now the problem is that i want to be able to save the data adquired from the formulas in the first sheet (the inventory one) while deleting the information of the second sheet (the sales one).
Ill add the link of the excel book, please help.
http://imgur.com/a/4oewA
Please Login or Register to view this content.
Last edited by mehmetcik; 12-31-2015 at 03:29 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Hi, and thank you in advance for the help, i was wondering if theres any problem if i try to run the macro in a excel document that its in spanish, ive been trying to run it but i get "error in the compilation Sub or Function has not been defined", im guessing its because of the language difference.
Happy new year! Ty for the aid.
I don't know VBA but I don't think the language has anything to do with it. Looks like a typo. Perhaps ( just guessing, don't throw stones at me)
Please Login or Register to view this content.
my Apologies try this:
Sub Macro3()
[CODE]MYPATH = ActiveWorkbook.Path
Sheets("sales").Copy
ChDir MYPATH
ActiveWorkbook.SaveAs Filename:= _
MYPATH & "\Sale " & Replace(Date, "/", "-") & ".xls.xlsx", FileFormat:= _
xlOpenXMLWorkbook, CreateBackup:=False
ActiveWindow.close
End Sub[/CODE.
Last edited by mehmetcik; 12-31-2015 at 03:33 PM.
Mehmetcik, i wasnt able to use the second command either, but the one that Pepe shared was succesfull, thank you any way, now, the thing is even tho im able to save the inventory sheet independently from the book (wich is great) im not able to reopen the sales sheet on the same file and make them work together, im guessing that the formula that was linking them together got broken, if you have any suggestion please drop them, thank you in advance, youre both very kind and i hope you have a happy new year :D!
Still trying to figure out how to save the values of the inventory sheet independently from the sales one, and then re-link them to be able to keep on updating the inventory stock :S, please help, ty in advance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks