Macro to list numbers
- From: tryer <tryer.1u4lyn_1124647542.9854@xxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 21 Aug 2005 12:38:40 -0500
I have a column of numbers say 1 to 10 in column A
In column B at various rows there could be a number. This is the number
of times I need the number in column A repeated in column C eg.
"A2 to A20" have the numbers 1 to 19
if "A3"has the number 2 and "B3" has the number 4 then "C2 to C5"
should have number 2 in them. If the next number in column "B" was say
"B8" and this was 1 then "C6" would be 7
I have been trying to write a macro for this. I have got as far as
going down column A and identifying how many rows are populated and
then got stuck.
Help would be appreciated
--
tryer
------------------------------------------------------------------------
tryer's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16546
View this thread: http://www.excelforum.com/showthread.php?threadid=397592
.
- Follow-Ups:
- Re: Macro to list numbers
- From: hideki
- Re: Macro to list numbers
- Prev by Date: Re: Bug: Command Button Text Size Changes
- Next by Date: Real Estate Rent Record Databast
- Previous by thread: Re: Macro to list numbers
- Next by thread: Re: Macro to list numbers
- Index(es):
Relevant Pages
|
