Thanks to JBeaucaire the orignal thread "Copy and Paste till last Last Column".
Once I applied this to the macro I then added the following:
So now my entire code looks like this:
That didn't work. I assumed it has to to with the two different LastCol lines of code I have so I went and did the following:
That didn't work so I am now attaching a sample work book with the two macros listed above stored in Module 1 and Module 2 respectively. Module 5 has all the individual commands Ive used to get to this point.
The result i am looking for is to copy the formulas in K3 and L3, which are different from one another, and paste across Row 3 starting in M and ending at the last column with data based on Row 4.
Any help would be greatly appreciated.
Bookmarks