Search results

I am opening a new thread related to this topic https://chandoo.org/forum/threads/set-break-after-certain-time.46753/ This is a situation where I want to subtract hours every 10 minutes but without an helper column? Is that possible? Attached file.

I work on one task with multiple conditions and I solved it around 90%. (I use the Excel 2013) There is one problem left. I can not find a way to subtract time while I copy the formula down and set a break after a certain time. I use this formula below, into 'B' column and everything is fine...

Hi Can anyone help me (i.e. explain) why the formulas below do not work in my Excel 2013? I use Non-US settings on my Windows OS and also in Excel (Eastern Europe). I know that the separator in Excel formulas is different from US settings and Non-US settings. I'm wondering why the formula I...

I want to count the cells that meet the following conditions. 1st. How many dates are different from the list in the second range 2nd. How many empty cells are for dates from the first condition Is it possible to solve the problem with one formula only?

ARIAL font is set in sheet1. Formulas are set in cells D1:D5. When I enter the data in the new row of the table, Excel automatically change the font in cells D1:D5 Get him back to Calibri? Is it a BUG in Excel 2013?

Is it possible to protect (lock) specific range cells that contain color highlighted by Conditional Formatting. These cells are variable. It works from the dates in the calendar month. When the year changes, the marked dates (weekends) also change automatically. I want all cells belonging to...

I have a variable number of XLSX workbooks (product1, product2 ..... productX) from which I import data into Master.xlsm I want to import from a closed workbook a certain range of cells 'B1: M19', which is in the same workbook in each workbook. But I want to paste one below the other My idea...

It is common knowledge that with SaveAs in the window you have the option to enter the author before saving the Workbook. Just type in one letter and Excel will list all the authors that begin with the letter (for all the files you once ran). How to remove all these author names in Excel? Is...

I'm trying to create a dynamic range graph by a specific column. How to find a way for a chart to display three columns of data but to control how many cells are filled in column 'D'. I manage to display all the data, but I cannot control the column. Am I wrong in the OFFSET function somewhere...

When I use the absolute path everything is ok. All workbooks are in the same folder. But when I want to use the relative path of an active workbook then there is a problem. It currently opens a window and requires you to select a specific workbook. But I want VBA to do it in the background and...

Yesterday we had a discussion in the company about 'Unique vs Unique Distinct' data. Opinions are different. (I also found conflicting opinions and results on the internet). I would like to hear the opinion of longtime Excel users. How to exactly define the difference between 'Unique' and...

I want to Unprotect/Protect a specific worksheet in multiple closed (*.xls*) workbooks in the same folder. I found a lot of VBA macros but didn't find what I wanted. 1. The VBA should allow the user to select a folder (which is variable) that contains over 100 workbooks. 2. Open the first...

I have a problem saving the XLSM workbook to the XLSX workbook in the same folder. It currently works by saving the workbook to a single folder above (parrent folder). I want VBA to save the workbook in the same subfolder where the active workbook is located. (Note! The active workbook is not...

I have about a hundred XLSX files in a folder. I'm using the VBA code below. VBA correctly inserts a Date into all workbooks but does not display the correct format. It is as if the Enter key function is missing. All workbooks already have formatted cells by Date "dddd - dd.mm.yyyy". Attached...

I have found several VBA macros that resize multiple images. But it's not what I'm looking for. It is necessary to select all images on Worksheet and to reduce with scale their size but under certain conditions. The criterion is following. 1) If the image width is greater than 7.89 cm, it is...

On the worksheet I have several hundred pictures. I want to select all the images at once and add white background color to multiple images (solid fill -> white color) at once using VBA. Is there any usable VBA? Please see attached example.

I'm trying to use the checkbox to select the multiple columns I want to hide but unsuccessful. Can someone help. I add an example.