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

1d
comment Lock Drop Down Cells and Enable Use - Excel 2013
That will require VBA. Are you comfortable with that?
1d
comment Keep command button visible while scrolling down worksheet?
Could the downvoter please elaborate?
2d
comment How to create a macro that pulls data into one summary sheet from multiple sheets?
Sorry, this site is not a free code writing service.
May
2
comment Quickest Way to Extract Data from Doc or Pdf to Spreadsheet
This is not a question, it's a software project.
May
2
comment Automatically Delete Incorrectly Spelled Words from Excel Spreadsheet
You are not gaining friends with your behaviour!!! I answered your other question. React to that instead of posting a new one.
May
2
comment Automatically removing invalid or gramatically incorrect entries in Excel
Please find the Caps Lock key on your keyboard and turn Caps Lock off. Typing in all caps is considered SHOUTING and NOT POLITE.
Apr
29
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?
Apr
28
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
Apr
28
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
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
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.
Apr
21
comment Consolidating 2 excel files - function consolidate
What tutorial? What consolidation function?
Apr
20
comment How to Change Conditional Formatting of a Cell Based on a Change in the Cell Value
A formula cannot post into another cell. You'd need to use VBA to copy cells or the whole sheet. That can easily be done when the file is opened. If you need help with that, ask another question.
Apr
19
comment Looping through two column to check for condition
worked fine for me. Check your data.
Apr
19
comment Excel doesn't sort columns to the right of a blank column
@MathieuK. I assume with "filter" you mean "click the Autofilter command in the ribbon"? Just be careful: when the data does not have a header row, that will transform the first row of data into headers, which may not be desired. Inserting a table will prompt if the data has headers and add them without data loss.
Apr
18
comment Excel: Check if cell string value exists in column, and get all cell references to that string
@Dave - care to elaborate? Vlookup is not a fit AT ALL here.