Rostering form: Adding New Lines to a table about a totals calculation.

[omen666blue]

Hi all
I popped on here a few weeks ago asking for a way to have a button(macr
linked) prompt for a value from the user and then populate a new shee
using a Template

i was completely baffled by How to do this even though i got a good fe
responses (as i am very new to using macros in excel)

so iv gone back to the drawing board and and decided to add an easie
way to solve the problem. Now this is were you guys come in :

i basically want a button that you can press and once pressed it wil
find the Last line in the roster (but above the totals calculations) an
then add a new lines (or lines if its possible to prompt user to inpu
how many lines they want). I also need it to add the next correspondin
number in Columns A and AE

below is a picture of my Main rostering form. each cell containing DI
is a drop down that pulls from a main list of Job numbers and ON/OFF/HR
then display the details for that job number and all the calculation
are then done in the bottom of the sheet and sent to a calculations for
for working out average shift times ect ect ect

[image
http://i10.photobucket.com/albums/a133/Omen666blue/NewBitmapImage.jpg

i wont be able to change were the totals are calculated as this is ho
every one of the company's rosters are submitted for review so they hav
to be set out in this way (annoying i know!!

so any help would be Very much appreciated! please note im not ver
Macro Minded so please explain to me like your talking to a caveman :

 

[omen666blue]

Hi all!
I popped on here a few weeks ago asking for a way to have a button(macr
linked) prompt for a value from the user and then populate a new shee
using a Template.

i was completely baffled by How to do this even though i got a good fe
responses (as i am very new to using macros in excel).

so iv gone back to the drawing board and and decided to add an easie
way to solve the problem. Now this is were you guys come in

i basically want a button that you can press and once pressed it wil
find the Last line in the roster (but above the totals calculations) an
then add a new lines (or lines if its possible to prompt user to inpu
how many lines they want). I also need it to add the next correspondin
number in Columns A and AE.

below is a picture of my Main rostering form. each cell containing DI
is a drop down that pulls from a main list of Job numbers and ON/OFF/HR
then display the details for that job number and all the calculation
are then done in the bottom of the sheet and sent to a calculations for
for working out average shift times ect ect ect.

[image
http://i10.photobucket.com/albums/a133/Omen666blue/NewBitmapImage.jpg]

i wont be able to change were the totals are calculated as this is ho
every one of the company's rosters are submitted for review so they hav
to be set out in this way (annoying i know!!)

so any help would be Very much appreciated! please note im not ver
Macro Minded so please explain to me like your talking to a caveman

Any ideas guys?
Cheer

 

[Cimjet]

Hi
First, you shouldn't post on someone else post, your lucky to get a reply, start a new post, anyway here is a link to a sample file, try it out.
http://wikisend.com/download/101450/AddXRows.xls

 

[omen666blue]

Anybody figured out a way of doing this? im still racking my brain! i
sure there is an easy way!

regards
chri

 

[Cimjet]

Anybody figured out a way of doing this? im still racking my brain! im

sure there is an easy way!



regards

chris

I just downloaded the link from Wikisend. It's garbage, don't know what append, sorry
See this link :
http://cjoint.com/?BGDdsUWalpu
Hope this is working!!!
Cimjet