New to VBA.. simple charting

[LBTaurus]

Hey guys.. I'm a new engineer.. about to graduate college with a BS in Mechanical from USC. I work in Long Beach and i'm generally being introduced to a large number of engineering tasks.

At work, we have a program that takes pressure data and exports to excel. we have a large number of tests, and we add each test to a master chart that plots 300 seconds vs psi. the master chart has all the data from every test so that the tests that stand out from the rest can be flagged as defective.

I need to write up a VBA that takes the data from each test and automatically adds it to the master file.

I've never touched VB before. Is something like this possible?

 

[IRstuff]

a. there IS a spreadsheet forum here
b. sure, you can start by using the Macro Recorder function to record doing that by hand, then modify the code according to your needs and desires.

TTFN

FAQ731-376