hi all
i have 8 columns abcdefgh
what i am trying to do is when a "Y" is entered in column b i want the date to automatcally go into column
c and the time into column d and the same for "y" in column efg and the same for hij i have been trying
but i am a complete novice can anyone guide me i need the dates.times to be fixed and not change when the
workbook is opened as it will be shared a few people at tha same time ? help
Here is a macro solution. There are some potential problems I foresee using it. Nothing will happen if they don't put a Y in those columns.
Please Login or Register to view this content.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Hi Lloyd,
Find the attached with this code behind sheet1, that does what I think you want.
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks