Extract Columns from Excel Files then Append to .C
I hope this is not too much, but I badly need help on creating a VBScript for Excel that can:
1. Check if any excel file exists, if there are, open them one by one and do step 2 onwards; if none, do nothing.
2. Copy cells F8:Z8 of Sheet 1 all the way to the bottom where F8 is not null and Paste it to C1 to a new excel file.
3. Then copy the value from A2 and B2 then paste/reiterate it to A1 and B1 all the way to the bottom where F8 is not null of the new excel file.
4. Save the result to .csv.
5. Append all .csv results into one (there are multiple excel source files).
Here’s an illustration:
Re: Extract Columns from Excel Files then Append to .C
I think there is a website that is mrexcel.com. You can get loads of stuffs on getting this done.
And if you need all this function i can get them posted on my website sometime and let you know.I have done some excel macro vba programming where in we automated some database application and we badly needed this architecture.
We have played with the variouys excel sheets , their colour codings, deleted the contents therein as and when we need on some input sequenece, populate them based on some Db results after query execution and bla bla bla.