tom

Hi, I have a worksheet called POSTAGE. There are customers names in column B Current range at present is B10:B979 I would like some help with a basic code where any customer that doesnt have a number after there name then the code would add 001 So TOM JONES would then become TOM JONES 001...

Morning, I am using the code supplied below. When i open my worksheet i start to type a customers name in cell A6 When i leave the cell the code checks to see if this customer has purchased from me before by looking down column A & if so it then shows me the msgbox "A Duplicated Customers Name...

Hello, I have done a fair bit of research with no luck and hoping to get some assistance. I have data from A3 to W10,000 and I am looking for a macro that can remove rows where the name in column C is a duplicate and the date in column W is within 21 days of another date with the duplicated...

Hi, I have difficult question which I need non array formula in column B which looks at column A reference uses wildcard match Column an returns vales from Column E. Column A Column B Column C Column D Column E <tbody> Name Group Name Should Be...

Hi, I have difficult question which I need non array formula in column B which looks at column A reference uses wildcard match Column an returns vales from Column E. Column A Column B Column C Column D Column E <tbody> Name Group Name Should Be Search...

Hi does any one know if you can insert a picture, file name say Tom, into a cell. So if I have the word Tom in a drop down box in cell A1. I would like the picture of Tom to appear in cell B1 and sized to fit in a cell say 100x 100. And if I change the name to say to Jack then Jacks photo will...

Hi Experts, I need quick help. I can't share my real data however I have made up this dummy data. My real data has the similar pattern and have more than 10,000 rows. Thanks in advance for your help. Here is the problem. I have 2 sheets. SheetA and SheetB in the same workbook. SheetA...

Hi there, If I have a static table that I want to create a summary from. For e.g. A B C 1 Andy M 23 2 Mary F 46 3 Mike M 17 4 Beck F 35 5 Tom M 29 Column A is static, so I want to create a summary table below it with only entries in column B that match 'M' which also includes column A, B &...

Hi All, I have this code which adds blank rows at points on a table where names change over from one to the next. Bob Bob New blank row here Anne Anne New blank row here etc etc etc Tom Tom Total Note - No new row between Tom and total Sub...

Hi, When you have a list of names with corresponding %'s such as below and you have double names, such as Tom and Joe, how to get the first % that belongs to the respective name? Tom 0.5% Joe 0.25% Brad 0.25% Bill 0.35% Charlie 0.26% Tom 0.6% Joe 0.30% Many thanks

Hello, I've got a txt file with over 200+ entries that I want to convert into a table. How is it possible to have data formatted as the following: Name: Tom Age: 23 Name: Harry Age: 82 Into the following <tbody> Name: Age: Tom 23 Harry 82 </tbody> I tried data import but...

<tbody> Tom Richard Harry Tom Richard Harry </tbody> What formula do I put in the top row - which searches down that column for a non-empty cell, and displays the result? I'm having no luck with the LOOKUP commands... Thanks for the help!

Hi all, This may be a bit of a long shot but I am trying to create or put together a VBA Macro for package distributions that will send out multiple email notification emails at once to the approriate point of contact each with slightly different subject header based on their location and the...

Afternoon. In a worksheet at column B is a list of customers names. When a customer makes a return purchase their name is then followed by a number. Example, Tom Jones Tom Jones 1 Tom Jones 2 Tom Jones 3 At first it was fine but now introducing a combobox list once the numbers are greater...

I have the following data which i need to process: - A B C Tom 39.57 Tom 117.73 Red Tom 195.89 Red Tom 195.89 Amber Tom 352.21 Red Jerry 508.53 Jerry 586.69 Red Jerry 264.85 Green Jerry 343.01 Red When the values in A1 and A2 are the same I want...

Hi Forum I am trying to simplify a roster spreadsheet for payroll. Sheet 1 Roster - job, staff and days working <tbody> Job shift hours mon tue wed thur fri job 1 0930-1800 sally bill tom bob sally job 2 0730-1600 bill sally bob pete bob job 3 0800-1630 tom bob sally tom pete job...

I’m searching for some guidance on creating a timesheet. I thought I would find something on the web,but I couldn’t find anything that really fit what I’m looking to do. Scenario: Tom goes to lunch. He opens theworkbook, and launches a UserForm (UF). Tom completes certain data elements...

Hello everyone, I am currently working with a large amount of data from an output. I am trying to make a formula that only counts one instance of a repeated value. Basically, and I am trying to make a head count based upon name and rank and I am getting repeated information throwing my count...

Hi, I'm trying to reinvigorate my classroom incentive system. I've created a few versions but I'd really like it more streamlined but my Excel knowledge is limited. Basically, the students earn money for tasks and good behaviour, which they use to purchase rewards (sit in teacher's chair for the...

I have a basic table I wish to transpose but can't seem to do so in access. I use the normalization method excel, but can't see how it can be achieved in access. Current Table at top and outcome I seek is below <colgroup><col width="90" style="width: 67pt; mso-width-source: userset...