excel 2016

Hello there! I'm sorry to bother you all, but I've been having trouble for about a week now on how to make this work in Excel 2016 and couldnt find a solution yet... Here's what we got: There's a lobby where people going in and out, in the left group of columns. We got exact time of their...

Hello Everyone, I have got a data model at hand with several dimensions including date, hierarchical and structural fields as seen in the table below. What I now would like to do is to calculate sales for upcoming months of the current year. How it's supposed to be calculated is shown in the...

Excel 2016 and I cant allow macros due to annoying business restrictions that this another some more again lastly 86468 4654 54654 651651 Note 1 65168 Note 2 6546+4 84615 Note 2 32131 6545 Note 2 321651 98461 651 65165 65651 Note 2 651651 651651 6516511 6516 651...

Hi there, Using Excel 2016 (no macro's), is it possible to create a table that automatically (via formula or PQ) expands based on starting a year? For example, if I have a sheet that has a list of names and the starting year of each person, is it possible to create a new table that has each...

Sub ExtractNameFromWeb() Dim htmlDoc As New HTMLDocument Dim htmlElements As IHTMLElementCollection Dim htmlElement As IHTMLElement Dim url As String Dim xmlhttp As Object Set xmlhttp = CreateObject("MSXML2.serverXMLHTTP") 'Loop through all rows in column F and...

I'm looking for it to sleect sheets if on sheet1 (Recepit Ledger) B49, C49, D49, I49, J49, K49 is above 0 B49 & or L49 is above 0 it selects worksheet2(WS Dis) C49 & or J49 is above 0 it selects worksheet3(ws Face) D49 & or K49 above 0 it selects worksheet4(ws Penalty) it also is not printing I...

I have created a userform with two comboboxes, based on combobox 1 I would like to populate combobox two. In combobox 1 there are 6 items to choose from (populated from a range in sheet “Production”, itemA, itemB, ItemC, ItemD, ItemE, ItemF Based on the selected item in Combobox1 I would like...

Sub Try() 'select cell B 10,000 ActiveSheet.Range("B10000").Select ' goes up to last drawer posted if cell is empty in B Selection.End(xlUp).Select Selection.End(xlUp).Select ' highlights cells below for sorting Rows(ActiveCell.Row).Select Range(Selection...

Hi everyone, I hope everyone is doing well. As you can see in the attached pics - in "sheet1" I have a special character ( | ) between strings. I need the VBA script that can split the string into different columns "Sheet2" is the Final answer that I expect. It will be really appreciated...

Hi Folks, I would need your dearest help in vba code . For your kind info - I need urgent help on this query. Hence, I have already cross posted the same query in other forum earlier (refer link below): Other Forum - Cross Post I would need to perform additional task along with existing steps...

Hi Folks, Based on signage mapping key needs to be updated. I have updated the excel file sample for your reference. Detailed explanation below: 1) I have an sheet named "Pivot" which contains item details along with its amount related to sales data. What i exactly need is - Excel formula...

Hi, I have this formula: =(PROPER(TEXT(TODAY();"[$-809] ddd d/mm/jj"))) which is initially a Dutch language formula (hence the "jj" and the ";"), but I wanted to return the days in English so I added the locale code 809. The formula works perfectly on my work computer (Excel 2016 32-bit) but...

I have this JSON Microsoft Scripting VBA code that pulls data from a work website into Excel. Can pull about 55,000 rows of data. About 5 columns of data. On 2016 the code worked fine but on 2019, which I need the code on, it takes forever to run or crashes Excel. I then have to quit Excel. I...

Hello, I am trying to create the formula below and hitting a brick wall again. Any help would be greatly appreciated. if A1 = Green and A2 = - then good if A1 = None and A2 <> then bad if A1 = Amber or red and A2 <> - and A2 is less than today then bad else good

Hello, I am using excel 2016 and trying to create ta formula that will return a certain value based on multiple criteria. I have set out the logic below but everything I try doesn’t work :mad: if(and(a1=“Green”,a2<>”-“),”Good”,”Bad” if(and(a1=“Amber”,a2<>”-“),”Good”,”Bad” if(and(a1=“Red”,a2...

Hello, I hope someone can help me with this query: Each month I run a set of Excel Power Queries to pull data from 50 files into a consolidation model. Each of the Power Queries pulls through different datasets from the 50 Excel files, e.g. 1 would be for financial data, another would be for...

Hi, I wrote a code in VBA for calculating the simple formula as gaussSum= [n*(n+1)] / 2, the number is given by the user. But the program does not perform the calculation it just gives me the number inputted by the user. How can I connect these two, so the program could take that number and then...

Hello Everyone, I am stuck on a project that requires a sheet to get a refresh to the conditional formatting to a sheet. Whenever a user Adds Rows to a sheet or duplicates the sheet the conditional formatting seems to get messed up by duplicating rules and changing my ranges from being entire...

I have a list of past due invoices. I have a PO Date (column f) and I am wanting to add a column for Aging Days (column H) that will tell me how many days have gone by from the PO date. In column I, I would like it to tell me if the invoice is past due or not past due. Any help would be...

I have been searching with no avail on a vba to display a msgbox with specific data. I have an idea but the specific throw me off (still a beginner). This message box will display a value1 then tab then value2 then tab value3 then new line value1-2, tab value 2-2, tab value 3-2 and so on until...