CODEWITHSUNDEEP
excelexcel-formulauniqueidentifier
Tori Chavez
Tori Chavez

Reputation: 9

Query to Copy Rows to Yearly Summary, need unique identifier for each row in the yearly summary but need to be specific to the individual rows

I am trying to get a formula to create a unique identifier in the yearly summary tab of my excel document. Right now if I add rows into the individual tabs then the rows copy over in order to the yearly summary and my unique identifier changes. How can I get my unique identifier to be specific to a certain row to where if there are adds later then they will add to the bottom and have a new unique identifier. Do I need to adjust my query or do I need to adjust my Formula?

All my weeks are added in per tab per week. All the information is added in here.

Week 3

Then I have a query to bring it all to the yearly summary tab. The formula I am using for my unique identifier is below:

''' ="24-"&IF([@[Sheet Name]]>"",COUNTA($N$2:N2),"") '''

Yearly Summary

So my question is, does the formula need to change or does the query need to change? I want any new additions to any week to transfer over to the yearly summary in order of addition, not in order of week.

Upvotes: 0

Views: 31

Answers (0)

Related Questions