copying values into cells with formulas

  • Thread starter Thread starter k8
  • Start date Start date
K

k8

Apologies if this has already been asked in a previous
thread.
Does anyone know how I can copy & paste values into cells
that contain formulas, without the values overwriting the
formulas in the cells? I've tried locking & protecting
cells but then I cant put any data in.
Thanks in advance for any help.
K8
 
Hi

In a cell you can either have a value, or a formula - but not both. What are
you trying to achieve?
 
I have formulas set up in workbook 'a' and want to copy the values only from
workbook 'b' into these cells set up in workbook 'a', which will then in
turn calculate formulas on another worksheet, hence the need to keep the
formulas. I dont want to combine the 2 workbooks as this would complicate
matters for other users.
Not sure if this makes sense! :-s
Thanks,
K8
 
Suppose so yes, but they change all the time...this is probably more
complicated than I thought!
 
HAve you thought about having the formulas in Spreadsheet A refer to the value
in Spreadsheet B then you can actually lock the formulas so no one can change
them or even hide that worksheet and let the users only access the data on B
that needs to be changed?



: Suppose so yes, but they change all the time...this is probably more
: complicated than I thought!
:
:
: : > So, do you want to include these values as part of the formulae?
: >
: > --
: > Andy.
: >
: >
: > : > > I have formulas set up in workbook 'a' and want to copy the values only
: > from
: > > workbook 'b' into these cells set up in workbook 'a', which will then in
: > > turn calculate formulas on another worksheet, hence the need to keep the
: > > formulas. I dont want to combine the 2 workbooks as this would
: complicate
: > > matters for other users.
: > > Not sure if this makes sense! :-s
: > > Thanks,
: > > K8
: > >
: > > : > > > Hi
: > > >
: > > > In a cell you can either have a value, or a formula - but not both.
: What
: > > are
: > > > you trying to achieve?
: > > >
: > > > --
: > > > Andy.
: > > >
: > > >
: > > > : > > > > Apologies if this has already been asked in a previous
: > > > > thread.
: > > > > Does anyone know how I can copy & paste values into cells
: > > > > that contain formulas, without the values overwriting the
: > > > > formulas in the cells? I've tried locking & protecting
: > > > > cells but then I cant put any data in.
: > > > > Thanks in advance for any help.
: > > > > K8
: > > >
: > > >
: > >
: > >
: >
: >
:
:
 
Back
Top