I need to move only the cells that have the data in font size 16 from column B to column C. The other font sizes in column B are 11 and 12.
How do I do that in a couple moves?
I have over five thousand entries in that worksheet.
Thanks!
I need to move only the cells that have the data in font size 16 from column B to column C. The other font sizes in column B are 11 and 12.
How do I do that in a couple moves?
I have over five thousand entries in that worksheet.
Thanks!
What do the 16 pt data have in common?
Ben Van Johnson
Dates
I.e. Birth dates
Select column B copy and paste in column C. Click on Find, click on Format and choose 11. Click on Find All. Ctrl + A to select all that was found. Click the X to close the dialogue. Hit DELETE. Reselect column C and click on Find, click on Format and choose 12. Click on Find All. Ctrl+A to all that was found. Click the X to close the dialogue. Hit DELETE.....done!
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
you can call =GET.CELL() using name manager in an xlsm workbook
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks a Lot for your help!!
Thank you for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks