Bells
06-21-2017, 02:03 PM
I have 6 worksheets (cc2017; ab2017; bh2017; etc), each that have 12 tabs at the bottom (6.25; 7.1; 7.14; KPIs; etc), and a 'master' worksheet where I want to have it grab a specific cell, from a specific tab, from a specific worksheet, and copy that data to the master?
I found this bit of code, but it gives me an error message of: formula parse error
=DG2017!KPIs!B26
I know that I have it wrong, but I am not sure what is wrong with it?
I would be happy to be able to have the code to grab a single cell, bc I can do everything else after building a datasheet that has all of the data I want from each sheet.
I have spent 2 hours reading through things and can't find the string of code I need, so I figured it is time to simply ask for help:)
I found this bit of code, but it gives me an error message of: formula parse error
=DG2017!KPIs!B26
I know that I have it wrong, but I am not sure what is wrong with it?
I would be happy to be able to have the code to grab a single cell, bc I can do everything else after building a datasheet that has all of the data I want from each sheet.
I have spent 2 hours reading through things and can't find the string of code I need, so I figured it is time to simply ask for help:)