i have two sets of figures (1 pink & 1 blue) i am looking for a way in which i can drag/drop or copy paste. Both sets have an identical " ID " no. as a help.
can any one suggest how this can be achieved
i have two sets of figures (1 pink & 1 blue) i am looking for a way in which i can drag/drop or copy paste. Both sets have an identical " ID " no. as a help.
can any one suggest how this can be achieved
Well as far as I know there is no drag and drop function. As far as copy and pasting, why dont you turn on the macro recorder and do the steps you want accomplished and see if that would suit your needs. If not post back and someone can help further.
Peace of mind is found in some of the strangest places.
It's not clear what you're trying to achieve. As Austen said, there is no drag and drop, but there may be other ways to move your data.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
I downloaded the attachment - there are no blue figures.
Column M?Originally Posted by Norie
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Colour blind as well as short sighted.
I could have sworn I looked there.
i have just down loaded the file and the colums "A:G" are pink font and "M:Q" are blue fontOriginally Posted by Norie