ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Schedule sheet (https://www.excelbanter.com/excel-discussion-misc-queries/156144-schedule-sheet.html)

jrxtc2000

Schedule sheet
 
I made a schedule sheet of my own from a template here.
A thru H is my job information.
K thru ET is my gantt chart for the run dates.
How can I delete a job from A thru H without wrecking the gantt calculations
in K thu ET?

Dave Peterson

Schedule sheet
 
I have no idea what your calculations are, but can you select (say) A7:H7 and
edit|delete|shift cells up?

Is there anyway you could separate your data onto one sheet and your
calculations on another? It might make editing easier.

jrxtc2000 wrote:

I made a schedule sheet of my own from a template here.
A thru H is my job information.
K thru ET is my gantt chart for the run dates.
How can I delete a job from A thru H without wrecking the gantt calculations
in K thu ET?


--

Dave Peterson


All times are GMT +1. The time now is 02:54 PM.

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