Happy to send you sample spread sheet - please let m ehave an emai address
want 3 items from a list in column B made in to 3 columns BCD
So in operation the aim is I will move cursorto say B10 and macro will copy B11 to C10 and B12 to D10 and return curso to B9. I will them delete B11 and B12 manually and move cursor manually to next location e.g B16 and run macro again etc etc
The datais irregular in an iregular way if that makes sense. The macro literally need to copy the item below where the cursor is to the rght and the item below that to the right. so from
alpha beta delta
beta andd elta are then deleted manually and i move the cursor to the next set of three that i need the macro to transpose.
Is lot of junk in list and hence why only want the macro to do the copy net to eahc other thing - every thung else is manual ie locating the staring item and dletring the copied items
Its a quick and dirty data mining job. Happy to do all the deleting as part of the workflow.
The bit i cant do is the clever bit- transposing the data entry from column to row format. Been at job alll day and losing (lost) ability to type/explain :)
As long as macro turns any 3 item list in to a row - will be fantastic help and return cursor to initial position
please make sirt cur easy to use sicne will ned to use it may be 750 times !!
each operation of the macro starts and ends in the same place - that is where i move the cursor to - it al about saving the copy and paste key strokes
The good news os the macros bit works like a charm , the bad news is that Ctrl M closes the file is a reserved command mac thing apprantly could you give it another short cut say Ctrl B please
Othrwise is fantastic
OK I will sort it out . Thanks for you time
Thanks have a good weekend