Cell Referencing with auto populating another cell???

[LYCAN]

Newbie here so please be kind. lol

So what I have; a lot number(1234) entered into H1, a station ID#(A,B,C or D) in H2 and the current date and time in H3.

What I am trying to do is reference the lot number and station ID# then enter the current date into that intersected cell.

	A	B	C	D	E	F	G	H
1	LOT NUMBER	ST 1	ST 2	ST 3			LOTNUMBER
2	1234						STATION ID
3	5678						DATE
4	9999

<tbody>
</tbody>

So If I were to enter 5678 into H1 and ST 2 into H2 and the current date into H3. Then C3 would have the date populated into it. Is this something that is doable? Thank you for any and all help.

 

[Special-K99]

Not with a formula.

The formula would have to be in all the cells B2:D3.
As soon as you change the values in H1:H3 the cell in B2:D3 that worked would then show an incorrect value.

I suggest VBA as the proper way to do this btu I'm no expert on VBA.

 

[LYCAN]

Thank you Special-99,

The more I read the more I see where VBA would be the way to go. Maybe a user form????

 

[MickG]

Perhaps something like this:-
https://app.box.com/s/bwmopc0z0sgnmmpyjyyix5v1505x9ss1

 

[LYCAN]

Perhaps something like this:-
https://app.box.com/s/bwmopc0z0sgnmmpyjyyix5v1505x9ss1

Thank you but nothing comes up when I click or paste the link.

 

[MickG]

Not sure what's happening, I've just downloaded it from you "Quote" link.
When you click that link you should be taken to "Box" opening page showing the sheet content , from that you need to click "Download" (top right) and save the file where you like .

If you still can't download it, let me know and I'll send the code for the Userform.

 

[LYCAN]

I was able to download and I believe this is going to work nicely. I believe I could not see the box due to me being on a Mac. Once I was on a PC, no issues.
Thank you very much for this. The more I use it the more I like the results.

 

[MickG]

You're welcome
Glad you have it working