I need to do something very simple. I find this on Google, I have many things but it did not worked as I want. Clearly I have an Excel file (we'll call file.xls) and within 4 sheets (sheet 1, 2, 3 and 4). Form 1 contains a button that will execute the two macros:
Macro 1: Copy the contents of the E47 cell (cell with formula) of the sheet4 in cell B11 on the same sheet4 (but only the value ... not the formula)
Macro 2: copy the contents of cell C57 of Sheet2 in cell C7 of the same Sheet2...
I know it seems simple to some but I could not find it.
Bookmarks