Search results for query: *

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

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...

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

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...

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...

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...

Hola ::) I am new to this group so bear with me please ::) I have a sheet that updates with each new days info, it has a cell with whatever that days date is- in it. I then have a weeks worth(Sunday, Monday etc) of sheets that I want to pull info from that first sheet BASED on the date. The...