Hello All, I have a worksheet event that does not seem to work and I am not sure why:
My spreadsheet creates a number of order lines from Q2 to AY50 (could be any number of lines 5, 10 ... depending on the order), now in column S is the web address for the order location this gets copied on every line of the order (i.e. s2, s3...).
Now I have a macro that copies this range of order lines to my tracker sheet but only copies as text so I edited the below code I found on the internet to change the range once it gets to my tracker sheet but it is not working, any ideas.
Please Login or Register to view this content.
Bookmarks