Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel autofill macro
Can someone please help me figure out a macro that I can use to autofil
a formula into all the cells below it until the data on the lef quits? This is the situation: I have several worksheets that I have to insert the followin formula(="t"&right(b2,12)) to cell d2. The problem I need help with i that sometimes I have to copy this down to row 42 and sometimes I hav to copy this to row 5300. It varies with each workbook. Can someon please help me? This small macro would save me hours of time eac week. Thanks in advance for your help! -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP!!! I need macro to autofill | Excel Discussion (Misc queries) | |||
Autofill in macro | Excel Discussion (Misc queries) | |||
Autofill macro | Excel Discussion (Misc queries) | |||
autofill macro | Excel Discussion (Misc queries) | |||
macro to autofill formula? | Excel Programming |