Extract Data based on Attributes from multiple sheets

[balle123]

Hello Guys
I just started a couple of weeks ago with VBA programming and thought it was time to join a forum. Unfortunately, I can't solve my problem by searching around the web and must acknowledge I probably don’t have the skills to solve the problem myself.

Information:
• 1 Sheet used at the primary analysis sheet
• 2 Sheets consisting of Processes i.e. Process 1 and Process 2
• The process sheet has 3 rows consisting of Cycle Time, Process Time and Lead Time

What I need is to be able to extract data based on the values of a list that determines A) what sheet to copy/paste (Process 1 or Process 2) B) Which attribute of data to copy/paste (Cycle Time, Process Time and Lead Time.

Example: List: Process: Process 1 Attribute: Cycle Time
Then it needs to copy data row with cycle time in sheet process 1. I’ve tried to code a simple macro but it doesn’t work.

Thanks in advance!

Regards Balle

[Punnam]

Hi ballee,
Need more clarity can you explain in more detail

Punnam

[shukla.ankur281190]

May be

A11

Please Login or Register  to view this content.

Drag down!!

[balle123]

Hi ballee,
Need more clarity can you explain in more detail

Punnam

Hey Punnam
Sorry for the late response. Writing a master thesis so are pretty busy. I actually managed to get it working I dont know if it is optimal though.
I made a button that relates to the process worksheets in the workbook. If the list has chosen "Process 1" and i click the button it goes and copy the raw data
from that process into my mainsheet where i want to analyze the data.
Aditionally, a button that relates to the attributes within each of the processes. This button is just based on the range of the certain attribute and thereby
copy to a new column. The new column is main column and my scatterplots, normal distribution plots is based on that column.

Hope it clarifies it a bit better

Thanks