Recent content by Nullsweat

Hola I have a question concerning the VLOOKUP function. I have a list of people and I want to match the other list of people to find out who is in the first list. Please help me, I am pulling my hair out. Thanks Sean

Hola I have an Excel file with locations and qtys and SKU #s. Then I would like a scanner to input a SKU into a txt file which then would reference the Excel file and let the user know where the product lies? Is this possible? would someone give a hint where I might start researching? Thanks in...

Hola I need Excel to sort a column of this = P3002A,P3002B,P3003A,P3003B,P3004A etc into 2 seperate columns of Odds and Evens. Does anyone know a simple VBA script to do this? Or would it be easier just to create the columns using the Ctrl-H function? Thanks :) Sean

Thanks to all Both answers are good places to start Sean :)

Hola :) I always see the Dim fs, f, f1, fc, s, sf Dim ofile As String Dim fpath As String 'Find old import text files in Imported_Data directory and delete Set fs = CreateObject("Scripting.FileSystemObject") I am semi-proficient in macros, but I have no idea what this stuff is...

I forgot to include that part. <sheepish grin> A) I want to record a formula so that it computes the Handling Formula, then copies the formula down I tried having the Formula on the MASTER sheet and copying it, but how would you tell the macro that you want to go to the 3rd sheet THIS time...

Hola :) I am trying to use the Macro Recorder in Excel to record this formula- =IF(OR(E2=0,F2=0,G2=0,E2=&quot;&quot;,F2=&quot;&quot;,G2=&quot;&quot;),&quot;Bad...

THANK YOU .....see I noticed that &quot;named range&quot; and my friend said that you can name a range instead of using Columns/Rows. I have read quite a few books and NEVER heard that mentioned. Thanks :) Sean

Hola :) My macro takes does a webquery for the data, then takes a changing list of names-sorts them and then does a vlookup on the data to get Productivity #s. The problem is that the names in the list are not always represented in the data. Therefor, I have added a ISERROR to get rid of the...

Thanks for all the help.. [smile] Zathras and Rob especially. I am sorry Skip but I am not proficient enough in VBA yet to use something like that. I can almost follow the code, but as of yet, have not used any variables. I do most of mine with the Macro Recorder. <sheepish grin> But I do...

Hola [glasses] I am trying to pull in some data via a web query. However the query gives associate names and units. I then want to differentiate users in a receive function vs any other function. I use a VLOOKUP for that. Here is where my problem starts. As my web query wont always be the same...

Sandy 11.5 2342.0 203.65 Saundra 0.0 0.0 Sharon 0.0 0.0 Sheila 5.5 1375.0 250.00 Toni 9.0 1897.0 210.78 Traci 8.2 1150.0 140.24 Tracy 9.0 3051.0 339.00 Valerie 10.0 1782.0 178.20 Here is some of the data, I am trying (as you surmised) to only list the names with Data for that week. I am...

Sandy 11.5 2342.0 203.65 Saundra 0.0 0.0 Sharon 0.0 0.0 Sheila 5.5 1375.0 250.00 Toni 9.0 1897.0 210.78 Traci 8.2 1150.0 140.24 Tracy 9.0 3051.0 339.00 Valerie 10.0 1782.0 178.20 Here is some of the data, I am trying (as you surmised) to only list the names with Data for that week. I am...

Hola [morning] I have production data that is manually entered, then converted via formulas to figure out Throughput by Process Path. However not everyone does the same job every day. So the Week Ending figures have several zeroes in them. I am trying to create control charts based upon that...

THANKS ::) I am assuming that Abs stands for Absolute? But why the - Now and why < .02? If I may ask? :) Sean