hi All!
I would appreciate some help!
My goal is to create a vba to import filtered data into a workbook.
Ex:
Open Workbook TREAS , create macro, open CSV file named "Notes.csv"
Once notes is open, delete row 2.
Select row 1 and filter this.
Select G1 and filter by A to Z
Once done, select all data in Notes.CSV "CTRL+SHIFT+END" which selects all data in this file.
Copy
Paste into Workbook Tab TREAS.xls starting V38
Close Notes.csv - do not save
I would appreciate any help, im new with vba.
Thanks very much in advance!
1 Replies - 842 Views - Last Post: 30 August 2012 - 09:11 PM
#1
Opening CSV file and Placing it into Workbook - create macro
Posted 17 August 2012 - 02:03 PM
Replies To: Opening CSV file and Placing it into Workbook - create macro
#2
Re: Opening CSV file and Placing it into Workbook - create macro
Posted 30 August 2012 - 09:11 PM
The only help I can give you is to try to do it yourself, and then post when you run into difficulties. We can't do much until you do something.
Page 1 of 1
|
|

New Topic/Question
Reply



MultiQuote




|