Results 1 to 6 of 6

Thread: Macro Button to tranfer data from column to column.

  1. #1
    Seeker Daddy007's Avatar
    Join Date
    Jul 2016
    Posts
    13
    Articles
    0
    Excel Version
    Excel 2010

    Unhappy Macro Button to tranfer data from column to column.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.
    Attached Files Attached Files

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    767
    Articles
    0
    Excel Version
    Excel 2010 64bit
    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?

  3. #3
    Seeker Daddy007's Avatar
    Join Date
    Jul 2016
    Posts
    13
    Articles
    0
    Excel Version
    Excel 2010
    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.

  4. #4
    Seeker Daddy007's Avatar
    Join Date
    Jul 2016
    Posts
    13
    Articles
    0
    Excel Version
    Excel 2010
    oh, yes the content will always be numeric.

  5. #5
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    767
    Articles
    0
    Excel Version
    Excel 2010 64bit
    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.
    Attached Files Attached Files

  6. #6
    Seeker Daddy007's Avatar
    Join Date
    Jul 2016
    Posts
    13
    Articles
    0
    Excel Version
    Excel 2010
    Thanks NoS,

    This macro will do nicely.

    Thanks for making life a little less complicated for me.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •