Two Sheets Same Data No Colour

  • Workbook A and Workbook B are the same, as I type info into A its transfers to B. This is fine but when I put a colour (color) into a cell in workbook A the colour dosent transfer to workbook B, is it possible to do this?
    Thanks in advance

  • Re: Two Sheets Same Data No Colour


    Hi Kevin,
    Presumably, Workbook B is just linked to Workbook A, in which case it will only bring through cell contents - not formats.


    You could perhaps try a macro that operates on a change event - and then just copies Workbook A to Workbook B - either by cell, or sheet - depending on what you are trying to do.


    It might help others to help you if you give a few more details about what you are trying to do, then the real Excel gurus on here will be able to help you out (I'm an amateur! :) )


    Regards,
    Dave

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!