General discussion


Ms Excel Databases

By niveadavis ·
I have a Macro that takes Data entered on a "Data Input" type of Spreadsheeet (1) and copies/transfers the data as well as insert a new row for data to be placed to another spreadsheet (2). Some of the fields are formatted in such a way that if the data is outside a certain range the data which is a number goes red. However when i try to transfer the data to Spreadsheet (2) the red formatting disappears and is replaced with automatic. PLEASE HELP!

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by LiamE In reply to Ms Excel Databases

Add lines to the macro to format the target cells appropriately - otherwise you will only carry data across as you have noticed.

Back to Windows Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums