Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Look to find a formul that will make an item rec [Closed]

Report
Posts
2
Registration date
Monday January 13, 2014
Status
Member
Last seen
January 15, 2014
 -
 Blocked Profile -
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.
See more

3 replies

Answer 1 / 3

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
Answer 2 / 3
Posts
2
Registration date
Monday January 13, 2014
Status
Member
Last seen
January 15, 2014
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
Answer 3 / 3

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
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!