Transfer Date Loop

  • Thread starter Thread starter Mishelley
  • Start date Start date
M

Mishelley

In my first worksheet, I have columns of data that I need transferred into
the second worksheet as rows (records) of data. I need to do this beginning
with Column B until there is a blank column. I am using a macro. How can I
automate this event so that only columns with data are transferred to the
second sheet?

Thank you,
Mishelley
 
Thank you for your help, Charlie. When I copy/paste your code and try to run
it, I am getting a syntax error on the following lines:

Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=True

Can you help?

Thanks,
Mishelley
 
Hi Charlie,

When I run this code, I get a Run-Time error '9':
Subscript out of range

When I go into the code, this line is highlighted in yellow:

Sheets("ColData").Select

Sorry to be a bother.
 

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

VBA to automatically cut, paste entire row based on date input and delete row 0
Transfer data between two worksheets 10
Rows to Columns - Diff Size Rows of Data 4
Transpose 6
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
InputBox for column letter problem 2
Couple subs need help with 2
How to copy row data from Sheet2 to Sheet1 based on Conditional Date 2

Back
Top