Hi,
this is probably too advanced for me so i need as much help as i can get. i have a table that records transactions. each transaction has a unique ID string (letters & numbers). the table also shows specific terms of the transaction, say "rate" and "time". i need a macro or something else suitable (it will be assigned to a form control button) that looks for a specific transaction in the table (based on ID no.) then amends the "rate" and "time" in the terms (which will be in the same row). I have no idea where to start as i am only familiar with very basic VBA.
Help is greatly appreciated
this is probably too advanced for me so i need as much help as i can get. i have a table that records transactions. each transaction has a unique ID string (letters & numbers). the table also shows specific terms of the transaction, say "rate" and "time". i need a macro or something else suitable (it will be assigned to a form control button) that looks for a specific transaction in the table (based on ID no.) then amends the "rate" and "time" in the terms (which will be in the same row). I have no idea where to start as i am only familiar with very basic VBA.
Help is greatly appreciated