Copy Data Columns From CSV paste into Next available blank space

[Matt1998]

Hi

I have some data from many csv files.

I would like to record/create a macros to open the file and paste 4 columns worth of data into another spreadsheet. Making sure the data is pasted in the correct column and doesn't overight data already in a tracker. Ie. paste it into the next available space.

Help is always appreciate.
Thank you

Output.csv

[patel45]

attached file has 8 colummns, you want 4, can you attach desired output ?

[Matt1998]

Sorry yes.

So the input tab is what comes out as a csv and the Ouput tab is what I would like.

However when I have my output master file open I need to be able to run the macro from the input file and paste the columns in the next available cell row within into the output file.

AttachedInput v Output.csv

Thank you
Matt

[patel45]

I don't understand, you are asking for a macro, then you attach a csv file as output, csv file does not support macros.

[Matt1998]

I don't really know what I want. Whichever is the best way to do the task then that would be the way I would do it.

[Matt1998]

The files are saved as an Excel CSV file not a normal csv file. If this helps.

So:
The Input Tab is an example in a csv excel file of what I get.
I'm wanting to get 4 columns from these files and post them into the next available space in another spreadsheet (The output sheet)

Hope that clears things up

[HaHoBe]

Hi, Matt,

there are two ways of approaching: import the CSV via TextToColumns-Wizard and sort/delete the columns to your needs or work on the lines when importing hte text file.

Code will ask for a new of a text file to import. At the moment a new workshett is added, if you like to work on the same sheet the line to clear is commented out at the meoment. Textfile will be imported into workbook which holds the code:

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

Ciao,
Holger

[Matt1998]

Hi Holger. Thanks for this. I'm almost there.

Due to the volume of these files (Daily) - is there anyway that when the macro runs it pastes the data in the next available row, rather than overwriting the data that is already been previously run by the macro.

So say I run the macro it grabs 4 columns and the data goes down to Row 10. The next time I run the macro it grabs 4 columns and pastes the data in row 11 -21 etc ?

Also it does create an extra sheet which is fine I can delete this but I don't need the sheet to be there once the data has been grabbed and pasted.

Further help is massively appreciated.

Thank you all
Matt

[HaHoBe]

Hi, Matt,

you would need to adapt the constant to your needs or live with a new sheet added under the name of the constant and being updated. As there was a header row in the file this will be skipped for each further import:

Please Login or Register  to view this content.

Ciao,
Holger

[Matt1998]

I think I can live with this.

Massive Thanks
Matt