• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

I want macro to put symbol in Table

Abhijeet

Active Member
Hi
I have data in excel file Their is Table A6:C17 in that table some numbers that are fix for that position. In column E missing numbers data which numbers are in that column I want that number symbol in Table that is A6:C17 in appropriate number position. Please give me macro
 

Attachments

  • test pyara.xlsx
    18.9 KB · Views: 10
Abhijeet

This might get you started but you are going to need some vb and some smarts to set the visible property to all the Stars which are not in your list.

Change the numbers in Blue in Col E to be anything from 1 - 9. The Stars will change accordingly.

Don't go re explaining your problem. As I said this is a start for you Abhijeet. You will need to put all of the stars on the grid (which I have not done) and set the visible property of those excluded to not visible. It is a bit of a project in VBA and I have contributed a small part to that project and hopefully given you some food for thought.

Take care

Smallman
 

Attachments

  • 1test pyara (1).xlsx
    30.6 KB · Views: 6
Hi Can anyone tell me about this it is urgent
Hi, Abhijeet!

Are you very hurried? If so please take a break and dedicate 5 minutes to what follows. Posting without adding any useful information just for bumping up a topic doesn't guarantee neither a faster assistance nor getting the interest of people who might be reading that post, but rather the opposite effect of discouraging them.

If you'd have read the 1st forum at the main page...
http://chandoo.org/forum/forums/new-users-please-start-here.14/
...you should have noticed this points (and if you did it seems as if you should do it again):

"Consider that the world is operating 24hrs a day. A late post today may well be answered by someone else overnight."

"If you and a reader have been involved in an ongoing conversation and the conversation suddenly stops, recognize that the person may have gone to bed, even though you have just arrived at work. In the worst case a reader may go on holidays and not get back to the question for a few days."

"Never title your posts as "Urgent", "Priority" "Immediate". It may be Important to you, but not for rest of the members here. These words will be moderated out."

"Say "Thanks", whenever you can. Recognize when someone has bothered to go to the trouble and time to assist you with your question for free. Often readers will spend several hours working on a solution to a problem, a line of recognition will go a long way."

Regards!

PS: If it's a high priority issue and you can't even wait... how much?... oh, 9 hours and a while... absolutely unbearable... but you always have the alternative of hiring a local consultant who may provide you the exact tailored service. Should I remember you that these forums are supported by contributors who dedicate part of their time in an absolutely free way to help other people and answer questions?

PS: Warned for 3rd time... don't abuse or will be banned, did I make myself clear?
 
Smallman Thanks but I want change in Table i.e A6:C17 in that table number position is fixed only I want if in missing number column i.e Column E what ever numbers then as per number star will reflect in table
 
Abhijeet

I asked you not to re explain your problem. I understand completely what you are trying to do. I set you up to start your project because that is what this is, a project. Now that you have a start and it is up to you to take the advice in my post and start to build your project. A push in the right direction is often better than a project presented completely finished. You will learn more.

Take care

Smallman
 
I agree but I have facing problem In Table how to reflect star symbol when in missing number column any number then other wise only that number in That table with their position.please tell me
 
Hi Abhijeet ,

Can you give a clearer and more detailed explanation of what you want done ?

Your column E cells E3 , E5 and E7 have the numbers 2 , 4 and 6. Which symbols should appear in which cells of the table ?

Narayan
 
Narayan

He just wants the symbols to appear instead of the numbers. So in the example where there are three numbers which are 'Missing' he wants those symbols to appear in the table instead of the numbers which are currently there. Also the numbers which are meant are not in the missing list I assume they are meant to be blank (I assume). This was my take on the problem. It is a reasonable size project and I have friends and family over at this time of year and don't have the time for anything but smaller projects at this stage. What I have provided gives a reasonable start to the project.

You have a bigger heart than myself so can probably give more at this stage :)

Take it easy

Smallman
 
Hi Marcus ,

Wish you a belated Merry Christmas , and a Happy New Year.

I am confused because the numbers 2 , 4 and 6 are present in the table ; does Abhijeet mean that what ever numbers are entered in column E , the same numbers in the table should be replaced by their corresponding symbols ?

Narayan
 
Hi Narayan

Belated Merry Christmas to you too. I hope you enjoy the holiday season.

Not sure, it is a bit of a mystery to be honest. I am starting to doubt my original assumptions. I guess we will have to wait to see when he gets back to us.

Take care mate

Smallman
 
Hi
Belated Merry Christmas

I want missing numbers what ever numbers I want to that number Symbol I want in Table replace with that number.
 
Hi Narayan
Yes it is good but problem is 2nd time if I run this macro with change in Missing numbers then that previous number Symbol not remove from Table
 
Hi Narayan

Its working fine but I can not add Button to run this macro after running macro that button will remove
Please do it for me in My Original File. Please add button to run this Macro In this file
 

Attachments

  • Pyra calculator New.xlsx
    13.3 KB · Views: 4
Hi Narayan
Thanks for giving me this macro but still I m facing Button problem after running the macro Button will be disable
 
Hi Abhijeet ,

I downloaded the file I had uploaded , ran it 4 times , and I have not faced any problem.

Can you upload the file ? I will download the file you upload , and run the macro in it , and see if I face the same problem.

Narayan
 
I run the macro when I run in 2nd time then the button will be disable I upload same that file now
 

Attachments

  • Pyra calculator New.xlsm
    40 KB · Views: 4
Hi Abhijeet ,

I downloaded your file , and ran the macro more than 20 times , saving it every now and then ; I did not face any problem.

Narayan
 

Attachments

  • Pyra calculator New.xlsm
    43.5 KB · Views: 4
Back
Top