select all non-blank cells from different workbook

J

johncaleb

hi again,

I need a macro to select and copy all non-blank cells from Sheet1 FROM one
workbook, then paste these cells into a different workbook, sheet2 at Cell A1.

thanks much!
 
K

Kristiina

Just to clarify,

is the data in sheet1 in orderly manner and what do you mean about sheet2?
How does the data need to be on the sheet2?

Rgrds,
Kristiina
 

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

select all non-blank cells 3
Dealing with the error: unable to filter on excel hc home school 0
Need Help with a VBA subroutine 0
Pasting a cell into bookmarked table from excel vba 1
copy and paste from workbook to workbook 3
How to count non blank cells with a condition? 1
Code to format cells on several worksheets 2
problems getting this macro to work 8

Top