What Excel macro puts data in the NEXT row of a sheet?

K

KenC

I have a list of data in col B of sheet 2 which I need to copy and transpose
into sheet 1, then delete the data in sheet 2 to use the form again to copy
and transpose onto the next line in sheet 1. I have tried with a macro
shortcut I've called ctrl + e. (I am really using the data form process but
cannot because I have too many inputs).
Is there a simple macro I can copy and paste?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Eliminate blanks while copy row and transpose 11
Consistent Sheet column header rows 2
Having difficulty copying and pasting on VBA 3
Creating sheets with pasted colour-marked rows through a nifty macro command, please 1
Macro to Compile Data from Different Sheets 2
Array with many cells from a row but not in order or together 11
Help merging two VBA codes 2
Copying Solver results of each iteration to a given location in a workbook 1

Top