Hi,
Keep the cursor in A1 and run the following code. Here I put the autofill 'C'
column and you will get the required result.
File also enclosed.
Sub autofill()
Do While ActiveCell <> ""
ActiveCell.Offset(0, 2).FormulaR1C1 = ActiveCell.Offset(0, 0)
ActiveCell.Offset(1, 0).Select
Cheers!!
On Sat, May 10, 2014 at 11:05 PM, Bill Q wrote:
> Perfect ! Thanks very much Vabz.
>
>
> On Saturday, 10 May 2014 13:25:29 UTC-4, Vabz wrote:
>
>> Hi
>>
>> See attached file.. Hope this is what exactly i want, i guess i am
>> getting what you mean by autofill..
>>
>> Cheers!!
>>
>>
>>
Perfect ! Thanks very much Vabz.
On Saturday, 10 May 2014 13:25:29 UTC-4, Vabz wrote:
>
> Hi
>
> See attached file.. Hope this is what exactly i want, i guess i am getting
> what you mean by autofill..
>
> Cheers!!
>
>
> On Sat, May 10, 2014 at 8:44 PM, Bill Q >wrote:
>
>> Hi Guys,
>>
>> Thank
Hi
See attached file.. Hope this is what exactly i want, i guess i am getting
what you mean by autofill..
Cheers!!
On Sat, May 10, 2014 at 8:44 PM, Bill Q wrote:
> Hi Guys,
>
> Thanks for your replies. I should have attached a sample spreadsheet for
> illustration & clarification purposes. Pl
Hi Guys,
Thanks for your replies. I should have attached a sample spreadsheet for
illustration & clarification purposes. Please see attached.
Very simply - whatever is in "A1" is to go into "B1" identically - the
autofilled all the way down until it no longers encounters any data in "A".
Tha