open another book and copy

  • Thread starter Thread starter guru
  • Start date Start date
G

guru

i have several workbooks with one worksheet that contain values from cells
a1 to m50
I want to gather all the values from all the sheets the one above the other
at one new sheet.
The new sheet must be like this

a1

m50
a50

m100
etc
Is this possible
p.s. all the workbooks are at the same directory
 

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

Create list of worksheets and cell values 2
Arrays and scattered cell values or another way? 16
Copying non-blank cells in a range - XL97 1
I need to use the sumif for a workbook, not a worksheet 3
Formatting and copy or copy and formatting ?? 2
pasting values only 1
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
Get multiple cells from all worksheets Code Not Work 1

Back
Top