Search results

Hello, I apologize but I was unable to find where this exact question/issue was already asked in the forums.... I would like to create a to-do list where once the task is completed, a check box is ticked and the row is moved to a sheet titled 'Action items completed'. I know how to create the...

After I've gone through and entered a value or made a selection from the dropdowns, if I later change the value in a cell, how can I have every other cell that correlates to that cell update to the new value?

Thank you for looking at this. I have tried to left justify the first line repeatedly but it keeps reverting back to having the space(s) in front of it. Again no issues with the Proposal worksheet. What's the difference between the two that's causing the Invoice worksheet to have this issue? I...

Sorry, Decio - what did you change? it still looks the same. Thanks for replying

revised workbook with font changed to arial regular. no italics, no bold

Correct. The space (or spaces) keep returning and if I change the font size of the space(s), they return to the larger size as well. Changing the font from italic to regular does not fix it nor does changing the font to something plain like arial. It's only the Invoice worksheet - I don't have...

fluff, I added the spaces in front of the second line just as a work-around to get the two lines to even up with each other but I'd really like to get the 1st line to left justify so it doesn't run so far over to the right

The fact that the two lines are of different font wouldn't affect how they justify to the left would it? Also, the document keeps adding spaces to the front of the top line no matter how many times I remove them. And the link of formatting codes that vietm sent me doesn't seem to work (unless...

Let me try that Fluff

would it not be possible for you to go to Page Layout>Margins>Custom Margins>Header/Footer>Customer Header?

It's in the header. what is the cell reference for a header?

I'm sorry, I should have been more descriptive.... If you look at the print preview of the Proposal tab, you'll see the header "1Solution' left justified to match the tag line underneath it. If you look at the Invoice tab you'll see how "1Solution" does not line up. I've uploaded a revised copy...

despite everything i try, I cannot get the top line of my header to left justify to match the 2nd line. Any suggestions? Thank you

attached is the sample file. All highlighted cells are where I want the highlight to go away when data is entered. Note: Many of these cells will reference back to another worksheet in the workbook. I can remove that if needed but would prefer to have it in there. Also, would it be possible to...

In a template I want to highlight selected cells yellow "to prompt" users to enter data into the cell at which point the highlight would then be removed. Would this fall under conditional formatting? Everything I'm finding highlights the cell if data is present - I want to do the opposite. And...

Wanting to create a working calendar where I can show the job name, address, and work to be performed plus have two dropdowns for the technicians that will be performing the work and one showing which vehicle(s) that will be used. an example is attached. I've created the macro (copied off...

Hi, novice user here.... Is there a way to make the dropdown box in AD41 large enough to view all of the content ONLY when selecting the dropdown? The box would then return to normal size when another cell is selected. I found the code below online but don't understand how it works - when I...

In cells AD385 and ab448 of the attached worksheet, you cannot read all of the data in the drop down box. is there a way to make it larger when clicked and then it goes back to it's normal size? you'll see I tried to write some code to do that but it keeps the cell at the enlarged size instead...

If the user selects "Y" in B20, then B22:B30 are auto-populated from B3:B15. If the user selects "N" in B20, the cells in B20:B30 are left blank so the user can manually input data. If I write the formula in the cells it is typed over. I tried to write it above the cell A21 but my formula...

Is there a way to do so? I would want the user to get an alert that "cell AA123 cannot be left blank".

Actually, I was able to figure it out. I established the names for the ranges and everything worked. Thanks so much for the help!

Narayan, thank you for the awesomely quick response and while I'm sure it works perfectly, I cannot get it to do so and I'm equally as sure it's because I don't know what I'm doing.... Could you possibly please explain to me the steps of the formula? I have never been exposed to ISNA, match or...

If the user selects a value in D27 from the dropdown in the attached worksheet, I want the correlating value from column I to populate in I27. Rows 1-26 are hidden in the finished worksheet. As you can see, I've started writing a formula with an IF statement as that's the extent of my...

Sorry Narayan, I'm clueless on most of what you wrote...any chance you could explain it to me maybe line by line until I get it? I've never used DIM or pretty much anything in this code but don't think it'll take long to understand it. I've create the matrix - do I need a name for it? Thank you

yes. thank you