keyongtech


  keyongtech > excel.* > excel.worksheet.functions > 11/2003

 #1  
11-25-03, 11:17 PM
Brenda
Is there anyway of naming cells in a worksheet? What I am
trying to do is within a worksheet be able to put in an
amount and call that amount brand or competitive, then
create a recap with all the amounts that are
considered "brand". Can anyone out there help???

Thanks in advance!
 #2  
11-25-03, 11:24 PM
Don Guillett
Why not just use an adjacent column with b or c in it?
Similar Threads
Range naming cells with blank cells through coding

Hi, Through macro, how do I name a range which consists of blank cells in between. The range will be derived dynamically, where only the starting cell is known. For...

naming cells

I have named my cells so there is no formula only names, yet it only shows the cells formula not the name in the formula bar. what am i doing wrong

naming cells

i have the numbers 1 to 80 in a column of cells. i want to name these cells num1, num2 ..... num80. is there an easier way to do this rather than clicking on each cell and...

naming cells

How do you name a cell so you can use it in a formula? I want, say, a,10 to be "Social" or something. Is this possible? thanks john

Naming Cells

When I try to name a range of cells, the sheet name is automatically included. Is it possible to exclude the sheet name so that the same cell range can have the same name on...


All times are GMT. The time now is 02:34 AM. | Privacy Policy