This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi all, would someone be able to help me with an excel someone has developed for me I am getting a #name error
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi Andreas,
is this the information you need for version of Excel I have?
Yes.
I have downloaded 2 files.
What are raw data sheets?
Which is your expected result?
Consolidate all sheets named like 601 or 611?
Did you tried power query?
Data sheets are room numbers 601-624
Expected results is that the information on each of the tabs is copied to one for all the rooms
so say 601 is missing one beaker and 611 2 conical flasks.
the master sheet would say
I am missing the 1 beaker in 601 and the 2 conical flask in 611
I haven't tried any formulas.
I am not very good at using these.
So that is why I thought I would ask