Opening files,copy data, and close file

[trinidad2011]

VBA RELATED POST

Hi!

I am struggling with macro writing. I am new, and i would be delighted to get a response.
I have about 3 GB worth of files to open, select some data from it, copy into a new worksheet1, open the next file, copy data from it, paste into the worksheet1 and so on. i need to do this with all files.

Each file has 5 columns. one with date, time, latitude, longitude and amplitude.
I need to conditionally select data from the latitude and longitude columns and paste them along with their corresponding date, and time into a new workbook, with a new file name.

The files each have a total of 32001 rows, including the title rows.

The conditions that i need are the latitude values should be within -37.9382 and -32.004 and the longitude values should be within 136.7754 and 141.0698. all rows which do not satisfy this should be deleted.

i am completely new to macro excel writing and i am completely stuck.
I have attached the excel file that i am trying to work with.

Extremely looking forward to your reply,
Trinidad2011

 

[texasalynn]

ok so a little clarification

select some data from it, copy into a new worksheet1, open the next file, copy data from it, paste into the worksheet1

does every file get a new file to copy into or does every file get copied into the new file in a different sheet?

all rows which do not satisfy this should be deleted.

then this part I'm not sure do you want to delete data in the existing files or in the data you copied?

 

[trinidad2011]

Hi!
i appreciate your reply.
I somehow posted the same question in another section of this forum, and my question has been answered.
here is the link for anyone who was looking for an answer to a similar problem.

http://www.mrexcel.com/forum/showthread.php?p=2709999&posted=1#post2709999

this forum is so useful, i am grateful for having run into it
thank you for all of the tutors who kindly give the public some help!