Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-03-2012, 06:04 PM
macropod's Avatar
macropod macropod is offline Display history for spreadsheet data Windows 7 64bit Display history for spreadsheet data Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default


Hi cjaye,

Automating the whole process with vba is quite straightforward, even if new vehicles need to be catered for. Testing whether a given vehicle is listed on the 'Mileage History' sheet and adding a new column for that vehicle isn't at all difficult; neither is adding a new row for each month. Likewise, catering for a new vehicle on the 'Main' sheet appears to require nothing more complicated than copying columns A:G down one line - even if the addition of the new vehicle on the 'Mileage History' sheet entails inserting the new vehicle's column between a pair of the existing ones. That's a benefit of the formulae I've used on the 'Main' sheet.

Without knowing more about the format of the data you're processing, there's a limit to how much I can help you with the coding. As I said, though, it's all quite straightforward. See attached. The 'Demo' macro inserts some data for new & existing vehicles, then updates the main sheet's layout to reflect the new vehicle data.
Attached Files
File Type: xls cjaye.xls (68.5 KB, 14 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 05-08-2012, 08:03 AM
cjaye cjaye is offline Display history for spreadsheet data Windows XP Display history for spreadsheet data Office 2007
Novice
Display history for spreadsheet data
 
Join Date: Mar 2012
Posts: 6
cjaye is on a distinguished road
Default

Thank you very much Macropod for your time in helping me. You gave me some great ideas to consider. I knew there had to be a straight forward way to do this just didn't have the knowledge. My user wants the veh # along the left margin (there 500 or so), so I will try re-working your code to accomodate that. Thanks again.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying cell data in another spreadsheet Colonel Biggs Excel 0 07-01-2010 07:37 PM
Client Payment History GMatos78 Office 0 04-22-2010 03:40 PM
Display history for spreadsheet data Data Set Display Size - PP 2007 TonyMan PowerPoint 1 04-14-2010 05:45 AM
Displaying data from spreadsheet in Userform darklide Excel 0 03-12-2010 05:42 AM
CAUTION!! Sorting a spreadsheet with hidden columns will trash your data. psmaster@earthlink.net Excel 0 11-24-2009 11:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:09 PM.


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