ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   nyway to copy static valuesAND formulas from one workbook to anothe? (https://www.excelbanter.com/excel-worksheet-functions/136036-nyway-copy-static-valuesand-formulas-one-workbook-anothe.html)

S Davis

nyway to copy static valuesAND formulas from one workbook to anothe?
 
Hey,

I've got two workbooks here - one is garbage, the other is being
rebuilt based off of formula's from the old one in certan areas.

The values between the two are different - I need all of the straight
values (typed values), but I also needthe formulas. Ive noticed when
copying from one workbook to the next I can only copy values.

Is there anyway to bring in just the cell's contents, no matter
whether it be a formula or text or number, from one workbook into
another?

Thank you
-Sean



All times are GMT +1. The time now is 04:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com