Help on Copying Rows.

**bharatonline** · 01-31-2012, 07:45 AM

Hi There!

This might be a redundant kind of question on this forum.

The scenario is like this:
I work as the executive assistant to the Chairman of my company.
I need to collect data (in forms of rows from various excel sheets that various departments populate everyday morning) to one excel sheet that I send as a daily update to the Chairman.

This is a very monotonous job as there are various directories on the common drive of our intranet where these departments have saved their report workbooks. I need to each of them (around 15, at least) to copy a single row from them.

Even though I am not a computer background guy, I tried to copy and test a few macros from various websites, but none came to my rescue.

Could you please provide some help to me?

We are using Excel 2007 and soon we are to upgrade to 2010 version.

Thanks in advance.

**arlu1201** · 01-31-2012, 08:01 AM

This can be done. I guess from your post that there will be several folders from which you would need to consolidate the data, right?
Why dont you attach a sample file containing some dummy data in the same format as your original data. Also, on a separate sheet in the same workbook provide a list of the folders (atleast a few) so that i can create a suitable code for you. This will save a lot of time in explaining how the code works once its done and also save time in specifying the requirements for the code to work.

**bharatonline** · 01-31-2012, 08:23 AM

The File about marketing is with various sales offices like delhi, mumbai, jaipur, ahmedabad, kolkata etc.
The purchase workbook contains the data about the suppliers that supply raw materials to our various factories in vadodara, nasik, punjab, up etc.
the HR is about the candidates that are being interviewed and eventually hired in various offices.

I have a master file of those workbooks where I consolidate the data. The files that the offices maintain are strictly for those offices only, they cannot view other office's files. The workbook that I have (as a master) collects data from all of those files that the offices maintain.

The directory structure is very simple like (NetworkDrive:\Department\Region\City.xls) for example Z:\Departments\Marketing\Punjab\Chandigadh.xls contains all of the data that the office of Chandigadh does in marketing.

This is just a sample data.

I learnt a bit of programming way back in 2001 and 2002, but all have been washed off after a decade!

But I would surely try to analyze the code that you would provide.

Nevertheless, I wholeheartedly thank you for your abrupt help!