Excel Macro form help

%3CLINGO-SUB%20id%3D%22lingo-sub-356583%22%20slang%3D%22en-US%22%3EExcel%20Macro%20form%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-356583%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3EI%20have%20created%20a%20form%20in%20which%20I%20want%20to%20put%20a%20macro%20wherein%20whenever%20I%20click%20on%20the%20submit%20button%2C%20the%20areas%20filled%20up%20in%20the%20form%20are%20copied%20and%20pasted%20in%20transpose%20on%20a%20new%20sheet.%20However%2C%20it%20keeps%20getting%20submitted%20in%20the%20same%20row.%20I%20want%20it%20submitted%20in%20a%20new%20row%20each%20time.%20Please%20help.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-356583%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor
Hi,
I have created a form in which I want to put a macro wherein whenever I click on the submit button, the areas filled up in the form are copied and pasted in transpose on a new sheet. However, it keeps getting submitted in the same row. I want it submitted in a new row each time. Please help.
0 Replies