[Dan Diesing]

Thanks for the replies. I will be looking into PQ now!

[Dan Diesing]

Thanks, I forgot to mention that I had already sync’d the names between the 2 tables (just wasnt at my work computer for new screenshot).

I will look into pivoting the Columns. Lots to learn, trying to fit it into a busy schedule and still get the work done.

I appreciate the guidance.

[Dan Diesing]

Thanks for checking in Doug. I’m sorry for not getting back to you sooner. It’s been a deep rabbit hole, I also took on another project while trying to learn this. I have had to brush up on my VBA scripting for the other project.

I have got my data almost where I need it to be with power query. It is usable but I’m stuck on the transformation (haven’t had any time to dig into it so it might be simple). Top Table is how I currently have my data. My spreadsheet (how the bosses want it) is the bottom table.

My makeshift workaround is to just pull the data in with this formula:

=IFERROR(INDEX($E$22:$E$40, MATCH(E$6 & $B8, $C$22:$C$40 & $D$22:$D$40, 0)), “0”)

It works but if i get bigger sets of data with more buildings or floors I don’t want to have to tediously double check everyone is working right

[Dan Diesing]

Thanks David,

Currently, everything is done in Excel. I have a decent template made up that once I had the data input into it with quantity link, it would populate all other pages with relevant data. All I would really need to do is update pricing for labor and materials.

[Dan Diesing]

After browsing a few things today. This is exactly what I was looking for (even though not quantity link, didn’t need to be) but now it seems like I have a lot of learning to do! Should make everything more streamlined.

After I get this figured out, I’ll look at ways to optimize my Revu counting/measuring. Hopefully find some more tips and tricks.