code1

Hi, i know VBS works almost exactly like VBA so this should be doable: i have the following which currently works: Dim outobj, mailobj Dim strFileText Dim objFileToRead Name1 = Inputbox("Enter Name") Code1 = Inputbox("Enter your Code") Set outobj =...

Hi! Can you please help me solve in getting the row and column name given the value from a two dimensional matrix table? Here is the table I am trying to work on: <tbody> 1 C D E 2 Team1 Team2 Team 3 3 Task 1 Code1, Code 2 Code3 Code1 4 Task 2 Code2 Code1 Code 2, Code 3 5 Task 3...

How can i sumproduct a particular column that matches a criteria. i have a heading with Product Name, code1, code2, code3 in sheet1. And in sheet2 (where i will put the formula), i have a heading Code and amount. I want to sum all Product name (example all books) that is under the code1

Hi Guys I am looking for some help with finding some content within a column and re-arranging the order of the found rows to a specific order. To make it a bit clearer please see below <tbody> score1 score2 score3 score4 score5 score6 score7 text text text text text text text 123...

<colgroup><col width="31" style="width: 23pt; mso-width-source: userset; mso-width-alt: 1133;"> <col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1462;" span="8"> <tbody> Hello folks unfortunately working with somehow strange set of data...

Hello together, unfortunately I have to work with databases like below. People work on days 1 - 5 and do different activities I would be glad to be able to have the data like written in column "J" without workarounds. In this case people who worked on day 3 with activity "c". Thanks very much...

i have multiple employee with the same employee number in column A and a code in column b. how can I highlights the same value with duplicates in column B. Ex: Col A | Col B 1001 code1 1001 code2 1001 code3 1001 code1...

I'm trying to write in a procedure that will: IF AL2, AM2, AN2 = "MATCH" THEN range("AO").value = "MATCHES" more or less, if the word "MATCH" is found in any of the cells AL2, AM2, or AN2 then I need AO2 to return "MATCHES". If not, then "NO MATCH" then loop it. THANKS GENTS Sub...