I am on the "layout" tab. From that tab I have 3 drop-down combo boxes that allow me to drill-down to an account.
For example,
Drop-Down 1 = Statement (P&L, Bal. Sht, Cash Flow)
Drop-Down 2 = Category (Sales, Variable Costs, Inventory, etc)
Drop-Down 3 = Account (Gross Sales, Material, Finished Goods, etc)
Drop-downs 2 and 3 adjust as nescessary with the changes selected in drop-downs 1 & 2.
So, after making the selections in the drop-downs cell F7 on the "layout" tab is written to concatenate and vlookup the appropriate sheet and cell number to find the selected statement/category/account per the selected drop downs.
So, in this particular example, cell F7 shows sales'!B161 (Sales sheet and cell B161 on that sheet). I thought I could just record a macro using the cntrl+G function, copy the data in cell F7, paste into the "reference" section of the goto command and it would work. The problem is that the recorded macro takes me to the original sheet/cell spot regardless of the change in my selections from the drop-down. Based on this I am hoping there is a macro that can be used to go to the appropriate sheet&cell based on the choices from the drop-downs since my recorded cntrl+G macro doesn't seem to work. I have tried a couple of things but failed each time.
You probably already gathered this, but I am very new to macros and have trouble fully understanding what they are doing. However I have successfully searched this site, found a macro I was looking for, and applied it to my file. I just can't figure this one out.
Thanks!