Hi... someone be kind enough to provide me a code that does the following:-
when enter pressed in Range.Name = Sale then copy the row above which is = Row 2 and Row 3. then paste and transpose values to Column G3 and Column I3 respectively.
i'm not talking about entire Row 2 and Row 3 but the cell above when Enter is pressed or Value Changes on that particular column belonging to range name = Sale.
help will be appreciated.
when enter pressed in Range.Name = Sale then copy the row above which is = Row 2 and Row 3. then paste and transpose values to Column G3 and Column I3 respectively.
i'm not talking about entire Row 2 and Row 3 but the cell above when Enter is pressed or Value Changes on that particular column belonging to range name = Sale.
help will be appreciated.
Last edited: