suspect

Would anyone know the formula when copying down rows from row 1 it does the following: - where x can any positive number, e.g. if x = 4, the following from row 1 down would be 1 2 3 4 1 2 3 1 2 1 "" "" etc. e.g. if x = 3 1 2 3 1 2 1 "" "" etc. I suspect you would need the function row() and...

I have a macro that prompts a user to select a file that is subsequently saved as a sheet and the data used in calculations. If the user cancels at the prompt to select a file, how do I avoid an error and just exit the macro? I suspect it's something to do with OnError, but don't know the...

Hi, A query first before i put up my database for example. I want to search my database and return the value ( Profit ) for all possible combinations. ( Combinations could very well be into the 1000's ) there are 7 columns from the database where all combinations can be chosen from, in each...

I've been given the responsibility to fix a broken macro of a termed employee. This individual used the code listed below but I don't understand he used the Windows object rather than Sheet object. Is there any logical reason to do this? I suspect there must be a reason that I'm not aware of...

I am doing INDEX and MATCH to find a date in a source table that matches and returns a percentage in the table I'm using. The table where I am doing the INDEX and MATCH has 48.20%. So I'm indexing the date that matches that 48.20% in the source table (see below) and it says 3/7/2019. I know...

I have the following INDEX and MATCH formula . . . =IF(C31="Confirmed Sideways",INDEX('D1'!$Q$1:$Q$100,MATCH(F31,'D1'!$S$1:$S$100,0)),IF(C31="Suspect Sideways",INDEX('D1'!$L$1:$L$100,MATCH(F31,'D1'!$N$1:$N$100,0)),IF(C31="Confirmed...

Afternoon All, i'm after some help in emailing a range of cells depending on which cell changes to "on suspect list" See example below. A B C D <colgroup><col...

I have a sub which starts with an On Error GoTo and then continues to use a PasteSpecial. (I can paste code if required, but I suspect there may be an easy answer from someone here!) Now if there is nothing to paste it does not go to the label but just stops at the PasteSpecial. I suspect this...

I have a report where the cells are in text in this format "2018021409012900" it is YYYYMMDDHourHourMinMin. The last four digits are milliseconds which I don't need. I need to convert this to a date & time cell that is more legible. I can think of some labor intensive ways to do this, but I...

I am testing one value as a multiple of another and suspect that they are stored differently. I have a routine accumulating money values in various denominations. There is a text box for each coin denomination ( eg 50 cent,20 cent, 10 cent etc) called tb10cents, tb20cents etc. I wish to prevent...