Macro

**zmalach** · 07-11-2008, 07:32 AM

http://www.excelforum.com/showthread.php?t=640124

Bear in mind I am new to VBA!

I have copied the same code that Leigh wrote but it didn't work for me, maybe because my issue is different.

What I am trying to do is collecting data from different excel files with the same format to the master file which has the format as well so I think it should be easy to do it quickly.

The excel file is matrix that people have to fill it in against their names by putting 0,1,2 or 3 in the right cell.

Is there anyone could help me please

Cheers,
Ta

**ravishankar** · 07-11-2008, 08:07 AM

Hi
We need more info to help you. What is the range of cells you want to copy to master file. how many files you have and where are they located (ie file path)
Ravi

**zmalach** · 07-11-2008, 10:37 AM

Ravi,

The range is dynamic so any user could add columns or rows but my first cell is B4 than it goes right and down.

The macro should work with any selected excel file, the files will be located in "C:\Documents and Settings\Zmalach\"

Thanks
Zmalach

Originally Posted by ravishankar

Hi
We need more info to help you. What is the range of cells you want to copy to master file. how many files you have and where are they located (ie file path)
Ravi

Macro - Collect data - Select folder and loop through all xls files

LinkBack

Thread Tools

Rate This Thread

Display

Is not working for me

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions