Pull data from sheet 1 to sheet 2

zachou874 1 Posts Wednesday March 14, 2018Registration date March 14, 2018 Last seen - Mar 14, 2018 at 03:38 AM - Latest reply: ac3mark 9622 Posts Monday June 3, 2013Registration dateModeratorStatus June 22, 2018 Last seen
- Mar 14, 2018 at 03:44 PM
I would appreciate any help for my case. So in sheet 1 called WIP, consist of item descriptions (C1) and quantity to be build (D1). The item description would be item name such as STD B, SGC B etc. On sheet 2 called SCH, consist of several tables in which each tables represent machine 1, machine 2 and so on. Machine 1 only able to build specific type such as STD B. Various types of STD B are on sheet 1. So would like to make the data on sheet 1 auto-populate the tables on sheet 2 based on item desc followed by the quantity. Reminder that data on sheet 1 always changing everyday. I was only able to pull the data based on it cell number, however what I need is the cell text value since all data in sheet 1 is always changing everyday. I tried Vlookup, indirect and even adding button using vb but couldn’t get the outcome that I want. Please help for any menthod or possible formula for this matter. Thanks in advance.
See more 

Your reply

1 reply

ac3mark 9622 Posts Monday June 3, 2013Registration dateModeratorStatus June 22, 2018 Last seen - Mar 14, 2018 at 03:44 PM
0
Thank you
take a look at this article, and let us knw if you get stuck:
http://ccm.net/faq/54862-how-to-copy-data-from-one-excel-sheet-to-another-using-a-formula

Have FUN!
Respond to ac3mark