How do I assign a text value to a variable number of rows?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet that contains up to 4000 rows of data. I want to assign a
unique name a variable number of rows based on the outcome of a formula in
another sheet. Let me try to make it clear: I have the 4000 rows of
information. I have 50 people that I want to assign the information in these
rows to. Based on the varible the frist person has the first 483 rows. The
second has the next 235 and so on until they are all assigned. Is this
possible to do in Excel?
 
yes, but you need to give us more detail.

if range("a1")=2 then
range("a2:a200").name="Bill"
 
I appreciate your help. Let me try to describe it better.

if range("a1")=100 then range("a2:a100").name "Bill"

Then I want the next name to be assigned to the following rows
if range("b1")=125 then range"a101:a226".name"John"

How can I do this so that the new name starts 1 cell after the last name
ends. I have over forty names to do this for. I've been trying for hours to
figure it out.
 
<<<"I've been trying for hours to figure it out.">>>

For 40 names, it wouldn't take more then 15 or 20 minutes to do it
manually.<g>
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


I appreciate your help. Let me try to describe it better.

if range("a1")=100 then range("a2:a100").name "Bill"

Then I want the next name to be assigned to the following rows
if range("b1")=125 then range"a101:a226".name"John"

How can I do this so that the new name starts 1 cell after the last name
ends. I have over forty names to do this for. I've been trying for hours
to
figure it out.
 
What is that supposed to mean? I'm looking for help to solve a problem that
I can't figure out for myself, not a critique on how long it should take me
to do it.
 
I offered you the help of my opinion, that sometimes, the cure may be worse
then the illness.

If your goal is to complete a project, then follow my suggestion and do it
manually, so that the cost of the project (to you ... or to the client) does
not become prohibitive (time *is* money).

If, on the other hand, you're just looking to prove a point to someone,that
"it" can be done much easier and/or quicker, then by all means, keep
checking back here until someone does come up with a viable suggestion.
 
You can use a for/each loop adding the number to the last one using the idea
I gave you.

BTW. It is NOT useful for you to jump on those trying to offer assistance.
Sometimes we like a little humor around here.
 

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

Assign Selection to a Variable 2
Formula for assigning distinct name to first instance in a list ofduplicate rows. 1
Function in Excel to count and list number of entries of text valuesin a row. 2
How do I enter a new row every 12 rows in a very large spreadsheet 3
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
average of non-contiguous range based on criteria 3
Comparing the values in two cells, then counting how many differ 2
Assigning a variable 3

Back
Top