Good Evening,
I have been struggling with this macro code for a few days now and was hoping I can find the answers here.
I am a zookeeper (birds) and we are changing our Incubator room process to all digital (there is a spreadsheet we use for basic data "egg measurements, parameters for the machine like temperature & humidity, and pre-entered formulas to calculate weight loss...it all differs based on species) we then hand write on the sheet after it has been printed and it then goes into a binder....
Will try not to get too off track, but: I have a "DATA" sheet where most of my info will be entered and certain information will transfer to an individual sheet (each egg will have its own individual sheet)....
My question is: on the main worksheet "DATA" (where all my info is typed in) I need cell "B5" (which I will type in the egg log # it is assigned (i.e. B11-26-8) and I need it to transfer to the tab name of the individual egg sheet.
I found a code that allowed me to type (the egg log #) in cell "D7" of the actual individual egg worksheet and it would change the tab name at the bottom. (I also unfortunately lost that code and can't seem to find it through google. Which was somewhat helpful, but not exactly what I was looking for.
Any help would be much appreciated. Let me know if anyone has any questions in case I made this not very understandable, lol.
Thanks again
I have been struggling with this macro code for a few days now and was hoping I can find the answers here.
I am a zookeeper (birds) and we are changing our Incubator room process to all digital (there is a spreadsheet we use for basic data "egg measurements, parameters for the machine like temperature & humidity, and pre-entered formulas to calculate weight loss...it all differs based on species) we then hand write on the sheet after it has been printed and it then goes into a binder....
Will try not to get too off track, but: I have a "DATA" sheet where most of my info will be entered and certain information will transfer to an individual sheet (each egg will have its own individual sheet)....
My question is: on the main worksheet "DATA" (where all my info is typed in) I need cell "B5" (which I will type in the egg log # it is assigned (i.e. B11-26-8) and I need it to transfer to the tab name of the individual egg sheet.
I found a code that allowed me to type (the egg log #) in cell "D7" of the actual individual egg worksheet and it would change the tab name at the bottom. (I also unfortunately lost that code and can't seem to find it through google. Which was somewhat helpful, but not exactly what I was looking for.
Any help would be much appreciated. Let me know if anyone has any questions in case I made this not very understandable, lol.
Thanks again