LinkBack URL
About LinkBacks
i would like to copy result from each sheet (Emp1, Emp2, Emp3 etc) into sheet (Consolidated Result).
User will add or remove the Emp sheet depending on the no of employee we have.
Appreciate if any expert here can help me. Thank you in advance.
i would like to copy result from each sheet (Emp1, Emp2, Emp3 etc) into sheet (Consolidated Result).
User will add or remove the Emp sheet depending on the no of employee we have.
Appreciate if any expert here can help me. Thank you in advance.
Try:
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Thank you so much! it works perfectly and save a lot of time.Originally Posted by Mumps1
Try:
Please Login or Register to view this content.
Dear Mumps1,
Sorry may i get your guidance again if i would like to add 1 more condition, how can i add it into the code? This is to pick up different cells data in LM* sheet.
If ws.Name Like "LM*" Then
If ws.Range("J2") <> "" Then
With desWS
.Cells(.Rows.Count, "A").End(xlUp).Offset(1) = ws.Range("J2")
.Cells(.Rows.Count, "B").End(xlUp).Offset(1).Resize(, 4).Value = Array(ws.Range("M14").Value, ws.Range("M29").Value, ws.Range("M44").Value, ws.Range("M46").Value)
Last edited by yllew; 07-06-2022 at 09:07 AM.
Please post an updated file and explain in detail what you want to do.
This is the updated file. LM_* sheet will have different numbers of row, so the cells will be different from Emp* sheet, but they will consolidated together.
Try:
Please Login or Register to view this content.
It works, thank you!!
You are very welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks