Recent content by JasonLevan

good idea on the 3860, i have one more quirk to add. can i make this macro search out for the first empty cell, say i run it once and then need to go back and run it again to add another number, right now it starts back and overwrites it. Can you write this out for me so all i have to do is...

Below is a macro i got from a buddy and it works perfect only i need to add another imput box called item qty the info will record into column b next to what went into column a. and then it will continue on just like before. can anyone help me out Sub additems() ' ' Dim NewValue X = 1 A...

I am needing a macro that will list all files in c:/scans and when it list them then allow me to link to them if possible. But atleast list them

I need a macro that will have a imput box to imput item numbers, i need it to repeat itself until i type the word done in the imput box. Can anyone help

Column A Column B Column C 248.............. test.................4 2410............ test2................10 I need a macro that I can imput a number from column A into that will return then Info in column B in that message box and the info into column C, but give me the option of...

In column a I have number 1,2,3,4,5...etc number each row, i need a macro to seek out a number I imput into a message box saw number 5, then find that row and delete that row. Thanks Alot

good start but I dont want it to ask me if i want to stop every time, can it just notice the "stop command" if i enter it into the item number field

works!!!!! thanks man maybe you can fix my other problems i posted

works!!!!! thanks man

I saw this but my problem is that once I switch over to a new workbook the one I want to close is not the "Active.Workbook" so how do i get it.

I have the following macro Sub TestMacro() Range("A2").Select ActiveCell.FormulaR1C1 = InputBox("Item Number") Range("B2").Select ActiveCell.FormulaR1C1 = InputBox("Qty #") Range("C2").Select End Sub it works fine but i want it to repeat itself over and over until I end...

i need a macro that will take my numbers in column a and format them into column be 3 spots. so it its a single number it read 004, a two digit number reads 040, but if its a 3 digit number it just puts that number. Any help would be greatly appreciated. Thanks column A Column B...

i fixed the 47500 problem but it stops at the "" in the middle

but how do i get it to close the other one

=if(isna(vlookup(c3,a$3:b$7500,2,false),"",vlookup(c3,a$3:b47500,2,false)) it says i entered to many arguments, where is my mistake