Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populate First Empty Cell In each Row with Text Values
Hi All,
Dynamic Named Range "Budget" comprising 60 static Rows and many (dynamic) columns. Named Range "FirstEmptyCell" comprising 60 static Rows and single column. Houses the cell references of the First Empty Cell in each Row of my Named Range "Budget". Two columns (60 Rows each) house Text Values: Named Range "Review" comprising 60 static Rows and single column. Named Range "Decision" comprising 60 static Rows and single column. Both cells on each row should be concatenated. The concatenated Text Values should then be entered in the First Empty Cell of each Row of my Named Range "Budget". The designated First Empty Cell for each Row of my Named Range "Budget" is provided by the Named Range "FirstEmptyCell". Summary & Required Result: I would like a VBA script to automate the above: placing the two text values from Named Range "Review" and Named Range "Decision" in the First Empty Cell of each Row of my Named Range "Budget". Thanks Sam -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to populate next empty cell? | Excel Programming | |||
Populate cell values with sheet names | Excel Programming | |||
Populate cell values with sheet names | Excel Programming | |||
Can we make a cell behave like a list box and populate it with values for selection. | Excel Programming | |||
Want to be able to click on a cell and have a list box appear to give values to populate a cell | Excel Programming |