Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-12-2012, 02:48 PM
Biggy Biggy is offline excel 2002, how to use a macro to find a field and add a date to the end of the row Windows Vista excel 2002, how to use a macro to find a field and add a date to the end of the row Office 2000
Novice
excel 2002, how to use a macro to find a field and add a date to the end of the row
 
Join Date: May 2012
Posts: 1
Biggy is on a distinguished road
Default excel 2002, how to use a macro to find a field and add a date to the end of the row

Help needed here in any way as im quite stuck!



I have a customer base that i want to contact every couple of months and record when i do. this is always being added to too.

my plan was to use an INDEX to show the people to contact that week, then i wanted to update those rows only with todays date when i contacted them without going back to my data sheet and try and find all

the fields are... and i want to add the date to "contact letter1", then next time "letter 2" etc
Surname Flat number Building name Number Street Town County Post code
contact Letter 1 contact Letter 2 contact Letter 3 contact Letter 4 i hope that makes sence, any other idea on how to do this would be great.

thanks in advance.

Big Jeff
Reply With Quote
  #2  
Old 05-12-2012, 03:03 PM
macropod's Avatar
macropod macropod is offline excel 2002, how to use a macro to find a field and add a date to the end of the row Windows 7 64bit excel 2002, how to use a macro to find a field and add a date to the end of the row Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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 Jeff,

It would be helpful if you could attach a workbook with some sample data to a post, so we can see what we're dealing with. You can do that via the paperclip symbol on the 'Go Advanced' tab.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
macro

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel 2002, how to use a macro to find a field and add a date to the end of the row Macro to find text and replace with form field containing that text iiiiifffff Word VBA 16 06-04-2016 01:47 AM
Please help me with creating due date field Artemio Word 1 03-01-2012 08:10 PM
excel 2002, how to use a macro to find a field and add a date to the end of the row Mail merge will not format date field generated by Excel IF statement borntorun75 Mail Merge 3 12-16-2011 06:28 AM
Formula to subtract one month from due date field in reminder field ghumdinger Outlook 1 10-01-2011 12:09 AM
excel 2002, how to use a macro to find a field and add a date to the end of the row Use SMALL or LARGE to find date udea Excel 4 05-02-2011 09:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:24 PM.


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