Excel

[senthil1971]

Hi,

Can anyone help me out.

I need macro code to import data from multiple excel file with a creteria like date range. suppose if want to import data start from 01/01/2007 to 01/01/2007.

senthil

[Bob Phillips]

more detail, a lot more detail, required.

[senthil1971]

To Open 4 excel data files and to copy into master file. The data files contains day to day transactions. the data file contains following fields

Opening date current date
01.01.2007 01.01.2007
01.01.2007 01.01.2007
01.01.2007 02.01.2007
01.01.2007 02.01.2007
01.01.2007 02.01.2007
01.01.2007 03.01.2007
01.01.2007 03.01.2007

Macro should ask which date to pick and it should copy into master sheet with pastespecial fuction and it close the file. Like wise we have 4 to 5 excel file to be copied into master file regularly.

Could you please help me out.

Thanks in advance

senthil

[OdiN]

This sounds like you would be better off using a database, IMHO.

But still need more information. Probably a sample of the master sheet and the daily sheets to see what/where things are and get an idea of what exactly you want to do.

[senthil1971]

Hi,
Thanks for your response.

I've attached 2 excel files. 1 is master & other is transaction file. Transansaction file data should be copied into master in given date.

thanks

Senthil

[senthil1971]

Hi

can you help me out...??

Senthil

[mdmackillop]

Your sample contains one sample copied down. What use is that? All the dates are the same. Your Post 3 indicates different dates. I've no idea what date you are working with or where it goes. Please take the time to give a proper example.

[austenr]

Dude, you have to hekp us out to hekp you!!

[senthil1971]

Sorry for confusions.

I have a team of 4 members. all of them are having individual excel file, each one has to process invoices and update the status into excel file everyday. Now I have to update that data into masterfile to know how many invoices has been processed by each individuals. for this reason i have to fetch the data from each individual excel file and to be updated into master file everyday. In post 3 i've given different date. suppose if i have to fetch data related to date 03.01.2007 macro should only copy all those data related to 03.01.2007 from each individual excel file to master. That's it. I have attached 2 excel files and one is related to individual data file and another is masterfile.

Hope this helps!

Thanks in advance.

Senthil

[mdmackillop]

I still don't understand; you have three columns of identical dates in your sample. Whatever code I can make up will result in an identical outcome of copying all data to one sheet. You can do this by Copy and Paste.

[austenr]

This may seem like a dumb question, I've asked plenty before, but why not use Access as a collector and import each day using an append query. Unless you are going to massage the data sounds pretty simple to me to do it that way.