I receive peoples' Sports Picks via email, from a 3rd party form processor.
I then copy their picks, go to Excel
and execute this Macro: (Just recorded
with the Macro Recorder)
ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:= _
, FieldInfo:=Array(Array(0, 1), Array(6, 1)),
What I would dearly love it to do is:
* Look up the reference in BU77
* Find that in the range J67:BB67
* Paste into rows 68-77 below where it finds that reference.
If someone could also insert some code to
automatically click "OK" when the
dialog asking "Do you want to replace the contents of the destination cells?"
into the "Text to Columns" code above, that would be like heaven!!
Thanks for your time and attention!