Carrying formulas over to new cell when old cell is deleted: possi

K

Karl

Hi,

I've created a Gantt chart in Excel. The date header for the first column
references the start date of the first task, so in the cell H4 is simply
"=D4".

The column headers show days of the week as well as dates (convenient as I
use workday function to arrive at each task's end date).

If someone has a task that starts, say, on a Wednesday, I want them to be
able to columns H and I. However, at the moment this breaks the reference to
cell D4 - and all the other date headers are arrived at by referencing this
cell ("=D4+1â€, "=D5+1" etc.).

Is there anyway I can have the formula "=D4" to be carried over to the new
H4 cell (J4 as was) when I delete the current columns H and I?

Thanks

Karl
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change cell color depending on two cell values 1
Membership list: column for no. of over 18s? 4
Losing Data From Formulas When Cell Variable Changes 6
keep old cell value and new cell value 2
Create if partial match then copy and paste data from one cell to another 1
If C2 is Sunday how do I make D 2 to the next day of the week 2
Translating Formulas to Functions 0
Time lines, Gantt charts and auto-populating cells: possible? 0

Top