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.