Previous Topic Next Topic

Merge 10 workbooks in a sheet

Closed
Rajesh - May 15, 2010 at 11:44 PM
 Rajesh - May 22, 2010 at 02:38 AM
Hello,

I wanted to create an application using macro.

I have 10 excel work books, i wanted to merge that all excel workbook into one work book. (Only 1st sheet).

Then from the one work book i wanted calculate some calculations.

Eg: from the column "A" if a cell matches "Cat" then i want the count that how many time that type of instance happened. i.e duplicates. Like this i have list of values i.e Cat, Tiger, Horse.....etc. that i wanted to enter in sheet2 when running the macro.

2. Next condition is if column "A" matches "Cat", i have "timings " in Column "J", that i have to calculate i.e total time of Column "J" that is "Cat" existing in Column "A".

Please help me to solve this, i know its confusing please feel free to ask queries.




2 responses

Answer 1 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 16, 2010 at 09:25 AM
A lot is missing in this. Have you tried o use macro recorder feature of excel to record your action ? It will give you a template as a very solid base
0
Rajesh
May 16, 2010 at 09:04 PM
Yes, I tried, now i can merge all sheets into one. Now i have lot of conditions that i am not able to use.

Help me to solve.

After merging Now i have 1 sheet with 7 Columns.

In 1st column i have employee names, 2nd column i have list of task that completed for the day ,in the last column i have total time taken for task to complete for the day and in the 3rd column i have dates.

Now i wanted to define all the task and employee name with total time taken for the entire month in sheet2.

Like, in sheet2

Task Name: Project Management:

Emp Name Total Time Taken

Roy 4:10:25
Lord 8:01:21

Task Name : System Management

Emp Name Total Time Taken
Roy 2:10:03
Lord 1:11:13
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 17, 2010 at 06:02 AM
So is this sheet 2/ summary sheet going to be created each time you run the macro ?
0
Rajesh
May 17, 2010 at 09:04 PM
Yes, Correct....
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 18, 2010 at 07:04 AM
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee.
0
Cool
May 20, 2010 at 10:10 PM
Please find the link, here i am uploaded the spread sheet.

http://www.editgrid.com/user/kiranindia1986/Rajesh_Excel
0
Answer 2 / 2
fd
May 21, 2010 at 05:04 PM
you can try software like Bulk File Merger.
0
Rajesh
May 22, 2010 at 02:37 AM
Yes, I tried, now i can merge all sheets into one. Now i have lot of conditions that i am not able to use.

Help me to solve.

After merging Now i have 1 sheet with 7 Columns.

In 1st column i have employee names, 2nd column i have list of task that completed for the day ,in the last column i have total time taken for task to complete for the day and in the 3rd column i have dates.

Now i wanted to define all the task and employee name with total time taken for the entire month in sheet2.

Like, in sheet2

Task Name: Project Management:

Emp Name Total Time Taken

Roy 4:10:25
Lord 8:01:21

Task Name : System Management

Emp Name Total Time Taken
Roy 2:10:03
Lord 1:11:13


Please find the link, here i am uploaded the spread sheet.

http://www.editgrid.com/user/kiranindia1986/Rajesh_Excel
0

Similar discussions

How to merge WhatsApp backup from old phone to same WhatsApp
WhatsUpWae -
HelpiOS -

1 response