Previous Topic Next Topic

Look to find a formul that will make an item rec

Closed
rwarren445 Posts 2 Registration date Monday January 13, 2014 Status Member Last seen January 15, 2014 - Jan 13, 2014 at 03:14 PM
 Blocked Profile - Jan 15, 2014 at 05:30 PM
Hello I am looking to track items received... I would like to build a box were we enter the NSN and the amount of the items... Date auto populate.


NSN (Item number)
Amount

Then it will auto populate into my spread sheet.

Thanks for any help.

3 replies

Answer 1 / 3
Blocked Profile
Jan 13, 2014 at 04:58 PM
Ok, you want a change based on the sheet change?


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If UCase(Target.Value) != "" Then
Target.Value = thedate;
End If
End Sub

You will need to populate the "thedate" variable with what ever info you wish to put on the sheet!


//ark
-Moderator/Contributor
0
Answer 2 / 3
rwarren445 Posts 2 Registration date Monday January 13, 2014 Status Member Last seen January 15, 2014
Jan 15, 2014 at 04:08 PM
thanks but I need it broken down if you can. Is there any way you can give an example of were these go?

Thank you
0
Answer 3 / 3
Blocked Profile
Jan 15, 2014 at 05:30 PM
Ok, hang tight, I have faith you can do THIS!

You have to have the "Developer" tab enabled to get to Macros. Enable your sheet to accept VBA MACROS(depending on your version of O/S, let me know!).

You will cut and paste the above code into the sheet "general" tab. Once you get into VBA (visual Basic for Applications), you will see an index on left of sheet names, click worksheet. Once you click on worksheet, the page should change states, and allow you to write code, paste the code into the page, and push the "Play" key.

Test it out. IMPORTANT. what version of excel!

I am here for you!

Have fun!


//ark
-Moderator/Contributor
0