changing

Hi, When preparing Pivot Table with date I can switch view from "sie 18" to "22-Aug" by changing location (Excel 2016: Number Format > Date > Locale). But when I group dates by months the view is changing again to my current system region format. Is it possible to change date in Pivot Table...

Hello I am using MS-Excel 2010. I have a worksheet where rows are visible/hidden based on user selection. I would like to add a "print" button that can be based on this changing size. How do I do that? Thank.

Hi guys, Is there a way to protect an excel spreadsheet, so that users can input data in specific columns, but are restricted from changing the formatting of the cells such as size, borders. Also how do I protect the formulas from being deleted? Thanks

I've recently made some improvements to a reporting spreadsheet at the company I'm currently working at, nothing spectacular, just automating tasks etc. I am now seeing the occasional row height changing to zero, too many times to be a coincidence, and I'm fairly sure not user created. None of...

I am using CutePDF converter but the object in my worksheet comes out blurry. I have tried changing the print quality resolution but it is still really blurry. Any suggestions?

I need help in creating the formula that will count how many from my List 1 are in List 2. Something like this. =countif(List2,List1) List 2 is in Sheet3 Column A, this is a fixed list meaning it is not changing. List 1 in in Sheet1 column J, it is active, it is changing from time to...

Hello, i have written the following code, which works fine for one row, i am trying to change it to go to the last row, with the criteria changing from A2 to a3. a4 etc, Range("f2") = WorksheetFunction.CountIfs(ThisWorkbook.Sheets("Adviser data").Range("A:A")...

Hello, I have a textbox (textbox1) that updates a value in another textbox (textbox2). I would like to make textbox2 update only when I'm completely done changing the value of textbox1. Can someone help me delay the change of textbox2, please?

Hello, I have column AA & AC where some values shall be changed. How to make automatic macro after values changing in some cell AA and AC or vice verse? I have macro automatically run when values is a change in one cell. I need macro where running will start after the value changing in the...

Hi Guys I have several workbooks that have multiple worksheets from 80 to 3000 tabs trying to workout an easy way of searching for the word 'unassigned' on each sheet and changing the tab colour, if found. Is that possible?

Hi All, I'm looking for a method that will 1) visually show, by changing the shape's color, whether a macro called from a button has run and 2) post what time the macro was run. Is this even possible?

Hello, I found a snippet of code that will loop through a folder and do a specific function (i.e. insert a formula). I am looking for one of the functions to be changing the extension from CSV to xlsx without creating a new workbook. Can any one share the line of code that will perform this...

how to change font size in conditional formating

Hello everybody. I'm navigating a web site. I'm stuck with this (I've to close a tab): a id="zdres" class="closetab" on click="return false;"></a> The id always changes. It seems to be the only a and the only class="closetab" in the page. Any suggestions?

I'm using =INDEX(Jan!$2:$2,(ROW(E2)-1)*5+36) to pull the date from Column 41, Row 2. When I add a new column it still pulls from the 41st although the data I want moved to the 42nd... I am making/formatting a sheet and the number of columns keeps changing. Getting to be a pain updating the 36...

Hi all, i need to attach a file in a outlook from my local path wherein the path keeps changing in a daily basis however it would be better for me if i do a changes in a cell reference instead of directly in the macro. below is the syntax which i directly keep changing the path in the macro...

Hi, I'm trying to change the reference in a sheet from one sheet to another, in other words, changing Pricing!I4 in a formula to the sheet PricingV_1!I4 with the bold part being the sheet reference I would like to change. Is this possible, if so, how do I do this? Thanks in advance!

I know how to clear data validation in a range of cells or change the list reference But I have over 600 cells that need changing so even copying is a bit arduous What I would like to do is replace my list =listname with a different =differentlistname so I don't have to go into 20...

I have a text in an Excel worksheet that contains "1a" and "3b" and i want to change the letters to uppercase with out changing the rest of the text case Cheers Clive

Hi, I'm after some help/guidance on a problem I have... I have a report I produce on a daily basis, every day I extract the data from a report produced and copy it into a data sheet in excel. The number of rows can vary each day so I then have to refresh 6 pivot tables running from this data...