Create a new Excel file with selected cells

J

john

Hi All,

I need your help once again. I have a Dashboard with five sheets and I
was wondering if there is a function to create a new Excel file based
on the data selected from the Dashboard.


I would like to select data or cells from different sheets from the
Dashboard then create a new Excel file with the data selected using a
macro or vb.


I guess I could just copy and paste the data from one file to another
but there are a large number of cells I need to select. I would like to

know if I could automate this process.


Thanks in advance.

Jose
 

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 a new Excel file with selected cells 2
Excel Import External Data by Date Automatically 0
Naming a workbook using a macro 13
Hyperlinking to a Chart as a separate page in Excel 2007 1
Tie additional cells to cell automatically updated 1
Automate data gathering from separate worksheets 1
How to create a similar resume in MS Excel ??? 1
Excel Dynamic Chart Monthly and Quarterly Data 1

Top