Search results for query: *

I finally got it, thank you skip

Hi Skip: Using the Import Data, Excel Queary I am able to get the table to appear on a new sheet in the file. The table I am referring to is the table above with 3 columns. The full table appears. I am not sure from there what I should do. The first test number does appear in A2 as you...

Hi Skip: I understand the reference part and adding the sheet. Current I can get the Queary and all data onto the new sheet on as shown above. After that, I am confused, do I need to use a macro now? Or how do I input the items you wrote? To keep things simple, the file name is test log and...

Hi Skip: Thank you now I got the Query to work. I can see my tables inside of the sheet. My confusion right now is that if I have a new sheet open and Cell F2 is to contain the next available test number which from the list above would be AM-11-024. How can I use the Queary to get only that...

Hi Unsolved coding, thanks for you suggestion. I was looking at trying to use a function with a macro but don't have enough knowledge to know where to even start. Looking at the above items I provided, I want to be able to open the file then look for the next test number which is empty. I...

Hi Skip: The "table I have is simple" but excel does not see it a table? Test Number Part Number Name AM-11-001 17C582-000[] Jim Neuron AM-11-002 625392-0000 Jim Neuron AM-11-003 625392-0000 Jim Neuron AM-11-004 253218-5212 Jim Neuron AM-11-005 75C812-0004 Jim Neuron AM-11-006 75C553-0003...

Hi Skip: Thanks for the update. I tried to use the MS Query but I am sorry I am confused. The test log is in table form with 1 header on top. But when I try to use the MS Queary it say not in table form. I don't understand the data is a table form. Can you advise what I am doing wrong for...

Hi Skip: Thank you for fast reply. The files are all Excel. I do not have any code, and I am not sure if code is needed or if a function can do it. I have a Excel file named Test Log which has a list of sequential test report numbers. For example: AM-11-001, AM-11-002, etc. Normally we go...

Hi I am new to here: Please go easy on me. I have a sequential set of numbers in Column A: For example Column A Column B Test-1 Bob Test-2 Tom Test-3 Test-4 What is the code or function I need to select the first empty cell location in column B but return the value for the...