Search results for query: *

SkipVought - you are an absolute star ! that works like a charm thank you so much

Thanks for the tip SkipVought, I couldn't see how I uploaded a s/sheet hence the screen shot. I have hopefully added a spreadsheet with some notes.... https://files.engineering.com/getfile.aspx?folder=cef51e0f-e11f-4817-8d19-432455ee35ae&file=S-Sheet.xlsx

Hi, Thanks for this and I am sorry I know it is me very poorly explaining and showing what I needed, but I think it is very nearly there... I am hoping this helps in showing what I want - my wife (No sexist intent in that just she was downstairs and doesn't know what I am trying to do)...

Thanks really appreciate the help - column 2 should be the next working day after column 1 not a month after

I am given the dates for task 1, they do change frequently, so I am currently manually moving dates for task 2 as I cant get a formula to work and it's taking hours every week making sure i only have two activities on one workday Task 2 feeds other dates in a very long process, these are...

Hi, Sorry it is really hard to explain (to me anyway) but will try The first date is when a simple task when part 1 of a series of activities will complete, this is a very simple task where many items will be complete on a single day. Step two, the second date in my screen shot, is where I...

Hi all I have a large spreadsheet with a series of activates on the majority can be done the same day, however further down the process we can only do two each day. So is there a formula that anyone knows that looks at a row of dates and then only allocates two activities on any one weekday...

Blimey someone has got out the bed the wrong side this morning....

Hi, Can anyone help, i need to import multiple Excel file to an access table, all the same fields, but when they import it adds the file name to a new colmun in the table... The files are imported weekly, around 50-60 of them Thanks in advance....

Hi, Can anyone help, i need to import multiple Excel file to an access table, all the same fields, but when they import it adds the file name to a new colmun in the table... The files are imported weekly, around 50-60 of them Thanks in advance....

Not sure, i'm on Jupiter where are you ? I did say I did it another way as I couldn't get the formula to work as I was trying, this did the job, and why it looks the way it does

I re-rote the formula to use index and match, this is what it looks like: =IFERROR(INDEX('Sheet1!D1:D1423,MATCH(MIN('Sheet2'!R2:R1423),'Sheet1'!R1:R1423,FALSE),1),"")

Thanks the formula above didn't work either but I've now done it a different way with index and match gives me the results I require, thanks for the help

Sorry, the workbook has two sheets - Sheet1 and Sheet2 - by using the "Row" formula I can locate the data I need in sheet1 and it gives for example row 300. So I now know in sheet1 the data is in row 300, so I now need the information from Column A again in sheet1. The contents of that I need...

C3 has the row number in the sheet I want the data to come into, the letter "A" is in sheet1

Thanks Skip - still a small problem,the data is in a separate sheet so it looks like this =INDIRECT('Sheet1'!"A"&C3) says error in formula

Hi, I have done this before but totally cant remember how to do it ! If I know a column letter say A, and cell contains the row number how do I join them so it can be used in a formula ?

Hi, Thanks I got it sorted using this code: ------ Option Compare Database Global GBL_Category As String Global GBL_Icount As Long Public Function increment(ivalue As String) As Long If Nz(GBL_Category, "zzzzzzzz") = ivalue Then GBL_Icount = GBL_Icount + 1 Else...

Thanks for this, I'm not used to coding so apologies for asking another problem I now have. The change now gives me this error in the top line of code Function DoIT()in the following code: ----- Compile error: Method or data member not found -----

Hi, I'm trying to use this code and get a error here: Set RS = CurrentDb.Recordsets("test") Error says: ==== Run time error '3265' Item not found in this collection ===== Any ideas ?