M mahen Registered User. Local time Today, 20:38 Joined Jan 13, 2008 Messages 56 Mar 28, 2014 #1 Required a macro to change whats in D8 and L19 as cross way in like D21 and O29. Dates can be easily get cross way but the rest need to be. See attachment. Attachments Book2.xls Book2.xls 26 KB · Views: 235
Required a macro to change whats in D8 and L19 as cross way in like D21 and O29. Dates can be easily get cross way but the rest need to be. See attachment.
Brianwarnock Retired Local time Today, 20:38 Joined Jun 2, 2003 Messages 12,701 Mar 29, 2014 #2 You don't need a macro , just Paste Special Transpose Brian
M mahen Registered User. Local time Today, 20:38 Joined Jan 13, 2008 Messages 56 Mar 29, 2014 #3 Brian, Thats it great. Thank you. Mahen
Brianwarnock Retired Local time Today, 20:38 Joined Jun 2, 2003 Messages 12,701 Mar 29, 2014 #4 Happy to help Brian