Search results

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

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 need a macro that will open one workbook and go to it, but close the one it just came from so i dont have it open anymore. It does not need to save changes when it close. Thanks

I am having a horrible time figuring out something i am sure is simple. In column A I have 7500 item numbers, In column B I have there prices. In column C I have NEW Items that just came in and column D has the prices for those numbers. What i need is a macro to search column A for the...