Hello,
My name is Zach and im new to the forum, don't use excel very much but I find myself needing it to create something for my workplace. I will try my best to explain what im trying to do and see if its possible.
I have a report at work that I have the option of exporting to excel and im trying to make another sheet in the same workbook get values from this report.
Inv # Description Measure Monday Tuesday Wednesday Thursday Friday Saturday Sunday Total Multiplier Label Total
40001 HAMBURGER 4:1 PATTY PATT 65 94 88 118 85 83 56 589 80 CASE 7.36
40003 BACON STRIPS BAG 0.8 1.3 1.06 1.76 1.36 1.26 0.68 8.22 3 CASE 2.74
That is how the lines show up, my problem is that based on whether I have new inventory items etc, the order of the items in the list can change drastically, and the only value im trying to retrieve for each item is the last value, Total. What I was previously doing was just going to the cell were I need the value, hitting "=" then clicking on the previous sheet and the cell that had the total imformation. If something on the list changes though then that will be pulling up the wrong value... Is there a way to tell a cell to go to the previous sheet, search for say the Inv #, then somehow return the last value on that row? Which would be the value under the "total" column...
Hopefully I explained this decently lol, anything anyone could help me with would be much appreciated!
-Zach
Bookmarks