Hi Sharron,
1 - The spreadsheet "Claims 2" is connected with sharepoint, you need to change the column order, placing the column "Claim" in the first.
2 - The data in the column "Claim" in the spreadsheet "Claim 1" have spaces at the end. You must use the TRIM function to correct the data for the VLOOKUP.
See the attached sheet and any questions contact me.
I hope I have helped,
Fabio
________________________________
De: Sharron Puryear <sheizageek@yahoo.com>
Para: Fabio Toniolo <fabiotoniolosp@yahoo.com.br>
Enviadas: Quarta-feira, 24 de Agosto de 2011 13:27
Assunto: Re: [ExcelVBA] Digest Number 2679
Thanks. I thought I was sending this to the site admins to put in the file folder.
Sharron
From: Fabio Toniolo <fabiotoniolosp@yahoo.com.br>
To: "sheizageek@yahoo.com" <sheizageek@yahoo.com>
Sent: Tuesday, August 23, 2011 6:44 PM
Subject: Re: [ExcelVBA] Digest Number 2679
Sharron,
All file attachements are disabled in this list.
Send the file directly to my e-mail address, so I can help you.
Best regards,
Fabio
fabiotoniolosp@yahoo.com.br
De: "ExcelVBA@yahoogroups.com" <ExcelVBA@yahoogroups.com>
Para: ExcelVBA@yahoogroups.com
Enviadas: Terça-feira, 23 de Agosto de 2011 13:18
Assunto: [ExcelVBA] Digest Number 2679
ExcelVBA
Messages In This Digest (4 Messages)
1a.
Re: Excel VLookup - doesn't work From: Sharron Puryear
1b.
Re: Excel VLookup - doesn't work From: David Grugeon
2a.
Combining cell results in different worksheets From: multiuseguy
2b.
Re: Combining cell results in different worksheets From: david braithwaite View All Topics | Create New Topic Messages
1a.
Re: Excel VLookup - doesn't work
Posted by: "Sharron Puryear" sheizageek@yahoo.com sheizageek
Mon Aug 22, 2011 10:27 am (PDT)
I have attached a copy of the workbook. I need to look in column C of Claims1 worksheet and see if that entry exists in column C of the Claims 2 worksheet, and, if so, which ID number corresponds with it.
Thanks
Sharron
From: J. Parrish <adari.j@gmail. com>
To: ExcelVBA@yahoogroup s.com
Sent: Friday, August 19, 2011 7:24 PM
Subject: Re: [ExcelVBA] Excel VLookup - doesn't work
Perhaps this would be easier if you could share the file. Is that an
option?
[Non-text portions of this message have been
removed]
[Non-text portions of this message have been removed]
Back to top Reply to sender | Reply to group | Reply via web post
Messages in this topic (14)
1b.
Re: Excel VLookup - doesn't work
Posted by: "David Grugeon" yahoo@grugeon.com.au davidgrugeon
Tue Aug 23, 2011 4:40 am (PDT)
Hi Sharron
You can't send attachments to this list. If you send it directly to me (yahoo at Grugeon dot com dot au) I will put it in the group Files area so others can download it.
.
Best Regards
David Grugeon
Excel VBA Group Moderator
-----Original Message-----
From: ExcelVBA@yahoogroup s.com [mailto:ExcelVBA@yahoogroup s.com] On Behalf Of Sharron Puryear
Sent: Tuesday, 23 August 2011 1:59 AM
To: ExcelVBA@yahoogroup s.com
Subject: Re: [ExcelVBA] Excel VLookup - doesn't work
I have attached a copy of the workbook. I need to look in column C of Claims1 worksheet and see if that entry exists in column C of the Claims 2 worksheet, and, if so, which ID number corresponds with it.
Thanks
Sharron
From: J. Parrish <adari.j@gmail. com>
To: ExcelVBA@yahoogroup s.com
Sent: Friday, August 19, 2011 7:24 PM
Subject: Re: [ExcelVBA] Excel VLookup - doesn't work
Perhaps this would be easier if you could share the file. Is that an option?
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
------------ --------- ---------
------
------------ --------- --------- ----
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetra x.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
------------ --------- --------- ----
Visit our ExcelVBA group home page for more info and support files:
http://groups. yahoo.com/ group/ExcelVBA
------------ --------- --------- ----
More free tutorials and resources available at:
http://www.mousetra x.com
------------ --------- --------- ----Yahoo! Groups Links
Back to top Reply to sender | Reply to group | Reply via web post
Messages in this topic (14)
2a.
Combining cell results in different worksheets
Posted by: "multiuseguy" multiuseguy@yahoo.com multiuseguy
Tue Aug 23, 2011 4:34 am (PDT)
Greetings,
I have 15 sheets named t 1 through t 15. Each sheet contains 400 cells. There is a two digit number in these cells or they contain one space so they are not null [I hope].
I wish to collect and combine the result from each cell into a master sheet. So collect the result of cell one, sheet t 1 and put it into master sheet A1. Collect the cell result of one sheet t 2 and put it into master sheet A1. By the end of the process I should have a combination of 15 numbers and spaces in 400 cells in the master sheet.
By looking at cell C17 [or however I lay it out] I should be able to match each number in that cell to whatever one cell is referenced in each sheet.
Do I need VBA to do this?
Looking at excel help files I notice some errors in what they explain so
it's been hit and miss trying to reference cells in different sheet pages and concatenate into one sheet.
Have a great evening,
Gene
Back to top Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2b.
Re: Combining cell results in different worksheets
Posted by: "david braithwaite" dbraithwaite@charter.net db9finance56
Tue Aug 23, 2011 5:59 am (PDT)
Hi
It looks like you want (e.g.) C7 on master to contain appended C7 values
from T 1, T 2,...,T 15.
Why VBA, why not just use CONCATONATE at Excel Level ?
Db
[Non-text portions of this message have been removed]
Back to top Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
* 4
New MembersVisit Your Group
New business?
Get new customers.
List your web site
in Yahoo! Search.
Cat Fanatics
on Yahoo! Groups
Find people who are
crazy about cats.
Yahoo! Finance
It's Now Personal
Guides, news,
advice & more.
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Create New Topic | Visit Your Group on the Web
Messages
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
MARKETPLACE
A bad score is 598. A good idea is checking yours, at freecreditscore.com.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar