shown

Morning all, As per title, in my workbook i have several worksheets. On one worksheet when i click on the name tab i would like the userform to be shown. I have clicked the tab in question,alt + f11, this workbook and then placed the following code there. When i then click the tab in question i...

Merry Christmas to you all, Upon making a selection choice from a combobox list ive got it to fill cells with the correct info but need an image to also be shown in the Imagebox. The data being entered into a specific cell is also the same name as the Image. So if i select from the combobox xyz...

Hi! As shown in the picture linked I have tried a formula which doesn't work. I tried putting the formula inside F15, but it resists to go through. To explain it in words; If H13-I13 (YES, I meant 13, not 11) is less than 0, I want it to show a particular text, if visa versa, the other text...

Hi all, I'm chasing VBA to perform the following: I have a check box in Sheet1 A1, when checked I need the value of Sheet2 D4 shown in Sheet1 A2. Thanks in advance Mark

Hello everyone, I will appreciate so much an answer to my comlpicated question: Which formula should I put that will enable me to copy the information from table 1 to table 2 as shown at the attached screen shot? Thanks a lot, Yaniv...

Using Excel 2000 Hi, I am looking VBA that can count 1 from the specific point, the idea is simple add +1 if find next character 1 is followed by 1 subtract if next cheater is followed by either X or 2 Example sheet1 there are my data in column C, Step-1 check C6 if it is not 1 result in...

Dear Gurus, To upload data on Adobe illustrator, I wanted to arrange all received data in right alignment. [/IMG] Example shown here in xlxs file: https://www.dropbox.com/s/6ukfd1ctug...ook1.xlsx?dl=0 Thanks in advance for your help and support. Regards, Was

Hi, I have the below table. <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> <colgroup><col><col></colgroup><tbody> Name Number AA 1 AA 2 AA 3 AA 4 AA 5 BB 1 BB 2 BB 3 BB 4 BB 5 CC 1 CC 2 CC 3 CC 4 CC 5 </tbody> </tbody> I...

Hi all, I am trying to define an array in VBA on my Excel for Mac, but the declaration shown to be an error. Thank you for your help! dim array(2)

So. I have a file (NEW SHEET.XLS) with a column of numbers. Column A. These numbers are referenced (only if they have a corresponding value on one of 11 sheets) as a cell with a value. These 11 sheets are names A.xls, B.xls, C.xls etc in the same folder on my computer... I would like to...

Hi, I have a chart showing 13 months data values per month, 1= met 2 = stable 3 = Miss. So the chart shows 8 months of previous data then the current months value and the next three months all show met but these are forecasted months. My question is I can get the data all ok and do the...

Hello, I am struggling with the problem shown in the image below. Any help would be appreciated. Thanks in advance. https://imgur.com/a/0dcXl

Using Excel 2000 Hi, I need a code, which can fill colours in column C as per predefined numbers of row data are shown in the cells E6:E15 For example... Count the cell down to C5, if C6 = 0 than fill 5 rows C6:C10 with red and white colour as data shown in cell E6 = 5. Next fill 12 rows...

Hi Guys! Is there a way to have a certain cell that is inside a print range to not print? For example... my print range is A1 thru F10. But I have data in cell C5 and that should never be shown on the printout. Is there any way to make that one cell always be non printable? Thanks in...

Cell U3 has the formula =j1482. I would like cell AA3 to look at cell U3 and return the formula =p1482. That is, in cell AA3, I would like to substitute the column reference "j" for "p" but keep the row reference 1482 shown in U3.

Hi All - I know with excel 2016 there is the ability to make treemaps but they are very limited. I want to be able to bring in more than one dimension and combine a treemap with a bar chart (like the imagine shown below from tableau). Does anyone know if this is possible to do in excel - i...

Hi everyone. I have a data set in excel that shows me hospital drug inventory and value by day, but because it shows by day, when I try to look at the average for a month it is incorrect because the same drug can be shown 10 times within that month but the count and value are not shown on a...

I intend to categorize Employees in 4 Groups with in a Department as shown below:-

Good Morning, I have a drop down list on my form of the combobox type. Now my list is getting longer i am having to drag the side bar for the names that are out of view to then be shown. Can this be converted so it can scroll or please advise otherwise. Dragging it seems old fashioned & need...

Hello, I'm wondering if there's a way to automatically have the current folder shown in the Excel print browse window. I have multiple excel sheets to convert to pdf and they're all located in different paths. When I open one to print, select my PDF "printer", and print (to save as), the last...