Merge 10 workbooks in a sheet

Closed
Report
-
 Rajesh -
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 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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
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
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
So is this sheet 2/ summary sheet going to be created each time you run the macro ?
0
Yes, Correct....
0
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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
Please find the link, here i am uploaded the spread sheet.

http://www.editgrid.com/user/kiranindia1986/Rajesh_Excel
0
you can try software like Bulk File Merger.
0
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