dimanche 1 mars 2015

Excel Macro, Copy Cell to a location if a cell has a value

I am looking for some help with excel Macros eg. If a value is found in Desc that matches Bill/car/rent/tax the Cost value copied to the correct column.


Cost Desc Bill Car Rent Tax


155 Bill

165 Rent

195 tax


Cost Desc Bill Car Rent Tax


155 Bill- - -155

165 Rent ------------ 165

195 tax ---------------------- 195


Can this be done? Thanks in advance. I have attempted and can select the value but not sure how to paste it etc, not very good with vba macros.


Aucun commentaire:

Enregistrer un commentaire