Hi all,
I am setting up a schedule and kinda hit a bump.
1. In sheet 1 I have the actual schedule. If someone is working "AM", he'll look for his name and make the change in the appropriate date column.
2. In sheet 2 I want the data to be organized by date and if the co-worker is working either "AM" or "PM". I am not sure what formula to use to get the name from sheet 1.
Any help would be much appreciated. Test.xls
Thanks,
Amar.
Is the result your need？Do you need the attachment？
Please Login or Register to view this content.
Hi
I think you will need to change your inner loop to test for Upper case. I would also suggest splitting the names with a space to make the result more readable.
The OP also needs to add column E to Sheet2 with a heading of MID to correspond with data on Sheet1Please Login or Register to view this content.
--
Regards
Roger Govier
Microsoft Excel MVP
You are right,,I don't know how to use “UCase”，I just Modify the content “AM” ->“am”
You are right,
thank you Roger Govier
The modified
Please Login or Register to view this content.
Hey guys,
After lots of trial and error, I finally figured out the formula. I didn't use vlookup. Here it is:
For those who need it, here's an explanation of what it does.Please Login or Register to view this content.
1. Cells B4:B20 in sheet1, contains the names of my co-workers
2. Cell A6 in sheet 2 contains "AM".
3. Cells C4:C20 in sheet 1, is the row that the formula needs to "look in" and it has a date in cell C4.
If someone is working "AM" on 12/06/2013, the formula will find the corresponding name in cell B4:20 and drop it in sheet 2.
Thanks for your response.
Regards,
Amar.
Hi
And how, exactly, is that supposed to refer to what you originally posted??
There is no similarity between this formula and the information you posted on Sheet Test.xls
Hi,
I mentioned that I had to use a combination of formulas and do a lot of research.
I'm not sure how it is different from what I posted/requested. I've attached a sample spreadsheet.
Regards.
Hi
Well for a start,
1. your original file had nothing whatsoever in column A of either sheet.
2. The file you have just posted, has column A on both sheets hidden - why do you expect those trying to help you to have to look at your sheet and decide they need to unhide columns.
3. Your formula does not produce any result whatsoever.
3. Your second Workbook posted, contains no data whatsoever.
4. If one copies in your data from your original posting, then the result of your formula is Name 3 in every cell from C3 tp C9, and nothing elsewhere
If you do want help
a). Post a sensible question with a full explanation of what you have and what you expect the result to be.
b). Don't then change your definitions, and, use hidden columns
c). acknowledge the help given by those who have taken considerable time to write code for you - e.g Someone from China - and expalin why their solution doesn't match what you are looking for (if it doesn't)
d). don't just post back saying I have solved the problem with a simple formula, when you clearly haven't.
I for one, will definitely avoid any request from you in the future.
Just chill man. I did thank them for their input. I don't know why you're making such a fuss?!
I forgot to unhide it. it happens. Human error!
No data in my second workbook and didn't solve the problem? What are you talking about?
I was only looking for help and as I was waiting for an answer, I was also trying to solve my problem... which I did.
I don't want you to think that I'm a "cocky" user, but if you don't want to help me, then so be it.
Have a great day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks