Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #31  
Old 10-26-2020, 03:16 PM
Purfleet Purfleet is offline Multi Worksheets get Columns to match Windows 10 Multi Worksheets get Columns to match Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

you can now delete a child - selected thier first name adn click the delete button
Attached Files
File Type: xlsm Master popcorn Template_Lafko_New_v1.xlsm (113.8 KB, 5 views)
Reply With Quote
  #32  
Old 10-26-2020, 06:34 PM
dlafko1 dlafko1 is offline Multi Worksheets get Columns to match Windows 10 Multi Worksheets get Columns to match Office 2016
Advanced Beginner
Multi Worksheets get Columns to match
 
Join Date: Apr 2019
Posts: 31
dlafko1 is on a distinguished road
Default

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.
Attached Files
File Type: xlsm Master popcorn Template_Lafko_New_v1 (2).xlsm (119.3 KB, 6 views)
Reply With Quote
  #33  
Old 10-27-2020, 07:14 AM
dlafko1 dlafko1 is offline Multi Worksheets get Columns to match Windows 10 Multi Worksheets get Columns to match Office 2016
Advanced Beginner
Multi Worksheets get Columns to match
 
Join Date: Apr 2019
Posts: 31
dlafko1 is on a distinguished road
Default

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.
Reply With Quote
  #34  
Old 10-27-2020, 07:50 AM
Purfleet Purfleet is offline Multi Worksheets get Columns to match Windows 10 Multi Worksheets get Columns to match Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

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)
If we can assume that the word 'Prizes will always be the last column in the table and it will always be in row 4 we can do

Code:
SSLastCol = Chr(64 + Worksheets("SS Hours  Scoutbook Money").Range("4:4").Find(what:="Prizes").Column)
Then the orginal row becomes

Code:
Set SSOldData = Worksheets("SS Hours  Scoutbook Money").Range("a5:" & SSLastCol  & NamesCount + 4)
Might need updating in 7 or 8 places, easy enough


Edit



and the totals columns....
Reply With Quote
  #35  
Old 10-27-2020, 07:55 AM
dlafko1 dlafko1 is offline Multi Worksheets get Columns to match Windows 10 Multi Worksheets get Columns to match Office 2016
Advanced Beginner
Multi Worksheets get Columns to match
 
Join Date: Apr 2019
Posts: 31
dlafko1 is on a distinguished road
Default

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?
Reply With Quote
  #36  
Old 10-29-2020, 05:01 AM
dlafko1 dlafko1 is offline Multi Worksheets get Columns to match Windows 10 Multi Worksheets get Columns to match Office 2016
Advanced Beginner
Multi Worksheets get Columns to match
 
Join Date: Apr 2019
Posts: 31
dlafko1 is on a distinguished road
Default

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
Reply With Quote
  #37  
Old 10-29-2020, 05:40 AM
Purfleet Purfleet is offline Multi Worksheets get Columns to match Windows 10 Multi Worksheets get Columns to match Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

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
Reply With Quote
  #38  
Old 10-29-2020, 05:53 AM
dlafko1 dlafko1 is offline Multi Worksheets get Columns to match Windows 10 Multi Worksheets get Columns to match Office 2016
Advanced Beginner
Multi Worksheets get Columns to match
 
Join Date: Apr 2019
Posts: 31
dlafko1 is on a distinguished road
Default

I understand that sad reality LOL.

Thanks for checking in
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multi Worksheets get Columns to match Comparing between 2 worksheets and retreiving data if a match FUGMAN Excel Programming 8 02-18-2017 09:47 AM
Multi Worksheets get Columns to match Counting only the unique names in 3 columns on separate worksheets. Ryga38 Excel 1 04-15-2016 07:21 AM
Multi Worksheets get Columns to match 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 Worksheets get Columns to match Multi Level Subtotals w 2 Grand Totals That Don't Match DavidW Excel 3 10-09-2014 07:08 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft