Hi,
The following code was provided to me last night (thanks a bunch!!), but as I also need to identify which provider is responsible for the different sections that are listed, I have modified the sheets being copied to have the provider's name listed in column A for each row. When I changed the range to incorporate the changes I am now getting the following error:
Runtime error 1004 - Application-defined or object-defined error.
The line highlighted by the error is:
Another issue I have is the merged cells that are in the worksheets being copied. If I use the PasteValues option, I get an error that the merged cells must be the same size.
I need to use paste values to pull the doctors name in as column A on the source worksheets has a formula to populate that.
the code now reads: I have also attached a revised version of the example worksheet
the code is listed in Module5
Example Worksheet-3.xlsm
Any help is greatly appreciated
Carole
Bookmarks