Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-26-2018, 03:40 PM
NoSparks NoSparks is offline Auto Populate Sheets? Windows 7 64bit Auto Populate Sheets? Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

See if this works for you...
Removed passwords.
Locked date cells.


Sheets are protected without password.
Attached Files
File Type: xls new-Timesheet-2019_v2.xls (49.0 KB, 9 views)
Reply With Quote
  #2  
Old 07-27-2018, 07:02 AM
ShankedS ShankedS is offline Auto Populate Sheets? Windows 7 64bit Auto Populate Sheets? Office 2010 64bit
Advanced Beginner
Auto Populate Sheets?
 
Join Date: Oct 2014
Posts: 62
ShankedS is on a distinguished road
Default

That's neat. I'm assuming you used VBA code? I'm going to need to make some modifications to get it working properly for my purposes (the state financial year, and, thus, our year, is from July to June.) Is there a function I can look up to find the code, or?

Last edited by macropod; 07-27-2018 at 01:51 PM. Reason: Removed inflamatory comment
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Populate Sheets? Auto populate & auto calculate values from other sections in the same word document Frantic Word VBA 2 01-24-2015 04:54 PM
Auto Populate Sheets? Auto-populate?? Futsal1st Word 1 05-23-2014 03:03 AM
Auto Populate Sheets? auto cell populate 2 Stevejd58 Excel 3 08-20-2013 04:23 PM
Auto Populate Sheets? auto cell populate Stevejd58 Excel 14 05-13-2013 02:22 AM
auto populate to a PDF file jerrymbna22 Excel 0 07-12-2010 02:19 PM

Other Forums: Access Forums

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


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