I’m looking for some guidance on how to build my data set, so I can effectively use Power Pivot to present my results. In my attempts so far, I have come up against the challenge of many to many relationships when trying to create relationships between my tables. I have tried to create...
I need help with this: In cells A1:A6 I have Name of Shape In B1:B6 I have refference to another cell in form D2 in cell B1 , E3 in cell B2 , C6 in cell B3 and so on.
I need to create multiple Circular Shapes named after A1:A6 and placed into refference cells, which is in B1:B6 and loop...
I have 200 links to different workbooks that I need to turn into tables/data.
I have two dates, where I'd like a message box to pop, if the dates are between this criteria.
sDate1 = #10/1/2019#
sDate2 = #9/30/2020#
How would I create the following?
If date is between sDate1 & sDate2 Then...
I have 3 columns A2:C10 where i put an Id in ie 12345
now some cells could have blanks, an Id or multiple Ids separated by a comma
what i want to be able to do is if the cell has an id or multiple ids then create a string like this
for some reason its lost my string concat
I every one, i have a problem...
I have created a table in dax, like this
NISCountLT2 = SUMMARIZECOLUMNS(LT2[ID]; "Total"; COUNT(LT2[ID]))
to count repeated IDs
then i use this code to create a column with ranges for the report
Bucket Range = SWITCH( TRUE();
Normally we create named ranges by referring to excel lists - we select the data range that is located in certain cells in worksheets.
I tried to create named ranges by manually adding data to "refer to" part. But it didn't work - all the data that I added appeared in one cell, so not...
I have a tricky problem that I can't solve, and I would like help from more experienced people.
I have a gantt chart to show the progress of tasks by user.
Bar colors are made by conditional formatting, but each cell that is painted also has a value of "1" (while unpainted cells...
The code below is working. I have 2 workbooks. Workbooks(1) has the code. When the user enter x = 2
the code below will create a worksheet in Workbooks(2) after worksheets(1). It is working but I wonder, in line 4, why I did not have to do this
I would like to know how to create a UDF in VBA that replicates a SUMPRODUCT formula. Is this possible and how can I do it? I am new to VBA so not familiar enough with the code to create this myself.
For example - UDF - HO() = SUMPRODUCT((Item Index range=X)*(Date Index...
I am pretty new to Power Query so please be gentle!
I have a table with 2 column's from a database. The first column is a Parent recipe, the second column is a Child recipe. Recipes will be found in both columns so no unique records.
I want to Right click on group of cells --> Format Cell --> Custom --> [h]:mm
So it is 3-4 click and I want to do that alot. Can I create a short cut to do these 3-4 steps in one click for example. Or Can I create a link in QAT area. Thank you very much.
I have data I want to split up into clients names.
In range K5:"Last column" & 5
I have a list of clients names
I want to create a tab for each client and add there data to that page but I have a umber of problems please help if you can?
So for each name I want to create a tab...
I have a list of contact information and a template to transfer it to.
Information that has become a row will go to a fixed place in the template.
how can we create a copy code for this?
creating a copy of the existing template file in accordance with the number in column B would be...
I am trying to create a code that allows me to create a folder in an specific directory with folder name on textbox1 and if this folder is already created in that directory, it does not allow to create another with the same name. As I am very new to Excel VBA, can you please help me...
I have this formula that I've got working IF the sheet "Arrival" already exists. However, would would I go about using this if Arrival doesn't exist? I know how I could create it with vba but trying to figure out how to do it with a formula.
I am trying to create a pretty simple UserForm that will contain 4-10 choices that I want end users to select all that apply and then create a text string based on their input. I have browsed the web but nothing seems really clear to me.
Can anyone point me towards resources/step-by-step...
I would like to add an LGA map on top to create new geographical boundries and names. Eg. an Local Government Area can be a combination of more than one or multiple postcode. I have downloaded the shape files from government websites but I am unable to create custom region maps as per...
I have a workbook (example: Report.xlsm) in my local computer. In this workbook, I want to run a vba code to create a copy every time I click the save button to certain directory in my server (example: \\192.168.0.6\Production\). So, I will have 2 Report.xlsm files, 1 in my local...