Recent content by razor

Sorry squidinker, how can i import the data to a new sheet from the last formula? Thank you

Thanks Squidinker. That now works perfectly. Thats really superb. If you are ever around Bluewater, treats on me. Shades, Thank you also for your help. Same applies to you, if you are around Bluewater, my shout. Thank you so much.

Hello squidinker. I have tested it on my worksheet. The first column(sign) seems to work ok, but the second column comes up with a #NAME error. I am using excel 2003 and have installd this function in the VBA module so it now appears in the formulas list, but I still seem to be getting the...

Hello Squidinker. Thank you so much for the excel spreadsheet. I will have a play about with them formulas and updates and see what happens but you are certainly on the right track. Will this pull out any new changes in value on the second row? Thank you very much I am very grateful.

Helo Shades, Sorry for not being clear. These values in H get updated quite regularly. There are only 150 rows but the last one falls off at specified intervals as row 2 updates with new data, the other 49 are stored for comparison purposes. if there has been a flow of positive numbers in row 2...

Shades. Thank you for your reply. So these values in column D automatically change when the data changes? How are you wanting to determine that change? By formula? A different worksheet? How often are the values changed? The values change in all the columns continually. The change should be...

Thanks shades, have attavhed a workbook. Any help would be greatly appreciated. Many Thanks

cant upload image, too big and cant reduce it

I have attached an image to clarify things further. I am looking to find a specified value in the yellow column, in this case where the value changes from -ve to +ve, as shown by the orange cells. Then i would like to go to another column, same row and extract that value as shown by the green...

Hi, I am currently working on some excel workbooks and am struggling with how to proceed further. I have data that come in to excel, data that is in decimals and also in +ve and -ve format. This data is constantly changing. What i would like to do is select the column where the data input...