Hi all wondering if it is possible with google drive, i have a spreadsheet with a few worksheets on it and i was wondering if it was possible to save all the data on a worksheet to a new file in the same folder, under the name in one of the cells. im trying to create a invoice system and need to save each invoice to a new file.
Google Drive will just appear as an "ordinary" folder under your user name. I can see no reason why you can't open a file from there and save an updated version. No different than copying a file from and to a folder.
C:\Users\...user name...\Google Drive
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
sorry what i mean is, is there a way to save it automatic to another sheet so if on my spreadsheet i got say 4 tabs on there, i want to save tab 3 and all the data in it to another file so in saved one it will only have tab 3 now and not the other tabs, does that make scents?
Assuming that the sheet is self-contained, that is, it does not have any formulae that depend on other worksheets, should be easy enough.
Right click on the tab, choose Move or Copy, tick the box that says "Create a copy" and, in the "To book" drop down box, choose "(new book)".
The worksheet will be copied to a new workbook and you can save that to the Google Drive folder.
Regards, TMS
that wont work as it pulls data from other sheets, thats why i wanted to try and save a direct copy of the exact content to a new file.
OK, copy the sheet in the workbook. Select all the data on the worksheet and Copy and Paste Special | Values to make the data static. Then copy the "temporary" sheet to a new workbook. You can Move it rather than Copy it in this instance. Then save the new workbook and send it, or whatever.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks