Hello,
i have a table with headers in c31:h31, reference number being in column C. i am using a macro to add data to this table.
i am looking to add a 'Modify data' macro button to the sheet which picks up the reference number given in cell c25 (outside the table), then locates this reference number in column C of the table then replaces the full row with the contents of cells c25:h25.
Many thanks in advance,
SKF
i have a table with headers in c31:h31, reference number being in column C. i am using a macro to add data to this table.
i am looking to add a 'Modify data' macro button to the sheet which picks up the reference number given in cell c25 (outside the table), then locates this reference number in column C of the table then replaces the full row with the contents of cells c25:h25.
Many thanks in advance,
SKF