Hi,
I have a list in Excel with 15 columns of data. I want to be able to automatically export the data into individual files based on one of the column headings as part of a stock check I run periodically.
At the moment I do it manually by copy and pasting from the main file to individual files, 1 per location that is being checked and doing a save as each time.
I’m sure Excel has a function to do this easier, but I don’t know what it is. Can anyone help?
Do you have a sample file that you can upload?
To Attach a File:
1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.
Also, which is the column based on which the files should be created?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
@arlu1201 where is the Go Advanced option?
The data starts in one file as part of one worksheet and needs to be copied into new files that the Excel will have to create as they can be different each time I run the list.
The column "Location" will be the file name.
I have in the region of 700-1200 rows of data each time I run this, but that goes to around 20 files.
Date 13/02/2013
Stock No / Reg No / Location / SOff. / Series / Description / Cab / Body / Status / On Site / Comments
0000482528 / BF59DBV / HRVS Scunthorpe / GV61 / TGX / 26.440 / XLX Cab / Tractor / Ordered
On site and Comments columns are blank for the guys who do the stock check to fill in.
Last edited by VladTheMorris; 02-14-2013 at 09:59 AM.
The Go Advanced button is the 2nd button in your Quick reply box. See below at the right hand side.
Stock Check Test - Excel Querry a.xlsxSorry, I was looking in Excel for the advanced option.
Please find attached file. I've entered some basic data.
So all columns from A to K need to be copied over to the new files?
Hi, Yes. Columns A-K and Rows 1-3 on each file.
'SHEET1 TO MANY WORKBOOKS
Here's a macro for parsing rows of data from one sheet to many workbooks based on one column, workbooks named for the same values oin that column.
My macro names the workbooks for values in the column PLUS today's date, you can take a stab at removing the date part...or leave it in, it's a good technique.
Attached is an edited version of that macro for your workbook.
Last edited by JBeaucaire; 12-27-2019 at 10:24 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks for the feedback. If that takes care of your original query, please select Thread Tools from the menu above and mark the thread as solved. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks