ensure

Hi Setting up a document where I need to put in the total budget that each client had. Many will be, say, in the ilk of £120,000 whilst others might be £38.4m - is there a way to ensure that when the numbers are entered: £120,500 would be displayed as £120.5k £38,400,000 would display as...

2.1Carry out a cross-cast check(on the funding worksheet – Total Funding) that uses secondary columns to perform the same calculation but in a different way to ensure your spreadsheet shows it is accurate. How can I perform a cross check in my total funding that uses secondary columns to...

Hi, I appreciate there is probably a simple answer to this but i am stuck. We have a 4 column spreadsheet which has over 20K records in it. Column A & B are text fields and C & D are numeric fields. What we need to do is to ensure the combination in the text fields is reversed and also in the...

Hello, I have been working with a sheet for sometime now, and I've been able to configure a data sheet that has lots of macros. I've been using a seperate sheet within the data sheet to activate macros, but it occurred to me to make my own ribbon instead. Is there a way to ensure that the...

Insert a monthly column for a bonus scheme where if a salesperson equals or exceeds 12% commission for the month then they receive an additional $1,250, (This can be achieved by combining the IF and a VLOOKUP statement.) The % of commission and the amount of bonus on offer will vary every...

Hello, I was wondering if it was possible to create a checklist next to a PowerPoint slide; not a checklist slide. For instance, a slide will have a header, some text and a picture. I was curious to know if I can have a pop-up form or something in the slide with a checklist for us to ensure...

Hi, I have a modeless UserForm and want to copy/paste from cells on the sheet to a textbox on the userform. How do I find activecell to ensure I'm copying from a valid range? Thanks for any help David

Hello, I need some suggestions. I have a Form that will add records to a table. These are the fields that will need to be filled using the form: Entered By Date Entered Cycle Month Report Type Date Reviewed Reviewer Type Reviewer Reviewer Report Area Main Section Topic Section...

I am using this VBA to concatenate the contents of cells I2 and D2 into cell J2, one has a special character so I am using this code to ensure that the formatting remains. It works perfectly fine, but I have 836 rows of data in my workbook, so I need to ensure that the code continues until row...

Hi, I have a column of cells with the following text format, "12/17/2015 12:00:00 AM". How can I convert this to a date with only the month and year and to ensure that Excel reads it as a date? thanks

I have data in 6 columns in one worksheet Name, Key, Status, Locations, Type, Datasource and then another worksheet with the same columns, but there are other columns in between. How can i run a vlookup to ensure data agrees in all columns? Can someone please help.

Hi, I am using the following formula, would it be possible to ensure the result never exceeds 100%? =INT(R15-R13)/(R14-R13) Thanks

Hi Guys, Definitely a stupid question, but.... I want to highlight every instance of the text string "eligible" when I return a lookup value in a table. Unfortunately, it also appears to highlight other string returns such as "Non eligible". How can I ensure that it just highlights just...