Dear Excel Gurus:
I have an Excel file with 2 tabs, DATA sheet and REPORT sheet. I need help to create a VBA code to come up with a report taken from the DATA sheet. Right now what I’m doing is go to the Data sheet and filter on the Item Number, then copy the filtered data to a new sheet and remove all the columns that I don’t need. What I want to accomplish is on the REPORT sheet, I will just type the ITEM number on cell A2, it will list down all the corresponding data.
DATA sheet details
Column E: Trans Date
Column F: Item Number
Column H: TR Type
Column I: TR Qty
Column J: Bin
Column K: Level
Column N: Comments
REPORT sheet details
Row A2 will be the look up. When I type an Item No. on this cell, it will list down all the item that matches and will display all rows as follows:
RESULT
Row A6: Trans Date
Row B6: TR Type
Row C6: TR Qty
Row D6: Bin
Row E6: Level
Row F6: Comments
Thank you in advance for your great help.
Bookmarks