Hi
I need a function that will mirror the main tab that contains merged cells but shows the merged range as unmerged with the data drom the merged present.
Its hard to explain so i have uploaded a Doc with a demo of what i need. I have also put a Macro in there that may be modified to a function?
The Main tab needs to stay untouched.
Thanks
Rob
Merge to mirror.xlsm
Hi,
Regards
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
Hi
I have replicated and slightly edited to fit and im almost there.
The only bit i cannot get on the edited code is on the mirror tab is to stop it copying the users names in the other columns.
It was a lovely piece of coding thank you
Rob
Merge to mirror.xlsm
Hi Rob,
For MergeMain2(), MergeMain3(), MergeMain4() subs, you can delete the first column, for example :
Many thanks for the reputation pointPlease Login or Register to view this content.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks