So, I have an Inventory Report(Sheet 1) that I would like to cross reference to a Sales Report(Sheet 2) by matching SKU numbers which are both in the column (A:A) on their respective sheets.
If the SKU number exists in sheet 2, I would then want it to filter for rankings("Sheet 2"!AG:AG) that are greater than 0 but less than 100,000.
If the SKU number matches this criteria it will then populate that SKU number with its ranking into an Order Report(Sheet 3). With Ranking going into A3:A and SKU Number going into B3:B
This is the code I've gotten but it doesn't seem to be populating any results.
Thanks!
Bookmarks