I have a Combo Box with (3) Fields:
SELECT [GP Schedule].[EVM/VM], [GP Schedule].BEID, [GP Schedule].BusinessEntityName
FROM [GP Schedule]
WHERE ((([GP Schedule].[EVM/VM]) Is Not Null))
ORDER BY [GP Schedule].[EVM/VM];
I have it setup and bound to Column 2 - which is the BEID. When I select...
Hi Team,
I have a data as below and the data starts from row 3. Row 1 and 2 are headers.
What i want macro to do is to create a new workbook for respective user and draft an email with standard text from outlook. In below example for James there should be 2 emails generated because the name is...
Hi everyone,
I'm completely new to VBA and scripts so I finally decided to make a post after trying unsuccessfully to parse through things here and stackoverflow over the last couple days.
The problem is that the software I'm using spits out the obtained data in a completely unusable way for...
Can someone show me what code I would need to add to my current code. I want the "checkbox1" To look at the line that am on at on Column 'I" or "9" however that works and if the value is greater than "0" t recheck the box when the user form is opened. I am pretty new at this and have tried...
So I have an array called Setup declared as a variant.
i pass a range to the array eg A1:E7 and Setup becomes an array like this
setup (1 to 7, 1 to 5)
i want add another dimension (1 to 3) but preserve the range data already in the array. What’s the best way to do this?
I know I can’t...
I have a mortality table for 100 people, and I'm trying to calculate the expected deaths each year for 20 years. This requires me to calculate the probability of one death and multiply by 1, then calculate the probability of two deaths and multiply by 2, and so on up to 100.
The setup of the...
Hi guys,
I am really struggling to use PowerBI in the following setup:
I have a PowerBI desktop. I Created a project where I import data from an excel file on my PC and I installed personal gateway and setup a scheduled refresh, so it will be published online also.
I get to endless problems...
Hello, is there anyone that would know how to setup a conditional formatting rule to bold any number that is in column A if it's appearing in column R?
Hi all,
I want to create a graph based on years (2017, 2018 and 2019), companies (A1, A2 and A3) and type of product (cake, chocolate and cookie). I know it's possible to create a graph based on 2 of these, but it is possible to based one on all of them? If so, how should I setup my data?
Thanks.
I have this setup
COL A - COL B - COL C
F1 - 01/01/2016 - 31/02/2016
F2 - 01/01/2017 - 31/02/2017
F3 - 01/01/2018 - 31/02/2018
F4 - 01/01/2019 - 31/02/2019
For a specific date that falls within a given period, i wish to return the relevant reference. F1, F2, F3, F4
So e.g. for 30/03/2017 the...
I really can't word this well, so I'll explain what I mean.
I have 2 sheets, the first one you manually type things and the 2nd formats it into a certain way. The first sheet is setup vertically with names being the rows, and the formatted sheet has the names as the columns.
To format the 2nd...
Hi all,
This is my first post here - Please be kind: I am new to VBA /JSON and Power query.
I am trying to retrieve this table in Excel (I use Excel 2010 and/or Excel 365):
https://query1.finance.yahoo.com/v8/finance/chart/CCC?symbol=CCC&period1=1548528704&period2=1549047113&interval=1m
How...
Hi,
I have VBA code that sets up a pivot table, but for some reason my range is not selecting properly. It is supposed to select the range starting in cell A1 to last column and last row. But instead it is selecting A:AS.
Here is the code. The part that is not working properly is...
Hey guys
I have another problem if you could please help me, thank you. I have this setup:
I want to display 1 in column M for the first item that has the condition Yes, column K is a drop down with Yes and No. I don't know how to stop the second formula to run if the first one is...
How would I go about updating the series on a chart that is currently setup like this to utilize a table?
Series Name: =Harrisburg!$H$6
Series Values: =Harrisburg!$H$7:$H$146
The table is already setup and when I create a new chart from that table the data series information looks the same...
I'm trying to use .PageSetup to get a few pages in a workbook ready for print, but I'm having trouble getting the expected response with Title Rows, and I can't find a good code example for using VBA to insert a header (and footer) with cell references.
Below is the code that I have, and I need...
I am currently using the German version and it works great but I always end up having to retranslate alot of the text when it generates HTML code.
I can setup a Google Drive Folder for the files to be placed inside for other users if someone has it?
Please let me know, thanks!
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.