Pull data from sheet 1 to sheet 2
Closed
zachou874
Posts
1
Registration date
Wednesday March 14, 2018
Status
Member
Last seen
March 14, 2018
-
Mar 14, 2018 at 03:38 AM
Blocked Profile - Mar 14, 2018 at 03:44 PM
Blocked Profile - 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.
Related:
- Pull data from sheet 1 to sheet 2
- Tentacle locker 2 - Download - Adult games
- Tentacle locker 1 - Download - Adult games
- Sheet right to left in google sheet - Guide
- Windows network commands cheat sheet - Guide
- Fnaf 1 download pc - Download - Horror
1 response
take a look at this article, and let us knw if you get stuck:
https://ccm.net/faq/54862-how-to-copy-data-from-one-excel-sheet-to-another-using-a-formula
Have FUN!
https://ccm.net/faq/54862-how-to-copy-data-from-one-excel-sheet-to-another-using-a-formula
Have FUN!