shown

Hi - hoping someone can help me, I have a macro which is meant to copy a set of data into an email for distribution, part of the macro applies a filter to a column containing completion dates. After I run the macro no data is shown on the screen but when you check the filter custom filter it has...

Every time I click outside of a pivot table the fields on the far right disappear. I'd like to keep them on all the time. Is there a way to do this? Google hasn't shown a solution.

I get an export out of our scheduling system and need to aggregate the raw materials needed. I need a formula that, when "1" or blank is shown, it will give the next value above that is not a "1" or blank See below for my data set and what is needed How my data exports Column I need to create...

Hi good morning, please can you help me I have the code below where I am copying date from a sheet into an email but I want it to wrap text as all information isn't shown when copied over. Please can you help? Private Sub CommandButton8_Click() Range("F8").Value = Range("F8").Value + 1...

</SPAN></SPAN>Hello,</SPAN></SPAN> Need a VBA, which can fill 3 different colours every Step7 as long as data find in the columns C:D </SPAN></SPAN> Note: colours must be different in both C & D column as shown in the Example...</SPAN></SPAN>...

<tbody> Table 1 Table 2 Table 3 </tbody> <tbody> DL DM DN DL DM DN DL DM DN 1 SHIFT SHIFT SHIFT 2 1 16 1 16 1 16 3 2 17 2 17 2 17 4 #N/A 16 18 #N/A 18 18 #N/A 16 18 5 3 19 3 19 3 19 6 #N/A 17 24 #N/A 24 24 #N/A 16 24 7 #N/A 18 27 #N/A 27...

VBA Will Not allow me to enter this formula as shown below............ ActiveCell.FormulaR1C1 = "=(GETPIVOTDATA("Total",'TKOFF Summary'!$A$3,"LEVEL 3","D" & Select_Row,"Area",F7,"CSI MF CODE","H" & Select_Row,"ITEM DESCRIPTION","I" & Select_Row,"Unit","K" & Select_Row7" I keep getting the...

Hi, I have copied a code from one worksheet to another as i would like to use the same but on another sheet. The code is shown below & i have changed the cell ref to B7 & onwards. My problem is that there are no names in the drop down list. I go back & check the sheet i copied it from & that...

Hello,</SPAN></SPAN> I have set of 14 numbers in cells A5:A18 I want to have combinations as shown below this probably will make 16384 rows</SPAN></SPAN> Here is example </SPAN></SPAN>...

Hello,</SPAN></SPAN> I want just last row of the sheet1, which is not fixed, can be any row number but in this case is the E25:R25 I want copy into the sheet2 as shown in the example below </SPAN></SPAN>...

Question from a complete Excel dunce so - you have been warned! :) I need to do a doughnut chart for Jan through Dec and have formatted (manually) the attached (I hope the image comes through ok). https://drive.google.com/open?id=1DYmXE7TO9sXRu6Ox68ODLeWuRa80rpW9 The doughnut in Col F (which...

I would appreciate some help with this task as I am really stuck trying to work this out. I will try my best to explain it. I have 2 worksheets in the excel file. The first worksheet is where all the data is sent from the 3rd party software. I have no control over how the data is displayed on...

I've googled this with no luck. Every formula I find seems wrong. I want to count the number of days an employee has worked in a row automatically. In the image shown here, Cell D2 should be 1, D3 should be 2 (because there are values greater than 0 2 days in a row for billy), but D4 should...

have sheets with 100k+ rows of data. values in some cells are calculated values. I need to incrementally subtract a value from an entire column, bottom up. example data <colgroup><col><col span="2"><col><col></colgroup><tbody> A B C D 1 370 19242 19192 18542 2 461 18872 18822 18222 3...

HI I am basically using this below to add 2 cells together. I need to change it to work If in Cell K there is nothing then return zero or blank. If there is a umber in K. Then it would work like shown adding both up. I am trying not to add AH if K is empty. Thanks =SUM(K23,AH23)

I wish to catalogue my albums but when they are in excel they are shown by the track number first 06 Killer Queen 02 Spirit in the sky 96 life on mars Some are even shown as 1-01 sweet Love 2-02 Strut your funky stuff I wish to remove the fist word in the string and report just the song title...

Hi, I came across this visualisation: https://powerbi.microsoft.com/en-us/blog/visual-awesomeness-unlocked-liquid-fill-gauge/ It is a great visualisation, but doesn't seem to work properly. On first loading, it shows % as % eg 101 is shown as 101. But if you filter at all 101% displays as...

Hello,</SPAN></SPAN> The formula I am using for that in need to have helper columns gives result in column "K" as shown below</SPAN></SPAN> Book1ABCDEFGHIJKL123n1n2Joinn1n2JoinLast Row Number4313 | 1111 | 1235858 | 5121 | 2296313 | 1131 | 3157525 | 2141 | 4278222 | 2151 | 59686 | 8161 |...

Using Excel 2000 Hi, VBA, conditional formatting macro in the columns C, D & E as shown colours for pattern in the C1:E4 and in the columns G, H & I as shown colours for pattern in the G3:I3 Example data...

Hi, I have an issue and I'd like someone's advice on what's the best/easiest way for the following to be done. In column D, I have a numbered value that is found via a VLookup formula. (This is the QTY of the trays on that particular program) In column E, I have a data validation list of all...