Recent content by indesisiv

That makes sense now. I didn't have data that matched in the first row so i didn't notice that it was missing it out.

Thanks for this i will see if I can sort it out. I have deliberatly taken out the header rows, I will find a way to clear the destination sheet or copy one header across. As it is going to pull data from about 20 sheets i didn't want to confuse the copy to just take one header.

I have found an example and modified that a bit. I have it working for a single button on an active sheet for 1 column of the data but it shouldn't be to hard to get the other section of the data. Can anyone help with putting this code onto any other sheet so that it loops round all the...

Hi, I am trying to get exel to copy data from several worksheets and place the data in another sheet. In this case there are 2 parts. I want to copy data from all of the sheets that begin with stdy based on the following I want to copy the data in cells A:H based on the value in cell G and...

I'll have a play with queries later .. in the mean time thanks for the code .. it works great.

I am trying to use DMax to sort out some number issues i have. Here is what i want to do. I have a field (Text) made up of a 4 letter code (AAAA) then a number. WHat i want to do is grab the highest number from this. where the code matches what is in a text box. I have got the following...

My name is Bloody Davy Flint All ready to go pillagin', plunderin' and consumin' o' the rum!

We'll be needing one of these then.

He followed it up rather well with his performance on the pitch afterwards. Not sure throwing up is such a good celebration. However ... bring on portugal (minus 2 players :D )

YAY ... That at least would mean less politicians.

Me and my GF are currently in this position. And i assure you that the desicion is not an easy one to make (in fact we have not made it yet even after 2 weeks extensive scans and an MRI). I would say that our decision is not based on any arbitary govermental limit at all. Purely based on our...