Macro Button to tranfer data from column to column.

D

Daddy007

New member
Joined
Jul 15, 2016
Messages
13
Reaction score
0
Points
0
Excel Version(s)
Excel 2010
:redface: Please help, need a Macro Button.b

To remove all one digit and two digit cells in column C and column E.

To be transferred to Column K and Column L.

Column C to Column K
and
Column E to Column L


Thanks for any help on this workbook.
 

Attachments

  • WorkBook2019.xlsm
    11.5 KB · Views: 12
Not all cells are formatted the same.
Is it the actual content in the cell you are concerned about or the way the content is displayed?
Will the content always be numeric?
 
Its the way the content is displayed.

All my content always come as column C and column E displayed.

It would be perfect to have a macro button to automatically display the content always exactly like Column K and Column L.

Thanks for any help.
 
oh, yes the content will always be numeric.
 
Perhaps this will be of some use.
The results are written to columns P and Q so you can compare them to what you require.
 

Attachments

  • WorkBook2019_v2.xlsm
    23.3 KB · Views: 14
:smile: Thanks NoS,

This macro will do nicely.

Thanks for making life a little less complicated for me.
 
You must log in or register to reply here.
Back
Top