Excel VBA help needed

[proficy]

Hi,

I am very new to VBA programming. I am doing a small project and need some help with it. my problem is:

1. data in excel cells has to be converted using a simple formula (ex: cell value/n) and written below the original data

2. rearranging data from highest to lowest according to column totals

can somebody help please?

thanks in advance,
proficy.

 

[grungemann]

Try playing around with recording a macro, view the code & execute it.

An example to q1 would be

Sub test3()
Range("C8&quot.Select
ActiveCell.FormulaR1C1 = "=R[-1]C/5"
End Sub

 

[Loomah]

proficy
this will sort data according to totals in row 11

Sub Sort()
Selection.Sort Key1:=Range("A11"), Order1:=xlDescending, Header:=xlGuess, _
    OrderCustom:=1, MatchCase:=False, Orientation:=xlLeftToRight
End Sub

If you are just starting out with VBA a good way to get some grounding is to record yourself performing some tasks in xl word or whatever. This is how I actually got this code!

To complete what you're trying to achive I think you will need something a little more dymanic than either myself of grungemann have posted here. If this is the case just post back!

;-)

Go TOOLS>MACRO>RECORD NEW MACRO. do some stuff the click the stop button - looks like stop on a VCR or anything like that.

To see what you've done Go TOOLS>MACRO>MACROS.
Select the macro you've just recorded and click edit If a man says something and there are no women there to hear him, is he still wrong?

 

[proficy]

thanks for your help.
I will try the code and will get back to you.