u/BrokenVFD

Trying to take data from one excel sheet to another.

So I am building my first Power Automation. I have 2 excel sheets (and at this point they are copies) the first one has a list of part numbers. The second also a list of part numbers.

I have prices in one (to be entered in the second) and when i hit "run" it does not recognize a match on the part numbers.

I have been using Copilot with little success. It implies that its a text issue or a value issue or the cell is general / text/ format, and the other isn't. Ive been going around for 10 hours between yesterday and today.

Any tips?

reddit.com
u/BrokenVFD — 14 days ago