Select next cell option

[yiannis1925]

Hello Guys,

Need a small help, I have this macro (see attached)
That runs and opens some files and copy 20 rows of each of this files to second tab of the file.

The problem is that in some files I don't have 20 rows... but I always want to start pasting from 1, 21, 41, 61 etc...

The function in the code locates the last non empty row... so the above is not working and I can't make it take the value from column G "Copy to Location(Start Cell Only)"

Can you please help

this code should adjusted

Please Login or Register  to view this content.

[patel45]

maybe the addresses on columns D E G are wrong, it's difficult to check without seeing the csv files

[yiannis1925]

there is nothing special in tha files... just a range of cells... from A till F and some 10 to 50 rows...
but I need to copy only 20 of them... as mentioned above

[JapanDave]

Try this,

Please Login or Register  to view this content.

[yiannis1925]

Hello JapanDave,

Thank you for your reply...

I tried your code, it opens the files, short them correctly copy that data... but it always copies to A1 cell... All files are copied to A1 cell for some reason... and not A1, A21, A41, etc

Thank you

[JapanDave]

My bad,
I did not correctly copy the code for you. Try this.

Please Login or Register  to view this content.

[yiannis1925]

Once again a big thank you... but still the same thing happens... that was the original problem everything is copied to the A1 cell

[patel45]

it's difficult to resolve without seeing the csv files

[yiannis1925]

Hello Patel45,

Thank you for your reply... as I already replied... there is nothing special in that files...
You can just create them... some from A till F and some 10 to 50 rows...
but I need to copy only 20 of them... as mentioned above

[patel45]

as you can see, for now two users are not able to resolve, do what you like

[JapanDave]

Ahh, I am so stupid.

This will work.

Please Login or Register  to view this content.

[yiannis1925]

That is great!
Thank you