entity

Thanks for visiting mypost. I have encountered a difficulty in applying sumif function. The raw data is likethis. In worksheet 1, thereare 100 companies' name on one row and 87 expense items on one column Worksheet 2 is atemplate. I need to create a worksheet for each entity based on...

Hi there, Sorry to bother you but I was wondering if any Excel experts could give some guidance on a VLookup question? I am trying to look-up two combined records. I have a sheet with Entity 1, Entity 2, Entity 3 as columns, then as rows (headers) I have departments (Accounts, HR, Admin). I...

Hi I have approx 500 companies which could have a balance with each other. So in total are approx 250K combinations. I am trying to group them to see whether the balances between them are correct or not. For example AB-CD should be grouped with CD-AB. I have tried to find MATCH and INDEX...

Have a VBAcode: Want the user to be able to select the variable "entity" by selecting a row in a combobox... The combobox should have 2 columns with Entity; Entityname 200 ; Google 201 ; Amazon 202 ; Microsoft sub opentb() dim wb1 as workbook dim wb2 as workbook set wb1 = activeworkbook...

Hi , i am trying to save a multiple sheets from a workbook on to pdf in the same folder where excel workbook is saved, file name with specific cell value below is the code i am using & i am getting, Application-defined or object-defined error, can someone please help on this, i know i am...

Would anyone help me top figure out the code for copying data from one sheet (Helper) to another sheet (Schd) in the highlighted cells, Source data have 6 entities and if target already has any entity matches with the source entity then it should skip that one, Like in this, "Gohar" is...

Hi guys, I'm a litle stucked in here. I have this formula: AVERAGEIFS([Un Price],[Entity],[@Entity],[Item],[@Item]) Which gives me the average price by Entity and item but i would like to add the month, because the next month it could be a different value and i wanna compare later with other...

Have a code to select a sheet. If the sheet dont exist I want a message box telling the sheet dont exist. Otherwise want to select the sheet. Sub Open_TB3() Dim entity As String Entity = InputBox("Select entity") if error Sheets(entity).Select then messagebox (The entity does not...

Get a syntax error when trying to run this piece of code Sub Opentb() dim Entity as string Entity = InputBox("Which entity") Workbooks.Open Filename:="S:\Lon_Acct\TB\UK TB_MTD_"&Period&"-en-us.xlsx" End Sub

I started a job where a weekly cash update spreadsheet is reported to corporate by one of it's entities. The worksheet has a column for every day of the week with the top section for cash receipts and the bottom for payments. It is very cumbersome. So, I created a data table for the entity to...

I have a spreadsheet that has several tabs that contain monthly data. Each tab is for individual entity. I have another sheet that has formulas that get the date from the first sheet and sum the other data columns from the various sheets. New data is added to the tabs that contain data for a...

Hi, I am using Excel 2013. I have 2 different spreadsheets with 2 variables that I need to sum the balance. Notice the Main spreadsheet has the same account number for all entities. However, the Lookup spreadsheet has multiple accounts and entities. I need to sum the balance by entity and...

Hi All, SQL is something very new to me and I'm struggling with the following case: There are two tables: - "Account" (containing information for account numbers and their respective owners - "Entity") - "Agreements" (containing information for agreements an account or entity may have) --...

Hi, i'm trying to sum the top 5 entities that distributed in a particular month. However, if an entity distributed more than once in a month then sum the amounts that entity distributed in that month so it is only counted as one entity instead of 2. E.g. if I am doing my report for June 2016...

Looking to populate Listbox2 with unique values values from Row3 ("A list of activities that each Entity does") but only for columns("Entity") that the user selected in Listbox1. I'm not getting an error but it's not working quite right .... Sorry I am a beginner so my format might be horrible...

Hi there, I search an idea to display good and bad results in my summary sheet. I monthly calculate one result per entity, let's say one per sheet. At the beginning of my workbook, I also have one summary sheet with comments and the list of all the results. I search an idea to display the...