current

Question 1: Using the date field below, I would like to create a new field that subtracts today (current month/year) from this field's format below. There are some fields that do not have a date value ('-' or blank) - in those cases output a '-'. Current Formula...

Hello, I would like to match and find a criteria in column A from C1 cell, and then calculate how many cells has values below with including the found one. By looking at the table below it should return count of 4. Much appreciate your help. <colgroup><col><col span="4"></colgroup><tbody> A...

I need assistance in writing a formula to complete a monthly analysis report. Let me try to explain what I want to do. I have a workbook where I analyse variance monthly and YTD. Each month I would manually update the Current month column in my formula. But I need a formula for that will pull...

Hi Expert, Im learning excel while I work on parsing large amount data. Need your help me to create a new table from old table as listed below. Your help is highly appreciated. Thank you once again in advance for your great help, Sincerely Zi <tbody> Source Table Order_Aging...

Hello, I unfortunately/fortunately learned the hard way yesterday that using the calculate function in calculated columns doesn't always work out so well and have since spent entirely too much time spinning my wheels trying to figure out an alternative solution to my report requirement. Hoping...

Hi, I am in the process of automating a monthly report using VBA (Power Point Presentation). I can not seem to add a sub heading to my current code. Thus far, I am able to add create the power point presentation (not shown entirely) and I have a heading (Shown Below). But I can not add a sub...

Hi Is it possible to create a formula which reads subsequent Sheet names? So if I had data in Sheet 1, for example, I'd like cell A1 to read the name of Sheet 2 (which would be called 'Chocolate') cell A2 to read the name of Sheet 3 (which would be called 'Crisps') I know you can use...

Hello, I have a set of data which I am trying time series. Can anyone help me with the vba code? The current macro creates the first event with the last business date but I want it to replicate the lines below but only update the dates current date. If last business day is Friday and I am...

Every year, in June, I create a new workbook from the current workbook. I have a macro the does all that and I put a button on the current workbook to run it, but I want to hide it until Jun, so no one will hit it mistake. Can that be done?

Is it possible to use the same macro keybind in different workbooks but have only the code tied to the current workbook run?

I have Office 365, using Excel 2016. Page Layout is greyed-out. I rebooted, opened Excel, clicked on the Page Layout icon, and got a message saying "current printer not available". Does anyone have a solution?

Hi, please help me figure out how to code copying all of current rows of filtered data and paste into another sheet in VBA Thank you

Hi I have in N79:N100 the last day of each month>>N79= June 30, 2019...N80=July31, 2019...N81=Aug 31, 2019...etc I can't figure out how to write a conditional format to highlight the current month Example: This being July, I want to Highlight N80 after July 31, I want to that cell to go back...

Is it possible to have a formula IF current sheet is named X?

Hi I have a column A that has week ie 2019.26 represent 26 week of the calendar day. Column B Date Column D Reason Code WH BD HOS... Assuming my week is Mon to Sat (no data on Sunday) I would like to have a formula that would go to B2 that knows what today is and tells me how many "WH" are...

Hi there Have a table in Excel it does not when I add data underneaththis and press control t it will not add it to the table and the setting areticked for it to automatically update the data add but it will not do this. Any ideas how to get my new data added to my current table? Thanks...

Hi all... is there a formula that would return TRUE if the date in a cell is in Current year? For example, in A1, i type in the date... I would like B1 to say "TRUE" or "Current Year" Thanks in advance!

Hello, I have a new project to work on, and I am trying to find the best approach to get this done. In short, I have files summarizing business with our customers (about 400 of them). The format is not perfect, but I can probably work with it (columns are always the same, but information is...

Hi all, I am trying to find the best way to fill up a dynamic table with the right values as easily as possible (hopefully one click) once I input the the order number and it's details. I am stumped not sure whether I'll need to use helper columns / vba. I wanted to get the answers to the "To...

I am trying to make a list of all suppliers my company has used this month. I want the pivot table to show the rolling 12 month period of the information, but only show the suppliers that have a value for the current month. Currently it will only show this current month of data and not the full...