Reputation
9,596
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 11 24
Newest
 Yearling
Impact
~1.1m people reached

2d
comment Search tool using keywords on Excel data or a keyword based corresponding code and description search : The file needs permission
That's a tall ask. It looks like keywords appear in multiple rows. What would you expect if somebody enters "Import & Export", which is in row 9 and also in row 14 of the visible data, and probably exists many more times? What about "Information Technology" versus "Information Technology & Sciences" - When someone types "information technology" - what would you expect?
2d
revised Search tool using keywords on Excel data or a keyword based corresponding code and description search : The file needs permission
deleted 6 characters in body
2d
answered dble clicking the drag down only auto fills 100 or so rows
2d
revised Moving or Deleting Original Image Powerpoint
added 631 characters in body
2d
answered Moving or Deleting Original Image Powerpoint
2d
comment Merge data from three columns
@JohnKenny Please finish the paperwork and mark the answer, then. That's how to say Thank you here. Read What should I do when someone answers my question
2d
answered How can I specify a range in a formula?
2d
answered Single pie chart input from two excel sheets
2d
comment Excel, turning a zero to a different number automatically.
It's difficult to write instructions for somebody who is not willing to follow instructions. You've been pointed to resources about site etiquette by several people. Ignoring that is rude.
Apr
27
comment Creating auto-shapes in excel based on cell values
That image is not a Gantt chart, it's a month view of a calendar. How would that calendar look with a few items of project task dates and milestones? Can you mock that up? TBH, your approach sounds totally wrong, especially if you first need to learn VBA.
Apr
27
comment Excel, turning a zero to a different number automatically.
What part of "Edit your question" is difficult to understand?
Apr
27
answered Excel, turning a zero to a different number automatically.
Apr
26
answered create stacked graph with subcategories
Apr
26
answered Excel Dynamic Chart- Range Name based on IF formula not accepted as 'Series Name'
Apr
25
answered How to run Sub with parameter in Excel VBA?
Apr
25
comment How to run Sub with parameter in Excel VBA?
You changed your code after my comment. Let us know when you're done editing your code sample, so we all know what we're looking at.
Apr
25
comment How to run Sub with parameter in Excel VBA?
You never use the SourceRange parameter that you pass to the sub in the first code. Do you understand how passing parameters work?
Apr
22
comment Consolidating 2 excel files - function consolidate
Read the last sentence below the screenshot. Paste as values, then you won't lose anything.
Apr
21
answered Power View Not Working Excel 2016
Apr
21
comment How can can I combine two IF statement in Excel?
Describe in plain words what the input, processing logic and output is. Edit your question to do that. Don't post that in a comment. Describe the data types of each input, i.e. text, number, date. Posting a screenshot would actually help see what you see.