| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto-populate, Auto-copy or Auto-fill?
I'm trying to work with an export from a Lotus Notes db <grumble. My first
column contains sporadic entries (with blank cells between), as each of the column A entries are associated with column B entries in the rows where the column A cell is empty. For example: red apple firetruck wagon yellow canary lemon If cell A1 is "red" in my example, how can I autopopulate A2-A4 to also be "red" and A6-A7 to autopopulate with "yellow" based on that value in A5? Is there some formular expression that I could use. I'm not VisualBasic skilled, but could something simple be done there? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto populate with value | Excel Discussion (Misc queries) | |||
| Auto tab- Auto fill | New Users to Excel | |||
| is there a way to auto copy cells similar to auto sum? | Excel Worksheet Functions | |||
| excel auto fill needs to be have default action (series,copy...) . | Excel Discussion (Misc queries) | |||
| Set default in auto fill options, I always want to copy cell, som. | Excel Discussion (Misc queries) | |||
Threaded Mode
