jim

Hi, I have 2 tables in 2 sheets. Sheet1 <tbody> name Margin MTD Target MTD Margin QTD Target QTD James Mark Frank Jim Russell Conrad Denis </tbody> Sheet2 <tbody> Year Quarter Month Day Name Margin Target 2018 Q2 May 01-05-2018 James 10 20...

Hi all Can someone please give me some simple VBA code that loops through all the tables in a webpage? I would like to the debug.print the contents of the tables. Thanks in advance. Regards Jim

Hi, I have been unsuccessfully trying to do the following: Background: I have an Excel list with some data in 4 columns. Colum A is the status, columns B contains dates, column C contains some activities (some text) and column D contains some names: <tbody> A B C D Open 12-02-2018 Do...

Working with the underlying Excel Post System recently, As a copy a given amount of text from outside the site and then I come into the Post New Thread Textbox and either 1) Control+V, right-click-select Paste NOTHING gets pasted in. What's the problem? Anyone experienced this before? Also...

Hi, I have a report which has ticket numbers details in column A and then the details in B to N. This is the user, description etc. Column A has multiple instances of the same ticket number where the ticket was updated and I want to take any information in the other columns and put it together...

You probably read this title and thought "=sumif, dummy". However this dummy can't seem to get it to work nicely in this case. Would love some assistance. To the issue: First off, I know I could do this via VBA, but I would love to be able to accomplish it with simple formulas if possible. I...

Using the names in row 1, randomly display the same names in row 2 with a formula starting in A2 without duplicating the same name in the same column. Something like the below. Data Range <tbody> A B C D E 1 Jack Cheryl Bob Jim 2 Bob Jack Jim Cheryl...

Hi, I am using Excel 2003 on Windows 7. I have data like the below table, where there is a name in each of Columns B,C,D,E,F and I have concatenated columns B,C,D,E,F into column A. I included this data into a pivot table and what I am getting is 2 rows of data in the pivot table. 1 for...

I'm tryin' here...just can't get it... Using this formula in the worksheet: =IF(INDEX(B388:B404,MATCH(TODAY(),C388:C404,0))<>"","N","Y") And it works just fine. Just can't seem to get the VBA syntax right. Do I need to use the...

I have the following on Sheet1 below. On Sheet2 I just have everyone's Name listed once in column A (John, Kate, and Jim). In column B of Sheet2 I would like to look at the name from column A and see if it matches column A on Sheet1. If it does, then lookup the 2nd most recent...

Is it better to use the today() function is a lot of cells or put today() in another cell and just reference it? Thanks, Jim p.s. Sorry about the spelling in the title of ths :(

I am using Excel 10. If I have multiple reps that have scheduled visits, and the scheduled visits I want to track are identified with the numbers 2-51. How do I identify the missing visits according to the rep? I have found a few great VBAs for the missing numbers, have not found a solution...

Hi, trying to organize data and can't figure out what function to use in this scenario or perhaps I'm using the wrong formula? If pivot table, it always sums does not keep value even if I try and change the format in the pivot table? Data Ex: Plan A. Plan B. Plan C John 13...

Hello Everyone, so i have in my sheet a row with dates and another row with names, the names are shown several times in different dates, I want to show in other place in the sheet (a few rows under..) the name and next to every name the last date it was written so for example if Jim was...

Apologies if this is simple and/or covered elsewhere, I'm not sure of what to search for to get what I'm after! Below is an example of my dummy file (apparently I can't add attachments) <tbody> Name Project Office Jim Alpha London Jim Alpha London Sandra Alpha London Jim Omega London...