SINGLE ITEM REPORTING FROM MULTIPLE SHEETS

Closed
pomporompompomp Posts 2 Registration date Sunday October 17, 2010 Status Member Last seen October 18, 2010 - Oct 18, 2010 at 02:04 AM
 RayH - Oct 21, 2010 at 03:58 PM
Hello,

Good day!
I am a newbie in the world of visual basic programming in excel. My problem is my boss wants an automated summary report (volume, capacity, saturation, etc.) of an item which undergoes different processes with different machines.
To illustrate the scenario, the program should be like this: when an item is selected from the SEARCH button, the output will be data from worksheets in the same excel file/workbook. Please help me. If you have any idea just share it with me.
Thanks!

PS. The worksheets look just like this:
worksheet1:PROCESS 1

Item Machine Model Volume/Day Capacity Allocation
A QWERTY 407 1338
B ASDFG



worksheet2: PROCESS 2

Item Machine Model Volume/Day Capacity Allocation
A YTREWQ 15,117 94
B GFDSA

1 reply

To clarify: You search for an item and you want Excel to return the data from row the item is on? If so, where would this data be returned to, a new worksheet? Could there be more than 1 item found during the search? How are you doing the search? Ctrl-F? How many Process worksheets are there?
0