Computer Help/Advice

[richy22]

Ok this is quite complicated but just want some advice/tips really!

We use an Excel template at work to record readings of loadcells and it tells us whether is passed or failed (numerous variables). My Manager wants us to record certain parts of this book, actually it's a template and we save it under part numbers, on a seperate Excel worksheet and it's a pig to copy stuff over from one book to another.

I want to have it so that the bits were interested in are automatically recorded in this seperate sheet thus saving time and hassle. All i wanna know is if this is possible to do? Maybe using MACROS?? I have bugger all knowledge of this but wanna learn and it'l look good to my manager!

Oh and this is my lil project over Xmas! Dedication!?!.... No madness!!!

 

[FiDoDiDo]

More or less anything is possible for automation using macros in Excel.

I reckon you could do it fairly easy if I understand it right.

 

[biojo]

everything is possible , well more or less,

if u have a main front sheet n want to create a new sheet of that info every tiem u put data in , it would be somet like macro , create new sheet called xxx then copy all data to that , n clear front sheet

 

[interceptor]

Would you be using Microsoft access aswell?

 

[richy22]

thought about microsoft access, basically all the information has to be in part no order/serial number order. Im assume id just set up the macros to copy them over to the product sheet that i wanna use?? We also use various templates so id also have to set up every1 of the templates to do this as well??!

 

[FiDoDiDo]

Yeah you would as the macros would have to be generic otherwise.