Each row targets a new worksheet

It would help if you could post an example of the spreadsheet with clear explanation on what you have already and expect the macro to do
Jmac1947

sorta figured it would be confusing

I want to have one sheet that as I create a new sheet data froim that sheet gets entered into the main record sheet. and each sheet tht I create will have the sheet name set to a certain cell on that sheet

sheet to come....

tarantulas test1.xlsx

here is an example of what im looking for

Attachment 288598

here is an example of what im looking for

I think that's what I want...XD

tarantulas test1.xlsm

Sparkplug90

Take a look at the attached spreadsheet and see if that is what you are looking for.

The plan is... you go to the template tab and enter the details for the new "thing", click the "start" icon and it should do what you are looking for.

Jmac1947

OMG that is amazing.

only one issue is that the "start button" stays on the newly created shet any way to make it leave if not that's ok I can deal with that....just wondering

oh and also is there a way I can add an "auto quary" type function to it so that the summary sheet requarys regularly to keep it up to data?

what I ment in the last post was is ther a way to make sure the previus "records/rows" on the summary shet kept up to date if I add or change the info on their respective record sheet

OK, understand, question, are you the owner and sole updater of the spreadsheet or are there other users to consider?

The answer impact how I might resolve your latest requirement

jmac1947

im the sole user of it..its to keep track of all my tarantulas..currently 70+

OK, here is a plan,

When you update a single page (or even multiple pages) you go back to the Summary page and execute a different macro that goes through each page and updates the summary p[age, that way you can do multiple adds / changes to individual pages and select when to update the summary page??

Sound plausible??

jmac1947

ya that sounds awesome man

hows it coming?

it is about 21:30 and I have had dinner and a couple of drinks, will get back to the problem in the morning.

I might be a good plan for you to post a full spreadsheet (or email me directly, address is in the macro you currently have) to ensure you start off with a working version

John

gotcha thx man I hear ya its 420 in the morning ill hit ya up in the morning ur time then and I appreciate the help

morning man hows everyoine

Howdy,
I have it nearly working although I have run into two problems. The first is that I cannot (on my current work computer) seem to get images attached to macros, will need to resolve that when i get home tonight I suspect.
The second problem is to do with the tab names on the sample spreadsheet you sent. In the end I had to resort to actually retyping the tab names to get the macro to work so you may have a maintenance issue to start with so again, it would be easier if you can send me the complete current spreadsheet you have and I will ensure that it works correctly before I close the case
Jmac

ok will do ill get that to you in a bit
getting ready to head to wrok atm thats where i was working on it lsat night

tarantulas test.xlsx

this is as far as i have for information transcribbed down...

Thanks for the updated spreadsheet
I note that you havent assigned any "identifier" values to the summary tab.
Do you have any specific format of identifier in mind or should I wait until you finish the summary data tab

ya the identifiers ware going to all be setup like this

"Ps-Ir-01"

all will have the same setup
2 char - 2 char - 2 numbers

OK, I suggest that you dont bother to add the individual sheets for each entry at this point. If you finish the summary sheet, including identifiers, and send it to me I will use that info to create a base version with the macro included and then you are on your own

ok ill get that to you here soon

tarantulas test.xlsx
here you go..and again thank you for all the help thus far man

hey dude, this isnt my field (not into tarantulas much I have to say) but your latest spreadsheet seems to have reversed the Species and Genus columns.

I have no idea which version is correct but it doe3s look like you may have simply got the headings wrong based on your previous data

don't want to load them all up wrong if I can avoid it

Please confirm that the data in row 2 of your spreadsheet matches the headings in row 1
Jmac

wow great catch man..i had reversed them XD

so to be 1000% sure, Acanthoscurria is a Genus, geniculata is a species, that is you have the heading ling wrong??

yes acathoscurria is the genus

Sparkplug90,
Here is the final version with the data loaded. Note that in your last spreadsheet (around rows 40-45 from memory) there were a couple of duplicate identifiers and a couple of sequence numbers missed so I took an educated guess as to what the right data should be (you cannot have duplicate tabs).

enjoy

Jmac1947
Tarantulas (Final Version).xlsm

if this has resolved your problem please mark the thread as solved using the thread tools and if you are happy with my assistance then please consider clicking on the *Add Reputation icon

thx jmac i appreciate your extreamly knowledgable help

this is amazing man i appreciate the time you put into all of this

have a question i cna do some vba and some formulas on my own would u advise vba or a v lookup function to get the date last fed for each of the recods?

where is the date last fed kept? I am assuming it is somewhere in each of the individual sheets. Is it in a constant cell in each sheet?

If I assume that it is in each sheet and always in the same cell (that is you overwrite it each time you feed rather than keep a history of each feed) then I would simply add a column to the Summary tab and add a bit of code into the "update all records" macro to update that field from the individual tab to the summary tab, should be about 2-4 lines of code max.

Even if my assumptions are not quite right, I would still opt to do VBA code in the existing "update all records" macro

see it would be a history imma modify the sheets to contain a dropdown list so that i cna chose from a catagory of certain things that are done, molt, feed, breed,...i cna do that
then on the summary sheet it would have the most recent displayed. but each ones own sheet would have thier entire history.

lets take this offline, my email address is in the macro code