SINGLE ITEM REPORTING FROM MULTIPLE SHEETS Closed

Question

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
Configuration: Windows XP / Internet Explorer 7.0

RayH · Answer

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?

SINGLE ITEM REPORTING FROM MULTIPLE SHEETS

1 response

Similar discussions

Subscribe To Our Newsletter!