automation process of data and plot

[shayv1468]

Hello,
I'm looking to make automation process I do several times a day . Since it's quite complex so first explanation - this is an online report I'm getting it to Excel . The report contains data on the number of production batch
each batch begin at step 2 and ends at step 28 ( column J) . the relevant steps for me are step 13-22
What i need :
1 . Delete empty cells
2 . Ordering data by batch of stages 13-22 only in the other sheet
Add another column of an absolute time that 0 represents the beginning of step 13 ( for the same batch ) and the end time is the end stage 22 . Simply Ahrotharc first would be 0, the next one will be 00:00:60 , and so on ( each row is one minute )
3 . Building a scatter graph Y axis is the values ​​of temperature (column A ) and the X axis is the absolute time for each batch with a third -order trend Foliniomali presenting formula and correlation .

sorry for my eng...
Thanks in advance ! ! !

[shayv1468]

someone? idea?

[TMS]

Cross posting without references breaches the forum rules and does not help your case. I appreciate that this may be because you haven't had any responses but, you are likely to irritate members of both forums.

http://www.mrexcel.com/forum/excel-q...lications.html


And I suspect the reason that you have had no replies is that you are really looking for a hand crafted solution, not help to overcome difficulties encountered developing your own solution.

You could start by recording one or more macros while you undertake the individual steps. Then generalise the code, combine the macros and tweak as required.

Step 1: switch on Autofilter. Filter on one of the columns for blank cells. Delete the visible rows and switch off the autofilter.

Step 2: sort the data into order

Step 3:add a formula to the worksheet to generate the sequence number. Record a macro to save that formula into a cell. Tweak to apply to whole range.

If you intend to continue with this on you own, you could ask separate, simple, questions to get help for each task.

If you don't want to do it yourself, you could try paying in the Commercial Services forum. Alternatively, you could employ an Excel/VBA consultant.

Regards, TMS