Hey,
Need a bit of a hand getting a process working automatically. I have a spreadsheet with multiple pages to it and in each page I have a set of recorded results. What I want to do it take each of the four recorded result columns scale them and put each one in a csv with its name relating to the column name. Then I need to apply that to each of the pages in my file. I have hundreds of thousands of readings and it will take a good few hours to do the backlog by hand and it will speed up my data collection dramatically, real time results baby

Its probably more then just a straight macro recording, it would probably have to done in VBA problem is I have no syntax in my head
Chars.

If you were doing it in c# i might be able to help you.

Dont worry I learnt enough vba to get the job done, thanks tho

have you thought about turning the .xlsx files into .csv, dumping into a DB and run straight up SQL queries? That is prolly the easiest thing I would do.

Debawv did you just speak English?

Was reminded of a scene in Good Morning Vietnam where Robin Williams
holds a conversation using just acronyms.

he spoke an obscure dialect of English, called databasemasochism I speak a bit of it myself, and imho he's right

would be a good idea to have a db of results on my server but mehhhh, files on desktop lazyness. Thing is I need to mooch the data about into different forms for differing software packages etc, my analysis software need this my modeling needs that. Fun