Dear Experts,
I have following issue.
I would like to fill values in two sheets by search for the corresponding value in one sheet.
e.g:
Sheet A
Report-- ID ---Provider -- Area
TAS 10 Tex TOC
TIT 22 Talla LOK
LOS 34 Libre LIL
Sheet B
ID ---Provider
10 Tex
22 Talla
34 Libre
Output:
Search with Provider Name and find Area and add for each row.
ID ---Provider -- Area
10 Tex TOC
22 Talla LOK
34 Libre LIL
Could you please help?
See attached file.
Thanks
In webreport tab
D18Formula:
Please Login or Register to view this content.
fill formula across then down.
in workbooks tab
D18
Formula:Please Login or Register to view this content.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Hi Both,
Thank you for replying.
The formula is not working.
Could you please help once more?
Thanks
Hi,
Thank you. My problem was solved.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks