Re: $$Excel-Macros$$ populate consecutive numbers in discrete rows with other text

2011-08-08 Thread dguillett1
; End Sub -Original Message- From: deej109 Sent: Monday, August 08, 2011 1:37 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ populate consecutive numbers in discrete rows with other text I have two adjacent columns of consecutive numbers, spaced several rows apart each. For exa

Re: $$Excel-Macros$$ populate consecutive numbers in discrete rows with other text

2011-08-08 Thread Venkat CV
* Hi , Try Below see if helps else please attach some sample workbook **="#"&A1&" "&"Story"* *Best Regards,* *Venkat * *Chennai* On Tue, Aug 9, 2011 at 12:07 AM, deej109 wrote: > I have two adjacent columns of consecutive numbers, spaced several > rows apart each. For example: > > A

$$Excel-Macros$$ populate consecutive numbers in discrete rows with other text

2011-08-08 Thread deej109
I have two adjacent columns of consecutive numbers, spaced several rows apart each. For example: A B 149 | #149 Story 150 | #150 Story I know how to create consecutive numbers in column A. Is there a way to automatically populate the numbers in column B? Is there a way to combine