I invoice using excel and have a folder with hundreds of xls & xlsm files. I want to extract 4 specific fields ; C8;AK4; AK7 & AL11 from each file into a table a new file with NAME, DATE, INVOICE NO & AMOUNT as the headings. I'm not experienced at VBA.
So I created a workbook with an UPDATE tab, and a DATA tab. The Update has the button to run the macro, and the DATA tab houses the column Headers and is where the data is brought in.
I am assuming the source sheet is Sheet1, otherwise you need to change it below.
Please Login or Register to view this content.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
I tried attaching the workbook, but it didnt work. I woner if the 2.5MB size is a problem.
Either way, just create a DATA dab and include column headers in A1:D1
Thanks. Sorted it out. Works great. Much appreciated. Can you tell me how to create the update tab as it would save opening vba & 'f5'ing it?
Google is your friend.
I'm on my phone or I'd send you a link. Look up how to add macro button (with the developer tab). You add the button then link it to the macro. You can have the button on the DATA tab if you want, it doesnt matter.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks