I've been going round in circles with this for a while and can't figure it out!
I have 4 sheets
On sheets 2,3 & 4 if the value in column A is greater than Zero then I would like to copy adjacent contents of column i,
Then I would like to paste values in Sheet 1 column A, remove duplicates and sort.
It seems like it should be simple but I'm getting all sorts of errors and my offset funtion is not up to scratch.
Any help would be greatly appreacted.
Many thanks
Probably useful to post the code you've got and a sample workbook.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Just a sample code due to no workbook attached.
Please Login or Register to view this content.
This is what I have got, I'm well aware it is increadibly clunky! please don't judge.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks