HELP.
I WANT THE CELLS IN COLUMN "A1 THRU A34" TO BE AUTOMATICALLY FILLED IN WITH
THE DAYS DATE & CURRENT TIME A.M./P.M. WHEN I POPULATE AN OPPOSING CELL IN
COLUMN "B1 THRU B34" AND I DO NOT WANT THE TIME & DATE TO CHANGE WHEN I
REOPEN THE SPREADSHEET. I ALSO WANT THE TIME OF DAY IN COLUMN "C1 THRU C34 TO
BE SUBSTRACTED FROM THE TIME OF DAY SHOWN IN COLUMN "D1 THRU D34. IS THIS
POSSIBLE IN EXCEL AND HOW WOULD THIS BE DONE. YOUR HELP WILL BE VERY MUCH
APPRECIATED. HELP!!!!!!! THANK YOU. REGARDS, JKLONEEAGLE

Use the worksheet Change event

See Chip Pearson's page on Events
http://www.cpearson.com/excel/Events.htm

sample code here:

http://tinyurl.com/kbtv4

--
Regards,
Tom Ogilvy




"JKLONEEAGLE" <(E-Mail Removed)> wrote in message
news:0E16EDC2-34DA-44BC-A5B2-(E-Mail Removed)...
> HELP.
> I WANT THE CELLS IN COLUMN "A1 THRU A34" TO BE AUTOMATICALLY FILLED IN
> WITH
> THE DAYS DATE & CURRENT TIME A.M./P.M. WHEN I POPULATE AN OPPOSING CELL
> IN
> COLUMN "B1 THRU B34" AND I DO NOT WANT THE TIME & DATE TO CHANGE WHEN I
> REOPEN THE SPREADSHEET. I ALSO WANT THE TIME OF DAY IN COLUMN "C1 THRU C34
> TO
> BE SUBSTRACTED FROM THE TIME OF DAY SHOWN IN COLUMN "D1 THRU D34. IS THIS
> POSSIBLE IN EXCEL AND HOW WOULD THIS BE DONE. YOUR HELP WILL BE VERY MUCH
> APPRECIATED. HELP!!!!!!! THANK YOU. REGARDS, JKLONEEAGLE

Thanks Tom for responding to my problem and what you have given me is very
intresting information which I will study. My problem is I am not a
programmer I am definatelly a user that is in over his head doing this sort
of thing and I was hoping to find a macro or formula that would solve my
problem. Thanks for your help.

"Tom Ogilvy" wrote:

> Use the worksheet Change event
>
> See Chip Pearson's page on Events
> http://www.cpearson.com/excel/Events.htm
>
> sample code here:
>
> http://tinyurl.com/kbtv4
>
> --
> Regards,
> Tom Ogilvy
>
>
>
>
> "JKLONEEAGLE" <(E-Mail Removed)> wrote in message
> news:0E16EDC2-34DA-44BC-A5B2-(E-Mail Removed)...
> > HELP.
> > I WANT THE CELLS IN COLUMN "A1 THRU A34" TO BE AUTOMATICALLY FILLED IN
> > WITH
> > THE DAYS DATE & CURRENT TIME A.M./P.M. WHEN I POPULATE AN OPPOSING CELL
> > IN
> > COLUMN "B1 THRU B34" AND I DO NOT WANT THE TIME & DATE TO CHANGE WHEN I
> > REOPEN THE SPREADSHEET. I ALSO WANT THE TIME OF DAY IN COLUMN "C1 THRU C34
> > TO
> > BE SUBSTRACTED FROM THE TIME OF DAY SHOWN IN COLUMN "D1 THRU D34. IS THIS
> > POSSIBLE IN EXCEL AND HOW WOULD THIS BE DONE. YOUR HELP WILL BE VERY MUCH
> > APPRECIATED. HELP!!!!!!! THANK YOU. REGARDS, JKLONEEAGLE
>
>
>

> I was hoping to find a macro or formula that would solve my
> problem

many of the answers to the questions in the second URL do just what you
ask - so you have found a macro.

Just adjust them for your particular problem.

--
Regards,
Tom Ogilvy

"JKLONEEAGLE" <(E-Mail Removed)> wrote in message
news:185F293D-9C69-40EA-A2E6-(E-Mail Removed)...
> Thanks Tom for responding to my problem and what you have given me is very
> intresting information which I will study. My problem is I am not a
> programmer I am definatelly a user that is in over his head doing this
> sort
> of thing and I was hoping to find a macro or formula that would solve my
> problem. Thanks for your help.
>
> "Tom Ogilvy" wrote:
>
>> Use the worksheet Change event
>>
>> See Chip Pearson's page on Events
>> http://www.cpearson.com/excel/Events.htm
>>
>> sample code here:
>>
>> http://tinyurl.com/kbtv4
>>
>> --
>> Regards,
>> Tom Ogilvy
>>
>>
>>
>>
>> "JKLONEEAGLE" <(E-Mail Removed)> wrote in message
>> news:0E16EDC2-34DA-44BC-A5B2-(E-Mail Removed)...
>> > HELP.
>> > I WANT THE CELLS IN COLUMN "A1 THRU A34" TO BE AUTOMATICALLY FILLED IN
>> > WITH
>> > THE DAYS DATE & CURRENT TIME A.M./P.M. WHEN I POPULATE AN OPPOSING
>> > CELL
>> > IN
>> > COLUMN "B1 THRU B34" AND I DO NOT WANT THE TIME & DATE TO CHANGE WHEN I
>> > REOPEN THE SPREADSHEET. I ALSO WANT THE TIME OF DAY IN COLUMN "C1 THRU
>> > C34
>> > TO
>> > BE SUBSTRACTED FROM THE TIME OF DAY SHOWN IN COLUMN "D1 THRU D34. IS
>> > THIS
>> > POSSIBLE IN EXCEL AND HOW WOULD THIS BE DONE. YOUR HELP WILL BE VERY
>> > MUCH
>> > APPRECIATED. HELP!!!!!!! THANK YOU. REGARDS, JKLONEEAGLE
>>
>>
>>

Your right Tom, I have been looking at them and making the adjustments.
Thanks a Million for your help.

"Tom Ogilvy" wrote:

> > I was hoping to find a macro or formula that would solve my
> > problem
>
> many of the answers to the questions in the second URL do just what you
> ask - so you have found a macro.
>
> Just adjust them for your particular problem.
>
> --
> Regards,
> Tom Ogilvy
>
> "JKLONEEAGLE" <(E-Mail Removed)> wrote in message
> news:185F293D-9C69-40EA-A2E6-(E-Mail Removed)...
> > Thanks Tom for responding to my problem and what you have given me is very
> > intresting information which I will study. My problem is I am not a
> > programmer I am definatelly a user that is in over his head doing this
> > sort
> > of thing and I was hoping to find a macro or formula that would solve my
> > problem. Thanks for your help.
> >
> > "Tom Ogilvy" wrote:
> >
> >> Use the worksheet Change event
> >>
> >> See Chip Pearson's page on Events
> >> http://www.cpearson.com/excel/Events.htm
> >>
> >> sample code here:
> >>
> >> http://tinyurl.com/kbtv4
> >>
> >> --
> >> Regards,
> >> Tom Ogilvy
> >>
> >>
> >>
> >>
> >> "JKLONEEAGLE" <(E-Mail Removed)> wrote in message
> >> news:0E16EDC2-34DA-44BC-A5B2-(E-Mail Removed)...
> >> > HELP.
> >> > I WANT THE CELLS IN COLUMN "A1 THRU A34" TO BE AUTOMATICALLY FILLED IN
> >> > WITH
> >> > THE DAYS DATE & CURRENT TIME A.M./P.M. WHEN I POPULATE AN OPPOSING
> >> > CELL
> >> > IN
> >> > COLUMN "B1 THRU B34" AND I DO NOT WANT THE TIME & DATE TO CHANGE WHEN I
> >> > REOPEN THE SPREADSHEET. I ALSO WANT THE TIME OF DAY IN COLUMN "C1 THRU
> >> > C34
> >> > TO
> >> > BE SUBSTRACTED FROM THE TIME OF DAY SHOWN IN COLUMN "D1 THRU D34. IS
> >> > THIS
> >> > POSSIBLE IN EXCEL AND HOW WOULD THIS BE DONE. YOUR HELP WILL BE VERY
> >> > MUCH
> >> > APPRECIATED. HELP!!!!!!! THANK YOU. REGARDS, JKLONEEAGLE
> >>
> >>
> >>
>
>
>