name1

Hi Guys I have the following userform in the here under link https://www.dropbox.com/s/y7lstauovd3iojd/5.xlsm?dl=0 I need to do the following :- when the user enters Name in the text box same shall replicate in Name1 and Name3 3.Example if the user enters John Smith , John Smith shall...

Hello and good weekend to all, Would like a result set of Name1, Data1 and Data2 when the name in col Name1 matches the name in col Name2, is that done in vba or in which area; Name1 Name2 Data1 Data2 Al Bain Win Vung Al@test.com 800-777-7777 Sue Reed Al Bain

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 =...

<colgroup><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"></colgroup> <tbody> <colgroup><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"></colgroup> <tbody> Invoices Name2 Priority...

Hello there, In workbook1, I have data in column A for 'Name1'. 2019-04-18 2019-04-19 (cell filled in with blue) 2019-04-20 (cell filled in with red) 2019-04-21 In workbook2, I have columns in row 1: Name1 ...... Name2 ...... Name3 I'm wondering if there's a code that will search for...

Hi, Im trying to figure a way to count ColumnB (dates) or unique values only for single name in column A (names) so the result for would by name1 = 2 name2 = 2 <tbody> name1 1/1/2000 name1 2/1/2000 name1 2/1/2000 name2 1/1/2000 name3 2/1/2000 </tbody> any help is much appreciated..

I have the following entries in a spreadsheet: <tbody> Employee Date Days Total Balance Used Balance Booked Balance Remaining Name1 0 Name1 0 2 0 0 2 Name1 4/25/2019 1 20 3 0 17 Name1 4/26/2019 1 20 3 0 17 Name2 0 Name2 0 Name2 1/2/2019 1 37 3 32 2 Name2 1/3/2019...

I have 3 listboxes. The first one contains names, reference, and negative values. The second is structured the same way but with positive values. what I am trying to do is to loop through each row in listbox1 and check if the name exists in listbox2 and then if found distribute the negative...

Good Day, I have a data table like below starts from A2 to C19 Is it possible to ruffle those datas randomly by clicking a command button? Every column will remain with same datas ony their rows will be changed... Thank you... <colgroup><col span="3"></colgroup><tbody> NAME1 1 1 NAME2 1 2...

Good Day, I have two worksheets. Worksheet1 has 4 comboboxes Worksheet2 has ColumnA=Departments and ColumnB=Names How can I fill that 3 comboboxes(2-3-4) if the Combobox1 selected by department? Thanks <tbody> Cmbobox1 COLUMN-A- COLUMN-B- Department1 Department1 Name1 Department2...

Hi, I have a large spreadsheet with 2 columns A and B <colgroup><col style="width:48pt" width="64" span="2"> </colgroup><tbody> Name1 Apple Name1 Apple Name1 Apple Name2 Apple Name2 Apple Name2 Peach Name3 Pear...

hi all members how to make automatique calculations of differents names in same column when we have alot of names same, what i want not sum of name1 and sum of name2, what i want sum of different name <tbody> name1 name1 name1 name2 name2 name2 name2 name2 name3 name3 name4...

Hello. In columns A and B (A2:B600) I have a lists of customer names and their buying prices in columns D and E (D2:E600). When customer name is in column A his buying price is in column D (same row of course) and when customer is in column B his bying price is in column E. I'm trying to...

I would like to calculate the total hours for M, T, W, Th, F, Sa, Su Can you please help with the formula? I was able to get the total hours for each employee but haven't been able to figure out how to break it down per day. I have the following table: <tbody> Employee Name Employee Number...

I have names in a table listed multiple times and I want to create a formula that numbers each one and starts over numbering when the name changes. name1 1 name1 2 name1 3 name1 4 name1 5 name2 1 name2 2 name2 3 name2 4 name3 1 name3 2

hHi All, Hope you all are well - Im trying to add a formula that will give me the start time of a person and end time of a person for each day These formulas seem to work fine for the start but falls over for the end shift. It seems to fall over when there is a lap of time. see this example...

Hi Folk's, I am very limited in my knowledge with excel and could use some help for my business.... I have monthly entry's, each sheet named by month.... on a separate sheet, lets call it DATA, I have the whole year indexed for fast lookup. I want to be able to find multiple MATCH's shown for...

Hello everyone, I have this excel spreadsheet and one of the column contains notes. I want to be able to extract a specific text based on a common user. Below is an example of what is on the notes column. These are all on one cell. Test,Name1 10/18/2017 8:43:15 AM > FAXED Test,Name2...

Hello, I am having some issues with a complex INDEX/MATCH formula but am not sure if this is even possible. I am trying to pull numbers from a large array based on 3 criteria. There are 2 tables below; the left is the manual entry data tab, and the right is a more simplistic view where the...

Hi, I have been trying to find a neat way to do this but i haven't been successful. I have this sheet <tbody> Monday in Monday out Tuesday in Tuesday Out Name1 05:00 13:00 05:00 13:00 Name2 12:00 18:00 08:00 17:00 Name3 12:00 18:00 Name4 11:00 15:00 Name5 06:00 11:00 07:00...