Hello and thanks in advance if this is even possible.
I have two Excel worksheets within the same workbook.
One, "Database" and two "Floor Plan".
I am looking to have the Floor Plan populate itself based on the Database sheet.
test1.xlsx
I attached a sample workbook to illustrate what I am going for. I am not sure exactly how to go about doing this.
Thanks for your time.
James
Last edited by JimmyHuss; 05-25-2012 at 09:51 PM. Reason: Making an appropriately long title
I'm concerned that Joe Black and Joe Brown are sharing the same room..........................
Why would you delete my comment?
stop being so over zealous. There is no need for it.
"hidden till OP changes title" <<<< lol.
Why dont you change the title for him? Rather than making him look stupid. You can read... you know what his question is........
nazi fundamentals.
Robotacha,
Your post does not comply with Rule 6 of our Forum RULES. Common courtesy is the order of the day. Avoid coarse language, provide feedback to suggested solutions, and take the time to thank those who took their time to help you.
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]
Hi James, and sorry about your introduction to the forum.
The point of the title change isn't to make the title long, it's just that without some policing we'd end up with all of the posts on here sharing about 6 titles ... which would get too confusing for us regulars here (we're not a terribly bright bunch)
On with your problem - the format of your two sheets doesn't make it easy to get data from one to the other, but I think the following little formula should work OK:
=IF((ROW()-MAX(INDEX(ROW(A$1:A1)*(A$1:A1<>""),0))+1)>COUNTIF(Database!$E:$E,INDEX(A:A,MAX(INDEX(ROW(A$1:A1)*(A$1:A1<>""),0)))),"",INDEX(Database!$B:$B,LARGE(INDEX(ROW(Database!$A$1:$A$1000)*(Database!$E$1:$E$1000=INDEX(A:A,MAX(INDEX(ROW(A$1:A1)*(A$1:A1<>""),0)))),0),COUNTIF(Database!$E:$E,INDEX(A:A,MAX(INDEX(ROW(A$1:A1)*(A$1:A1<>""),0))))-(ROW()-MAX(INDEX(ROW(A$1:A1)*(A$1:A1<>""),0))))) & " " & INDEX(Database!$A:$A,LARGE(INDEX(ROW(Database!$A$1:$A$1000)*(Database!$E$1:$E$1000=INDEX(A:A,MAX(INDEX(ROW(A$1:A1)*(A$1:A1<>""),0)))),0),COUNTIF(Database!$E:$E,INDEX(A:A,MAX(INDEX(ROW(A$1:A1)*(A$1:A1<>""),0))))-(ROW()-MAX(INDEX(ROW(A$1:A1)*(A$1:A1<>""),0))))))
I've added it to your sample sheet (attached).
Hope this is helpful.
lol Andrew, thats scarey to even just look at)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
The following assumes that you will have no more than 2 names per room (as implied by your sample):
In B1:
In B2:
Please Login or Register to view this content.
Copy B1:B2 and paste in each cell to right of a room # (ie B3, B5, B7, E1, E3, E5, E7)Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks