Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro to copy formats
Hi
I am getting a list of data from other department having columns from A to J and around 1000 records. in this list column "J" contains name of clients and there may be 5 to 20 records of each client. I have another Master list of Clients in which I have given separate font and/or cell colour for each client. what I would like to do is to look client name from the Master list of Client and copy the font and/or cell colour to the record ie. A:J Please help me with a macro so that I can save too much time thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro to copy formats
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "shaji" wrote in message ... Hi I am getting a list of data from other department having columns from A to J and around 1000 records. in this list column "J" contains name of clients and there may be 5 to 20 records of each client. I have another Master list of Clients in which I have given separate font and/or cell colour for each client. what I would like to do is to look client name from the Master list of Client and copy the font and/or cell colour to the record ie. A:J Please help me with a macro so that I can save too much time thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy all formats and objects | Excel Discussion (Misc queries) | |||
Copy Conditional Formats on a List | Excel Discussion (Misc queries) | |||
copy formats vlookup | Excel Worksheet Functions | |||
What's the best way to add a row and copy formulas and formats? | Excel Discussion (Misc queries) | |||
Copy worksheets and formats | Excel Discussion (Misc queries) |