jack

Dear fellows, My boss gave me an assignment that I can't find a way to do it by macro. assume I have database with lines - <tbody> Name Code Number Sub-code Date Amount John 1234 12.12.12 100 Jack 5678 12.12.13 300 Joe 9876 11.12.12 430 </tbody> What I basically need to do...

Hi everyone, I have 2 seperate table on 2 different sheet: - a Cube Pivot Table - a table that I paste from another source Both table have a in Column A, an ID that is unique value for each row. I need to merge these 2 table in a new table. 1st table (Cube pivot Table) <tbody> 1000 jack x...

I have a Spreadsheet which I have linked to other sheets effectively, (thanks to this board). I now want to go one step further and be able to write in a name in a column and within the same column, return a number (in this case a duty no.) I have tried Vlookup, if and match and so far, I have...

Hi everybody! I've recently received a data sheet that looks like this: John 2017 $85 one John 2016 $87 John 2015 $88 Jim 2017...

Hi, Writing a macro that lifts specific columns from a source sheet into a destination sheet. Unable to find decent answer online, though may not be asking in way that returns meaningful results. One column is date at start of week (Monday) followed by daily hours in adjacent columns I'd like...

I am switching to Win 10. Is there any reason not to go to Access 2010 as well? tia Jack

Win 7 Access 2007 Rather than creating a menu is it possible to import a menu from another .mdb? tia Jack

Dear Guys Good Morning Can you amend my vba as per attached link https://www.dropbox.com/s/mqecoiuv3kwlnv2/TESTING3.xlsm?dl=0 Cell A6 JOHN MR SMITH AND MR STEVE JACK result should be Dear Messrs in B6 and Banking Facilities in cell C6. tHANKS/REGARDS RAKESH

Dear Guys Any help on the below formula =IF(COUNT(SEARCH({"MR","AND","MRS"},C2)),"Dear Sir/Madam"," ") it works well for example for MR JACK SMITH AND MRS JACK SMITH. But for MR JACK SMITH only it does not work. If in cell c2 name is MR JACK SMITH then result shall be "Dear Mr"...

I have a date range with names in column A and column G will count how many times this person is signed up for a class between column B to column F. Taking into account how many classes the person is taking, I need to return their names in a list that many times Data Range <tbody> A B C D...

I want to write a code which will change the corresponding value to minimum of the duplicates set. Sample Data <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Name Number Ana 1 Rachel 4 Jack 7 Rachel 5 Ana 2 Jack 8...

Hello to all I have this names in one column David Jack David Jack Angelica Peter I want to write a formula in name manager that automatically remove duplicate names and give me a unique list with offset formula, I mean that I want to automatically increase or decrease the length of the list...

This is in Sheet1: <tbody> SupplierID 1 2 3 </tbody> This is in Sheet2: <tbody> SupplierID SupplierName Colour IQ 3 Jim Red 10 1 Jack Blue 20 2 Jill Green 30 </tbody> This code work perfectly to do a vlookup: Option Explicit Sub test() Dim DIC...

hi just trying to find a Name based of the score this is just an example on my excel sheet its has got much more teams and names so it will take a long time to use IF function Team 1 Jack, Dave, Mark and Tony Team 2 Kev, Ste, Mike and Bob if I want to give 40 to team 1 it should come up...

I was wondering how I would go about making a macro which reads off a list of specific URL variables and makes a data query and a new sheet for a different name. For example in my url tab I have this: <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant...

HI i am using a form to get an email for a list of preferred names. the list comes back to me in the order that the user has chosen but it has leading numbers on it (see below) is there a formula i can run to cut off the leading number, the : and the blank space so that the first character is...

Hi all, I would like to find the last non-empty cell in the first row. Is there anyway possible in doing so? Cheers, Jack

Hi all, Here's the formula that's not working... =COUNTIF(AK52:AK35533,CONCATENATE(T$4,U$4,"??16??m1")) Stumped! THANKS for your help! Jack

Is it possible to convert an application from Access 2003 to Access 2007 not creating an .accdb? tia Jack

Hi Guys, As the title suggests I would like to perform a sum on a group of numbers, which will be in one cell, with text associated with them (the text lines will always remain the same, example data below) <tbody> Data Answer Rob 5 Jack 10 Stan 5 Denise 17 15 </tbody> The above shows...