How to populate a bunch of cells at once

D

Danny

My spreadsheet is huge and I would like the user to be able to populate an
entire chunck of cells in the colum based on some criteria.

So, if the user enters a value in one cell, a prompt could come up and ask
"would you like to populate all the cells with this value that have the
color red as the key" etc etc.

Please give me a hint as to how to go about it. Once I get the idea, I will
be set.

Thanks so much
 
F

Frank Kabel

Hi
maybe not what you're looking for, but:
- select all desired cells
- enter your value
- finish the entry with CTRL+ENTER (not with a single ENTER)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Moving a bunch of data 1
Populate cells based on row selection 1
Using vlookup to populate multiple rows at once 5
Populate cell if another cell is a certain weekday 1
Keeping cells colored 8
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Populate 'To' recipient on custom mail form 0

Top