support

Hi, I have a report and in that the format of the number are coming in 2 different ways. Is there a way to correct this. 1. 340.35 = this is normal format, i don't have any issue with this. 2. 28.390,26 = If you could see there is "." instead of "," and "," instead of "." and also have to...

Can any one please help to make a excel's formula for the automatic numbering instead of manual as below sample <colgroup><col><col></colgroup><tbody> <colgroup><col><col></colgroup><tbody> description automatic numbering w1 1 w1 1 w2 1 w3 1 w1 2 w3 1 w2 1 w3 2 w3 2 w3 3...

I have a barcode list i want to count these barcodes which are repeated more than three time Thanks in advance ?

Hi, Assuming these are 2 seperate lists in different tabs I would like to return the value in the second column as it is the closest match. Is this possible? If I wanted to return the first column i would use vlookup("*"&a1.... <tbody> Rehab Support Worker Support Worker Assistant...

Hi All, Please find the below descriptions which are 3 different cells (A1,A2,A3) Now i need to separate the dates which are highlighted below in BOLD into 2 different cells(B1 and C1) NOTE: All date format are in different format like (mm/dd/yyyy, mm-yyyy, mm-dd-yyyy etc) and also there was no...

Dear All, I have a file created by an external in which the toolbar is hidden. I have no options to bring it back. Do you have any ideas. Thank for he support. regards Klaros

Can someone please tell me why this works: Sheet1.Shapes("Button").Select With Selection .ShapeRange.Fill.ForeColor.RGB = 12345 End With but this doesn't: With Sheet1.Shapes("Button") .ShapeRange.Fill.ForeColor.RGB = 12345...

How can I write a VBA that will copy Table A and paste it as Table B (see below). Please allow for Range Selection. Thanks for your suggestions. Table A: <colgroup><col width="161" style="width: 121pt; mso-width-source: userset; mso-width-alt: 5888;"> <col width="107" style="width: 80pt...

Hello all. I have the table located below, but I have to organsise the data in to the format of Fig 2. Fig 1. the data the is carried over is Column D, G and H From this (Fig 1) All the info below come from the above table, as you can see the data is grouped the number is column A...

Dear members, My colleagues and I work together on projects each quarter. Each quarter there is one project Lead, and the rest of us (depending on our availability) are either a Support (i.e. we provide assistance) or else we're Passive (i.e. we're not really involved at all). Below is an...

Hello everybody. I have a couple of macro that grasp data from the web via IE. Sometimes, in launching them, a page of Microsoft Support opens automatically altering the job of the macro. How can I inhibit this inappropriate opening...

Guys I need help. I run a code on VBA in my work , and on some pc i could run it and on other i couldnt. I read some answers for that error and they said that maybe its service pack for windows i check it and it wasnt . Can someone help me? Thank you

Trying to replace a picture/shape in one spreadsheet with one in another. 'loop through all images For Each s In wbk.Sheets(1).Shapes s.picture = loadpicture(ThisWorkbook.Sheets(1).Shapes("Picture 1").Picture) Next It fails on the red line: Object doesn't support this property or method. I...

Hello all. I am using the formula =INDIRECT(SUBSTITUTE($B$10, " ", "_")) to pull a list of advisors based on the manager name that appears in a dropdown cell(B10). The list is on a separate sheet in the same workbook. The manager names are listed horizontally and the advisors under them are...

<tbody> Employee# ColumnA ColumnB 14900 support 14900 communication 14900 communication 15038 support 15038 communication 15039 support 15062 support 15062 support 15062 communication </tbody> I need help creating a formula that will get the unique value of employees...

Hi - I'm working on the formula below, =IF(OR(H4>9.01),”1Point”,IF(OR(H4>3,H4<6),"2Point",IF(OR(H4>6.01,H4<9),"3Point"))) results I'm getting is as under,pl help me to resolve this <colgroup><col><col><col></colgroup><tbody> Sensor-12Sensor-19 Sensor-10Sensor-18 5.51...

Hi, I really need your help! I'm trying to count the unique values in column A that meet two criteria that are in column K. I have over 673 employees that did a communication or support. I want a number that counts the employees that did a communication and support. Column A- employee # Column...

Greetings. The following code isn't working. All the literature says activate the sheet and select the chart area and copy the selection, and that works. However I don't want to select if I can avoid it. I don't see why this won't work but it doesn't. For Each sht In ActiveWorkbook.Sheets...

Hi everyone, this seemed like a simple problem but I'm struggling to see a simple solution. Basically I have a 'Project tracker' spreadsheet that contains two people resource columns. One is titled 'Project Lead' and the other 'Project Support'. The validation list for both of these is based on...

Dear experts need your support to resolve my problem In my specific excel file when I insert a sheet , his format is on auto as date .can we set in general on auto ? please support to resolve my problem .