Delete data then move contents left

JazzSP8

Well-known Member
Joined
Sep 30, 2005
Messages
1,223
Office Version
  1. 2013
  2. 2010
Platform
  1. Windows
Hi All

I'm working a new spreadsheet to look after the departments holidays, I've thought of something I would like to include but don't really know where to start...
Holidays 2008.xls
KLMNOP
5AgentShiftHoursAgentShiftHours
6DonaldDuck09:00-17:007.5Pluto08:30-16:307.5
Voice


The data is set out like the above, the same three columns for Agent, Shift and Hours are repeated a total of 10 times (no more than ten people off at once).

What I would like to happen is that if I deleted Donald Duck from the spreadsheet by selecting his name and pressing the 'Del' key, I would like the 2 related cells in L & M to also be deleted, then whatever data is in the right hand cells to be moved down, removing the gap that would be created.

I am aware that warning message boxes need to be included, and a couple of other bits and pieces, but I know how to do that bit, its just this first bit I'm not sure about.

Can anyone help me with the starting point?

Thanks in advance :)

Jazz
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Watch MrExcel Video

Forum statistics

Threads
1,123,323
Messages
5,600,954
Members
414,417
Latest member
Nobu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top