Excel scripts

[Fuggin]

Can anyone recommend a web site that will explain how make scripts?

Essentially I just want to take data from 1 column within a date range (rows) and make a chart of it. I need to automate it for work.


- shitposting from Blablablabatalk.

[balistic void]

Alt+F11 opens up the VBA editor. Press F1 with stuff highlighted and it will open up the help. Look for the chart function, it's pretty simple.

Then just google what you are trying to do, VBA is the magic keyword for the scripting language excel uses.

http://excelexperts.com/create-cell-...xcel-using-vba

[Hel OWeen]

A good way to learn how Office automation works was always starting the macro recorder, do some stuff, stop recording and edit the macro to see what action caused what commands. Alter the macro, replay it and see how your change works/what your changes did.

To don't get confused with too much code, start with very short macros/a single actions, i.e. entering a value in a cell.

See also StackOverflow: http://stackoverflow.com/questions/tagged/excel-vba

[Kanv]

Have you tried Pivot Tables?

They're half of what i do in Excel now at work

[Damien Smith]

Have you tried Pivot Tables?

They're half of what i do in Excel now at work

C. Pivot tables are pro.