Is there a way to have data imported by reference then change it to the value? (Excel2007)

  • Thread starter Thread starter rick
  • Start date Start date
R

rick

I have a large, multi-worksheet financial workbook and would like to import
data from a worksheet then break the references and keep the data values.

Someone sends in a workbook that was downloaded from the Internet (we
developed) then complete it and send it back by email. This contains
tombstone data as well as proposed budget details. Within the Main Workbook
is a much more extensive budget and I would like to populate it with
references like ='ProposedBudget'!$B$8 but then click a button or checkbox
that says 'Import Completed' and keep the values so that 'ProposedBudget' is
no longer needed.

Hope this is clear.

Thanks.

Rick
 
I have a large, multi-worksheet financial workbook and would like to import
data from a worksheet then break the references and keep the data values.

Someone sends in a workbook that was downloaded from the Internet (we
developed) then complete it and send it back by email. This contains
tombstone data as well as proposed budget details. Within the Main Workbook
is a much more extensive budget and I would like to populate it with
references like ='ProposedBudget'!$B$8 but then click a button or checkbox
that says 'Import Completed' and keep the values so that 'ProposedBudget' is
no longer needed.

Hope this is clear.

Thanks.

Rick
Click to expand...

If you no longer require any reference to the original sheet, what you could do
is select the cell.

Then:

Edit/Copy
Edit/Paste Special/Values

Once you do this, the reference will be gone forever.

Some methods as to how this could be done:
manually
via an ordinary macro that you call
via an event-triggered macro that, for example, checks some adjacent
cell for a mark, letter, etc and, if it sees it, performs the above operation.
--ron
 
Try the free ASAP Utilities function to "replace formulas with their
calculated values".

I do not do importing from another workbook so I cannot test.

Eric
 
Back
Top