| Who | When |
Messages | |
|
|
|
| Mark Percival
|
2297
|
 |
|
14-01-2010 09:39 AM BST
|
|
/m2296Mike, 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 >
|
Kevin Singleton
|
2298
|
 |
|
14-01-2010 12:34 PM BST
|
|
Edited by author 14-01-2010 12:36 PM
/m2296Is 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.
|
| Nicole
|
2299
|
 |
|
15-01-2010 09:00 PM BST
|
|
On My spreadsheet instead of being lettered at the top of each column it's numbered. Please Help!
|
| Gary McAninch
|
2300
|
 |
|
15-01-2010 09:22 PM BST
|
|
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 >
|
| Nicole
|
2301
|
 |
|
15-01-2010 09:32 PM BST
|
|
GARY! THANK YOU SOO MUCH! YOU SAVED MY BUTT! YOU ROCK THANKS SOOO MUCH
|
| Gary McAninch
|
2302
|
 |
|
15-01-2010 09:34 PM BST
|
|
Nicole,
You're very welcome. Have a great weekend!
_________________ Gary
< replied-to message removed by QT >
|
| Mashall
|
2303
|
 |
|
23-01-2010 03:26 AM BST
|
|
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..?
|
| Phillipa Barker
|
2304
|
 |
|
27-01-2010 05:54 PM BST
|
|
Deleted by author 27-01-2010 05:54 PM
|
| Phillipa Barker
|
2305
|
 |
|
27-01-2010 05:55 PM BST
|
|
I am looking to convert data in to what would look like a cv when looked at by client, any help would be great
|
| John
|
2306
|
 |
|
28-01-2010 09:21 PM BST
|
|
any folks here to custom work?
|
| John
|
2307
|
 |
|
28-01-2010 09:21 PM BST
|
|
rather "do" custom work?
|
| John
|
2308
|
 |
|
28-01-2010 09:25 PM BST
|
|
If so please respond to mailnmotion@aol.com Thanks
|
| KARAH
|
2309
|
 |
|
29-01-2010 05:43 PM BST
|
|
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
|
| Mark Percival
|
2310
|
 |
|
29-01-2010 11:32 PM BST
|
|
/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 >
|
| Dan
|
2311
|
 |
|
05-02-2010 07:53 PM BST
|
|
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
|
| Cornie
|
2312
|
 |
|
08-02-2010 01:06 PM BST
|
|
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
|