#31
|
|||
|
|||
you can now delete a child - selected thier first name adn click the delete button |
#32
|
|||
|
|||
Great seems to be working well. I finished up a clean copy with all the equations every where
Just to have the most current version. |
#33
|
|||
|
|||
So question hear. digging into this a little.
When we need to add columns to SS hours or rows to Inventory Counts How do we do that? Do we have to adjust all the code ? Some years we do more locations then other years and you never know because we get assigned location by the Council for cub scouts. |
#34
|
|||
|
|||
We would need to change parts, or to make it a variable
for example, this line has a varible for the number of rows (namescount + 4), so we would need to work out where the new 'J' would be. Code:
Set SSOldData = Worksheets("SS Hours Scoutbook Money").Range("a5:j" & NamesCount + 4) Code:
SSLastCol = Chr(64 + Worksheets("SS Hours Scoutbook Money").Range("4:4").Find(what:="Prizes").Column) Code:
Set SSOldData = Worksheets("SS Hours Scoutbook Money").Range("a5:" & SSLastCol & NamesCount + 4) Edit and the totals columns.... |
#35
|
|||
|
|||
Easy for you LOL..
SS hours prizes would always be the last row. Green box on the left can that expand down to match? Inventory Counts Would be a giant copy Row 3,4,5 and put at bottom. I like the buttons you have done that makes it really easy.. Is it worth the effort to make button to insert Columbs on the SSHours and Row cluster ont he inventory counts. That might be asking much but we deff will need to insert as we grow and shrink. If that makes sense Do you see any way to combine the SS hours and inventory Counts to one page that would simplify it all or is it better to keep them separated since they are doing 2 different functions? |
#36
|
|||
|
|||
So I been trying to put the code in places and Got this really messed up.. Wanted to see if it was quick for you if you would mind.. I just dont understand the code well enough to figure out all the places it needs to be adjusted
|
#37
|
|||
|
|||
Hello mate, been tied up for a couple of days as work wanted me to work! Madness
I was going to have a look over the next couple of evenings, will try and you get you somthing back soon |
#38
|
|||
|
|||
I understand that sad reality LOL.
Thanks for checking in |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Comparing between 2 worksheets and retreiving data if a match | FUGMAN | Excel Programming | 8 | 02-18-2017 09:47 AM |
Counting only the unique names in 3 columns on separate worksheets. | Ryga38 | Excel | 1 | 04-15-2016 07:21 AM |
Match Multi Cells | gdavey | Excel Programming | 1 | 09-06-2015 11:09 AM |
Index Match Function across different worksheets | shay_mt | Excel | 2 | 04-27-2015 06:04 AM |
Multi Level Subtotals w 2 Grand Totals That Don't Match | DavidW | Excel | 3 | 10-09-2014 07:08 AM |