Hello All
My first post here so here goes...I'm really new to VBA and need some help to write a macro to do a simple calculation (I tried to attach a screen-grab of the file but moderators won't let me do this until my post count hits 5, nor will they allow me to include links... ). Can I get round them? [Apologies to mods in advance!] Here goes...replace UPPER-CASE letters with approriate symbols:
httpCOLONSLASHSLASHi122.photobucket.comSLASHalbumsSLASHo250SLASHmaz1889SLAS Hscreen-grab-excel.jpg
In the excel file, I want to create a macro that will perform a simple multiplication whenever 'Name=Barry' and 'Category=High', such that the value in the 'Hours' column is multiplied by (85/65). This value will be populated in the adjacent column 'Adjusted Hours' (which can be empty prior to the macro running...actually it could be created BY the macro, if need be...it could even REPLACE the value in the 'Hours' column, so I'm flexible about that).
Can anyone help me do this? The only exprience I've had with macros is with the 'record macro' facility in excel but have never done anything that involves things like conditional 'IF-statements'.
Thanks for your help. It's much appreciated.
Lester