Previous Topic Next Topic

New workbook

Closed
ItalianBaby - Feb 20, 2012 at 08:12 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 23, 2012 at 10:10 AM
Hello,

I would like to know if it is possible (and if it is, how) to do the following:

Data is entered into a excel workbook like a database. After which I can click on say a 'Generate Report' button to pull up a new form that has not been used with the data from the database already input. After the data is generated, I would like the cells to unlink (meaning that even if I delete the details in the 'database' the data will not be affected.

Thank you

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Feb 23, 2012 at 10:10 AM
Hi ItalianBaby,

It is possible to rearrange data with a click on a button.

Question remains how your data looks like and how you foresee the result.

Consider the possibility to upload your entire workbook (watch out with personal data) using a filesharing site like www.speedyshare.com.

Best regards,
Trowa
0

Similar discussions

Lookup across whole workbook (muliple sheets)
mad -
Mark -

6 responses
Excel - A macro to create new workbook and copy data
Shridharb2002 -
TrowaD -

29 responses
Macro-Copy data from one workbook to another
Krishna -
Dvibe -

12 responses
copy a row from one worksheet to another, based on criteria
wy -
vcoolio -

15 responses
Copy Worksheet to another Workbook (unopened)
Josh -
Josh -

6 responses