View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] amorrison2006@googlemail.com is offline
external usenet poster
 
Posts: 36
Default Excel Formatting - Think I'll need a macro for this

I have an excel sheet within a large file that contains one sheet with
a large dump of data another sheet with column with names of things I
want formatted.

I want a macro that will find the words in sheet 2 column A and then
look into sheet 1 and then format the cells next to that word in cells
B, C, D, E and F. I want to double underline the cells and place a
line above the cells.

I'm sure this can be done but I'm a novice to this stuff.

Hope someone can help me,

Thank you

Andrea