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