Hi all. Let me see if I can explain my question briefly.
http://i.imgur.com/wniHBvq.png
So, I want to input just the category of a race (that 1.WT in the left top) and then a table like that would appear. How can I do it? The cells of the table would be empty until I inserted the category, and table sizes (in lines, not columns) would vary depending on the category I would input. Is there any way to do this? Thanks in advance.
Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for youAlso, not all members can upload picture files (Company firewalls and stuff)
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
Alright then. This is a really simple sheet because it's just a test. In the first post I've already clarified what I want, hope you understand: of course I'd have to have different tables to different categories, what doesn't happen in the sheet.
Teste LV.xlsx
edit: Just to clarify: I'd input the race category and then a table like that would appear. After that, I insert the name of the cyclist and that's all I have to do because the formulas are already there. The only thing I wanted to know is how I can insert the category and then make the table appear.
Last edited by Helders; 12-13-2013 at 08:14 PM.
Sorry, unless Im missing something, I dont see how 1.WT relates to anything in your table?So, I want to input just the category of a race (that 1.WT in the left top
Well, this is part of a game based in real cycling, and diferent race categories will result in diferent points, based on the race fame, etc. So, different categories will get different tables.
Giving it a bump
Doesnt answer the question though. How does that relate to the data provided?
I suppose you're asking how inputing different categories will change the data. For diferent categories (in cycling there are 1.WT, 1.HC, 1.1, and many more), we'll count up to different positions, ranging from 5 (the number in the example) to 30. Also , the punctuations would change.
This is a game like many fantasy games that are on the Internet, but each rider only has a team assigned to him.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks