related

Dears, I have a big range of data of spare parts where I need to find the right part and press hyperlink to view the picture of the part, is it possible to sort the pictures which linked to a certain Manufacturer or other certain cell related to the part, so if I filtered the excel sheet I can...

Kindly I need your help in this: I work in a glass industry. I have 12 processes in the plant (Cutting, Edging, Drilling...) These processes are put in Cells B16 --> B27 I did an excel file for my planning. Each order is a column in Excel (column C till Column ZZ) And for each order there's an...

Hi, In the example below I want to be able to enter the date and have the formula return the number of unique ID's related to it. So the result would be 9 in this case. Thanks in advance for your help <tbody>#DAE7F5[/URL] "] A B C D E 1 Date ID Date Count 2 18/06/2018 1 18/06/2018...

Hey everyone, I am new to VBA and all related parts of it. So I am trying to code some of my looped works in the meantime and I am eager to learn. But now, I can just edit the related codes that I can find here, these editions are just limited with references or sources or paths or spelling...

Hello All, I am trying to have a formula evaluate three AND conditions, all of which must be met, or I should get a return of "". For whatever reason (I think it's me, lol) I can't seem to get this right - been working on it for a while and it must, for sure, be syntax related, and I am just...

Greetings, I have a relatively simple script. I assign a variant variable using worksheet inputs like: b = ActiveWorkbook.Worksheets("WorksheetName").Range("B10").Value Later in the script I attempt to use the value of b: Selection.Offset(0,1).Value = b When I check the related sheets I am...

Hi, I work in a grocery store and I am trying to make a Spreadsheet file to send to my employees that will organize the information related to the products they want to put in our weekly advertisement. I need a brand name and the number of items from that brand that will be on sale and the...

Hi all, pretty brand new to power query and data models (DAX) in excel, but I've been working hard over the last couple of weeks to learn as much as I can, however I'm currently stumped on this one and am hoping for a little guidance... I have 2 tables; one Fact table that has a one to many...

Dear all, Print related features like print preview, page breaks, page setup in page layout not working in excel 2013. But it is working in MS Word. Can you please help me with the issue? I couldn't find any solution in normal googling. Thanks, safal

Hi, I am new in learning about class module in Excel VBA, I somewhere read that manipulating data in memory is much faster that manipulating data in excel, I have huge data, and below are the samples, now my question is how can I store all the rows data in the class module related to unique...

Dear Team, I have two Measures that I expect to yield the same answer and I am wondering if anyone can see why they are not yielding the same answer. The goal of both formulas is to count the number of Rented Units based on a Start Date and Stop Date. In the Data Model I have 4 tables: 1)...

Hi All, This is a little too much of a complex vba for me, and I didnt know how to describe it in a concise enough way to google it effectively. Right now it is a very repetitive copy paste, text to columns, transpose, filter process for each cell.. Basically I will get an excel cell value of...

<tbody> Project Name </tbody> <tbody> Task Name First Name Second Name Actual </tbody> There is data in another sheet in Team Data In Dashboard sheet – If I select project then all the details related to project should show up in below table. But name should not appear. <tbody>...

I am hoping someone can help me with this issue. I may not be explaining this very well but hopefully someone can decipher this for me. I have been looking everywhere to see how it would be possible to add data to bars in a pivot chart from related data. If you look at the attached image, I...

Hi I have an power pivot table. And I would like to know the last vendor we bought a product from. My tables are all connected to the PRODUCTS table. I have SALES and RECEIVINGS. The link is sku# to all tables. I would like to find out the last VENDOR it was purchased from. But the RELATED...

I did a search on this error message on this forum but am surprised to find no one has provided a clear or any answer from what I can see. It's very simple. I have two tables that are related together using an numeric ID field. All good. Table A is the "one" side of the one to many relationship...

Can't really tell the difference between the two. Can anyone explain in layman terms, please? Thanks!

I have a table called fact_ActualsOrders_ES. It is the actual cost to hit a project. It is related to dim_cost_element table via a relationship. I want to filter the ActualsOrders_ES table based on a field in dim_cost_element called cost_element_text. I only want records in the fact table...

I'm horrible with describing my problem so hopefully I will get this out right. I have a table in which I track packages with and each one has a unique number. If someone returns a package on multiple dates (i send a quantity of 500 papers, they return 200 today and 300 tomorrow), i'm tracking...

After struggling with this for two days I'm turning it over to the experts. I have two relatively simple tables in PowerPivot. Table 1 has labor costs by project and table 2 has the fringe rates for each project. I would like to add a calculated column to table 1 that shows the fringe cost...