Hi,
I hav
Hi,
I hav
Last edited by rexcel548562; 08-07-2022 at 08:28 AM.
Hi, Can An
Last edited by rexcel548562; 08-07-2022 at 08:29 AM.
both worksheet event and macro code should be used.
In the begining Cell C1 should be blnk. Then Column A and B will be copied.
Worksheet event
Macro codePlease Login or Register to view this content.
WorksheeteventPlease Login or Register to view this content.
How to use the code
Right click on Sheet tab --> view code
Visual Basic (VB) window opens.
Paste the code
Close the VB window.
Save the file as .xlsm
Last edited by kvsrinivasamurthy; 07-22-2022 at 04:06 AM.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Hi Sir kvsrinivasamurthy,
Last edited by rexcel548562; 08-07-2022 at 08:29 AM.
Thanks for feedback and rep.
Hi Sir kvsrinivasamurthy,
Last edited by rexcel548562; 08-07-2022 at 08:29 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks