copy data from many workbooks to one worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I have invoices eg 2007.36 John.xls, 2007.37 Steve.xls etc.. with the
same template format. I want to copy data from these into one spreadsheet
under different headings (Client name, address etc). I currently do it by:
Client name (Cell A36) ='2007.36 John'E27, Client address(Cell b36) ='2007.36
John'F23 where E27 is cell for client nameand F23 is cell for client address
on invoice 2007.36 etc. but have to do this manually for each cell in each
individual workbook. I want to copy down the client name column, increasing
the workbook filename by one each time and keeping the cell displayed the
same- so Cell A37 will be ='2007.37 Steve'E27 . I think maybe wildcard
characters but have no idea what to do (without going into access and
spending 6months training)
 
Matty,

This is an Access newsgroup for Access related questions. I think you're
better of posting your question in the Excelgroup.
 
You must log in or register to reply here.

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Database design many to many relationships 4
Moving data from one workbook to another workbook 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Copy cell value from one worksheet to matching worksheet in another workbook 4
Copying from one workbook to another 4
Excel Help to copy information from one row at a time to another sheet 1
summarizing data from various workbooks 3

Back
Top