Auto fill and refresh macro

**incubi** · 01-03-2013, 05:15 PM

Hello,

This is my first post, but have been lurking on the forums for a few months. Anyways, I've been trying to create a macro for a auto fill and refresh macro, but failed at accomplishing what I needed. As you can see on the attached excel file. Data sheet tab is pulling data from GDL tab. I would like to auto refresh the data sheet by pressing a button and have the information I need pulled from GDL. As you can see on the macro I attached to button 5, I am getting a debug error. It would be greatly appreciated if anyone can help me out.

Thank you in advance.

SLog 2012 ptable1.xls

**Kiran.Sunkara** · 01-04-2013, 07:40 AM

Hi incubi,
Welcome to the Excelforum!

Please try the below code for your button click event

    Range("A7:Q8000").Select
    Selection.FillDown
    Range("A6").Select

Before running the automation please ensure the below changes are done
1. In cell A7 put =$A$5
2. In cell P7 put =IF(K7=0,"",O7/K7)
3. In cell Q7 put =IF(L7=0,"",O7/L7)
This is to ensure that all the formulas in Row 7 are accurate.

**incubi** · 01-04-2013, 03:53 PM

Kiran,

Thank you so much for the help! It works!! It was driving me crazy trying to figure this out.

**Kiran.Sunkara** · 01-05-2013, 12:50 AM

Glad to know it had worked. Happy to support any thime!

Thank those that provided useful help, its nice and its very well appreciated...use the star on the lower left of the post