import

[Adrain]

Hi
I was wondering if I could, import a file to an Excel file worksheet form another Excel or *.cvs file, and update the table that's it's been imported to?
Example bank statements, I was hoping to make a Excel file with a workbook of a bank statement that has particular dates. Say a month, worth, then import a CVS file and update and add to the workbook on the sheet without replacing and duplicating information from it.
In which I can run and update a pivot table from.
Is this possible through VBA? Which I assume it is, but unfortunately I have not found any information to do this. So appreciate any help or to be pointed in any direction to help with this problem.
Thanks

 

[Logit]

You want to search for instructions re: "Text To Columns".

Once you have the data properly inserted into a worksheet via the above method you can manipulate it as required.

 

[Adrain]

You want to search for instructions re: "Text To Columns".

Once you have the data properly inserted into a worksheet via the above method you can manipulate it as required.

thanks for the quick reply, i will try an look that up an see how i go