Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking one column or varying range to another column using same f
I am trying to develop a template and need to have information from one
column on sheet1 after being entered to automatically fill in another column on sheet 2. I also need the formatting to copy from one column to another. Basically the fill in color, font style, and font color alternates after a few rows to differentiate between them, so like in my example, the fill in color alternates between green and white, and you may have 2 to 3 rows white and the next bunch of rows green. Also the number of total rows will vary from one file to another and I need it to copy only the rows that are used. Any help would be appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Program Column B to record numerical range based on number in colm | Excel Discussion (Misc queries) | |||
Match function...random search? | Excel Worksheet Functions | |||
CountIf first column range = "Word" and second column range <> 0 | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |