peter

Hi, Wondering if this was possible. If i have 5 images on a userform, is it possible for them to be changed according to a dropdown. eg if each image was saved in the same folder according to a set naming schedule ie Peter1.jpg, Peter2.jpg, Peter3.jpg, Jane1.jpg, Jane2.jpg, is there a way that...

Hi, I have the following table Name Degree John BA Peter BA Peter MBA When I do a pivot table for Name & Count of Names, I get Name Count of Name John 1 Peter 2 Is it possible in this case to join texts under degree if more than 1 exist? So that... Name Count of Name Degrees...

Hi, we have to collate reports from different departments. And I've been asked if we can help sort out (an evergrowing!) snag. There is a list of info <tbody> Customer Name Orders PETER SMITH ABC123 david jones 5962-99-3 peter smith XYZ789 222246 Green Bottles David Jones David...

I am working on a problem that I just can't solve. It may be that I can solve with good old IFs but I want to see if Goal Seek or Solver would work better. Basically, I have 2 tables. One table has John, Peter and Mark repairing bicycles. Bicycle A totals up to 34, B total is 120, C total is...

Hi All, Please help me urgently to solve the issue I am facing. I have attached a sample data below. I want to have all values of Product 1, Product 2 and Product 3 in column deleting rows or may be in another sheet. The "Employee Number" are unque number in this case. Another condition is...

I'm relatively new to VBA and I'm trying to write a code that will look at the receiving person column for Peter and will replace the Target Person and Target Fruit columns to match what's in the Sending Person and Sending Fruit. I used this thread here to figure out the code, but that thread...

col A col B col C USA John Peter 12 Mexico JOHN Peter 20 FRA John C Peter 25 John Peter return value should be USA INDEX($A$3:$A$5, MATCH(True, Exact(B8, $B$3:$B$5, 0)) This formula is...

Hey! Quick question: So if cells A2:E20 contain singular words, and these words could appear anywhere and multiple times in the database (A23:CC5000) what formula should I use to return a whole row from the databse if it contains a word from A2:E20? For example of C6 has "Peter" and the...

I need to extract names from a text string but they are variable in length. See example below: PETER PAN PO LLL555555D AUB-1111111 2/27/10 1079.65 1012348 SUPERHERO MAN GGG444444C AUB-0000000 8/02/10 108.00 704546 SUPERHERO WOMAN PO GSS011111F AUB-1111111 3/13/10 11.26 1028549 The names I am...

Fellow sufferers I am getting the Runtime-error '457'. The Value of the array is Empty in the watch, how is that possible? Please see code and error message. BW Peter B Hansen https://drive.google.com/open?id=1m9PO4iRRIIM7mIZdSyGmk6ydQdRSskBf

I have one combo box and a buttom I have this table in excel date name goods name Qty 21-1-2018 David Pen 12 22-1-2018 Peter pencil 14 10-2-2018 David paper...

Hi all, Scenario: a vb.net Program is currently reading some informations from a workbook open in the Application. This may take some seconds. Is it now possible to detect in vba that this currently happens. Thanks Peter

Hi, Would you please be so kind and assist me with a macro to extract specific data within a spreadsheet. The specs are. I have a list of students 30+ who rights exams every week and I want to extract the top 3 marks and names each week. Should there be more than 3 student with the same...

Hi everyone, Im trying to figure out a way to make a Table into a list. Example: <tbody> Peter Anders Mikael John Criteria1 1 1 Criteria2 1 1 Criteria3 1 1 1 Criteria4 1 1 </tbody> What I know want to do is the following if the cell has "1" with a formula if possible...

This is a Qn pertaining to <tbody> <colgroup><col style="width:48pt" width="64" span="8"> </colgroup><tbody> A B C D E F G 1 2001 2001 2002 2002 2002CY-Q1 2 Sales Profit Sales Profit Sales...

Fellow sufferers I am doing something´like this: inhabitants_in.Add "Norway", CreateObject("Scripting.Dictionary") inhabitants_in("Norway").Add "Oslo", 200000 How can I best, later, do something like, to find all the countries in the root: For each country in inhabitants_in...

I have a number of employees that had multiple check-in times. So for example Peter may have checked in 3 times on Jan 1, 2 times Jan 2, 7 times Jan 3 etc. These dates are in the Date column. I want to create a pivot table which shows an employee and the number of checkins per day. So I'd want...

i have 4 columns containing data a is employee number example 123132 b is employee name example joe blogs c is a number so example 123132 Joe Bloggs 1.00 213233 Peter Jones 1.00 213167 Sea Young 1.00 heres the challenge if the column c says 3.00 i want this to create in total 2...

Ive been working on trying to do this for 4 days and I still can't do it. gone through every tutorial everywhere. Trying to do this List 1 <tbody> Column A Column B John ID258 Peter ID236 </tbody> List 2 <tbody> Column A ColumnB John Carrots Peter Apples </tbody> To this...