Protected sheet - add rows & fix Summary
 

Hi All,

I have a workbook, with anything from 5 rows to 380 rows of dat
(depending on the supplier on how many store they have) in 8 columns.
2 questions:
Each supplier has a protected sheet I supply, to enter the data fro
each site. But on occasion, the supplier needs to add rows to enter ne
sites or may need to delete rows (sites).
How can I do this?? (bearing in mind the following:)
Also as I am trying to automate this (with help from Ron de Bruin'
site: http://www.rondebruin.nl/tips.htm), how could I fix the range o
the suppliers sheet, to pull in the summary data? (At the moment it i
set to A800:H800 and A802:C802). Deleting or adding rows messes thi
all up!

Looking forward to some help:)
All the best,
Dav

--
deejay
-----------------------------------------------------------------------
deejayh's Profile: http://www.excelforum.com/member.php...fo&userid=3411
View this thread: http://www.excelforum.com/showthread.php?threadid=54153

Protected sheet - add rows & fix Summary
 

check out this site to learn dynamic ranges, as the list increases s
does the range

http://contextures.com/xlNames01.html#Dynami

--
davesexce

-----------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...fo&userid=3170
View this thread: http://www.excelforum.com/showthread.php?threadid=54153