allowed

I used to be able to hover over a VALUE, ROW or COLUMN and cursor would change to a small arrow. Once arrow popped up I could "right click" and all the elements that were the same would highlight as well. This allowed me to make formatting changes quick and easily. Was this functionality...

Good morning/afternnon/evening I am managing a team of 30+ agents, based on different schedules, some have 1 hour lunch, and another some have 30 min, the number of agents is changing ( 15-35 ). So I need to find a way to conditional format when a 30 min agent takes more than 30 min an color...

Hello, I need help with a code that will only allow certain text strings in the cell. So like data validation however not so restricted. For example restrict the cell to have these: Holiday Course Leave But! I would like users to be allowed to enter other information before or after. For...

Hello, Is there a way to prevent someone from deleting rows, columns, or cells in an Excel sheet? They are allowed to make any changes, but no deleting allowed. I tried to protect the sheet, but then no one is able to type in the cells. Thank you in advance.

Hello, I am trying to alter some code to download a reportas a csv instead of XML due to the size. The following code works as XML Reports/Operations/sales/MI/hier full&rs:format=xml I assumed I would just need to change the format=xml toformat=csv However I get an error stating “whitespace is...

I have a worksheet that is password protect, but I would like to have the user be able to group and ungroup section, but as I am sure you are aware, I am not allowed to group or ungroup unless it is unprotected. What are your recommendations. Thank You for your help

Hi gang, New here.....do I have to post a certain number of times before I'm allowed to attach something? If not, how do I attach file to a post? Thanks, PC

=IF(E7="Bostan,MA",IF(M7<100,"8.84","5.84")*M7-P7,IF(E7="Delhi",IF(M7<45,"6.55",IF(M7<500,"1.50","0.30")*M7-P7),IF(E7="Budapest",IF(M7<100,"4.90","3.18")*M7-P7,IF(E7="Budapest",IF(M7<100,"4.90","3.18")*M7-P7,IF(E7="Oradea",IF(M7<100,"5.29",IF(M7<250,"4.56",IF(M7<1000,"4.31","0.30")*M7-P7,IF(E7="G...

Are we allowed to hire someone for a small project? The details are too much to post for help in smaller segments, so I'd rather explain them one-on-one and work on the project together. If this is allowed here, please reach out to me ASAP, I need this done by Tuesday. Penny

I think it's not, because I tried to write a code, but I received an "Object doesn't support this property" or similar error. Any idea? Thank you! Example: In 1 cell: (It's not allowed in this forum to use background colour, so imagine, that the word colour = background colour The dog is...

Hi folks, A bit of a silly one this. Excel 2003 allowed you to create a chart from data in your spreadsheet. It then allowed you to manipulate the data points in the chart itself without resorting back to the excel sheet. When you edited data in the chart - ut changed the data in your sheet...

Hi: Excel 2010BCDEFG2101203Cash#N/A101Assets3101205Cash Equiv#N/A102..Liab4102207Intangible#N/A103Revenue5102125Accounts payable#N/A104Exp6103129Billing#N/A105Equity7103131Billing2#N/A8104135Salary#N/A9104137Rent#N/A10105614Equity#N/ASheet1Cell...

I am needing a formula to calculate attendance depending on the employee's time of service. If an employee has worked for the company less than two years, attendance is calculated in a way the employee is allowed to miss less days (only allowed 3) before receiving a point and if they have been...

Hi What-If-->Goal seek (not scenario), set the value of a cell by changing other cells (not only one)? I tried but it seem not working only one value is changing. I think it is not allowed only using Scenario to change 2 or more cells, Am I right? Thanks alot

As I am not allowed to contact a moderator, this is the only way I can bring this to your attention, thanks.

Hi, I have this code that prompts a message if a user tries to add a new sheet in a workbook. I have three sheets that is allowed to be in the workbook called "Information", "Prices", "Copied Prices" in that order. If a user is working in sheet "Prices" and decides to try and add a new sheet...