Home |
Search |
Today's Posts |
#1
|
|||
|
|||
need to fill cells automatically
I've imported a data file into Excel that has a unique 'key' value in column
A and a list of associated values in Column B. The number of values in column B will vary and the 'key' value in column A only appears once per set of associated Column B values. I need to fill in the blank cells in column A with the 'key' value so that each row will have a values in A and B. This is too large a file to do manually with a manual fill-down each time a new value in column A is encountered. Any suggestions or solutions? |
#2
|
|||
|
|||
try this. modify to suit
Sub fillincolumn() For Each c In Range("h1:h8") If c = "" Then c.Value = c.Offset(-1) Next End Sub -- Don Guillett SalesAid Software "Feltond" wrote in message ... I've imported a data file into Excel that has a unique 'key' value in column A and a list of associated values in Column B. The number of values in column B will vary and the 'key' value in column A only appears once per set of associated Column B values. I need to fill in the blank cells in column A with the 'key' value so that each row will have a values in A and B. This is too large a file to do manually with a manual fill-down each time a new value in column A is encountered. Any suggestions or solutions? |
#3
|
|||
|
|||
Select column A and F5SpecialBlanksOK
With the blanks selected type an = sign in activecell. Point with cursor to cell above with 'key' and hit CTRL + ENTER. The 'keys' will fill down. Copy Column A and Paste Special(in place)VlauesOKEsc. Gord Dibben Excel MVP On Fri, 18 Feb 2005 14:01:03 -0800, "Feltond" wrote: I've imported a data file into Excel that has a unique 'key' value in column A and a list of associated values in Column B. The number of values in column B will vary and the 'key' value in column A only appears once per set of associated Column B values. I need to fill in the blank cells in column A with the 'key' value so that each row will have a values in A and B. This is too large a file to do manually with a manual fill-down each time a new value in column A is encountered. Any suggestions or solutions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
Change a cell's fill color dynamically? | Excel Discussion (Misc queries) | |||
Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions | |||
Fill blank cells | Excel Discussion (Misc queries) | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) |