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
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.
Thanks.
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 ronsmith...@gmail.com wrote:
Hi Guys,
Thanks for your replies. I should have attached a sample spreadsheet for
illustration
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 ronsm...@gmail.com
javascript:wrote:
Hi
Cheers!!
On Sat, May 10, 2014 at 11:05 PM, Bill Q ronsmith...@gmail.com 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!!