Merging
Columns of table are:
Refno/surname/forename/department/sunday/monday/tuesday/wednesday/thursday/friday/saturday.
Each row has refno/surname/forname and department with entrys in them. And one of the columns from sunday ---> saturday with hours noted.
I have created a macro to get them in this form and now need the last step to merge them.
Please view screen shot to see a detailed description.
Can i add some futher code to my macro so it can also merge the
i would like to merge them to rows with the same refno/suranme and forname. THE DIFFERENT DEPARTMENT SHOULD ALL BE PLACED IN ONE CELL.
please view attached image for description
Hi
Can you please attach an example workbook with the example data.
rylo
When you say "Yellow to be changed to below grey"....do you mean that? OR did you mean the yellow should be left there and the grey should be added below the yellow like your example sheet?
Yes, please, do post a sample worksheet.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks