/m2296
Mike,

Create the following in a column in the 'registered' sheet and use the 'vlookup' function using the persons name (or ID if applicable) to look in the 'attended' sheet (name a range on this sheet first) so something like: =vlookup(*person_name or id,range on attended sheet,column in the range where the data is*,FALSE) -> 'FALSE' means an exact match, and this should get the value and put it next to the registered column and you can then look at them together.

HTH

Mark

On Thu, Jan 14, 2010 at 12:52 AM, QT - Mike Cooper <
qtopic-27-tHAhkTQwWtmq@quicktopic.com> wrote:

>



--
Kind Regards,

Mark Percival
07544597880
ageoconsultant@gmail.com
< replied-to message removed by QT >

Edited by author 14-01-2010 12:36 PM
/m2296
Is it possible to use the same spreadsheet for both registration and attendance? You would only need columns for Name, Registration Y/N, Attendance Y/N. Then create the formulae to count those who reserved but did not attend and those that attended without reservation. No special code or macros. By far the simplest solution.

If you are relying on code to compare names from two different sheets, you may still run up against the problem where you have "John Smith" on one sheet and "J.Smith", "J Smith" or "John H. Smith" on the other. Same person, different spelling/spacing etc; and more complicated code and algorithms to pick out all the different spelling possibilities.

On My spreadsheet instead of being lettered at the top of each column it's numbered. Please Help!

Nicole,

If you're using 2007 go Office Button > Excel Options > Formulas and uncheck "R1C1 Reference Style"

For 2003 go Tools > Options > General Tab and uncheck "R1C1 Reference Style"




_________________
Gary

< replied-to message removed by QT >

GARY! THANK YOU SOO MUCH! YOU SAVED MY BUTT! YOU ROCK THANKS SOOO MUCH

Nicole,

You're very welcome. Have a great weekend!


_________________
Gary


< replied-to message removed by QT >

Edited by author 23-01-2010 03:27 AM
www.meadinkent.co.uk gave me codes to display excel numbers as word..my problem is what is then the formula in my worksheet? please help..?

I am looking to convert data in to what would look like a cv when looked at by client, any help would be great

any folks here to custom work?

rather "do" custom work?

If so please respond to mailnmotion@aol.com
Thanks

I AM CREATING A MAP BOOK INDEX WHICH WILL BE PRINTED ON 11X17 PAPER. I HAVE THE INDEX IN EXCEL AND I AM TRYING TO GET THE INDEX TO PRINT IN ORDER SIDE BY SIDE ON ONE SHEET OF PAPER. NOW WHEN I PRINT I HAVE ONE SIDE OF THE PAPER LOOKING LIKE IT SHOULD BUT THE OTHER SIDE IS BLANK AND WHAT I WANT ON THAT SIDE GOES TO THE SECOND PICE OF PAPER. I HOPE SOMEONE CAN UNDERSTAND WHAT I AM SAYING. PLEASE HELP IF YOU CAN.
THANKS

/m2309 Karah, I would simply enable viewing of page breaks so you know where they are and the ones that go over onto page two copy and paste to adjacent columns.
HTH

On Fri, Jan 29, 2010 at 5:43 PM, QT - KARAH <
qtopic-27-tHAhkTQwWtmq@quicktopic.com> wrote:

>
< replied-to message removed by QT >

Hi I wanted the example excel sheet for making graphs update automatically with new data, instead I've only got information which tells me how to make a web page from excel. I appear to be missing GraphMain. Can you send this or provide a refund

I tried to contact you via the form, but it came up with an error.

Sbcsub@yahoo.co.uk

I want to import info from a infopath form on a sharepoint server into excel. The problem is that the infopath form has some fields and a repeating table which can have one or 10 rows. How can i import all the forms from a Sharepoint Forms Library into excel with each form's data into a row without manually creating a data connection to each form on the sharepoint.

Really hope you can help me to automate this with VB code

Appreciate any help.

Thanks
corniel@absa.co.za