adam

Hello, I have a userform that contains a lot of controls One of them is "cmdSubmit" that contains many actions (I finished them all instead the following) I already have piece of code that copy a range and paste it in sheet2 (this range contains (Name, ID, ...)(Doesn't contain the Number) ex...

I am working on a scorecard and for a portfolio section of it I want to either calculate or lookup the most recent dollar amount of total open loans of the officer in cell C7. The table below (Located in a separate sheet) is named "Port". The expected result is $52,000,000 (Adam, most recent...

Hi, Every month a sales report is pulled showing all activity for each sales person from the beginning of the year. This tab is the total sales overview. It is sorted alphabetical per sales person. Then a tab is created per sales person. Each of these sales person tabs needs to reflect all...

Hi Excel Experts, Am trying to find a macro that auto-generate doc ref number sequentially (at the last 3 digits on the right) based on same student's name everytime I click a button. (numbers in the middle are generated randomly). Expected output : Name RefNum (cell A2) Darwin...

I have horizontal table that I want to link to another page which is in vertical order. And to auto fill vertical to horizontal. Example: ='Adam'!O5 -next cell on page would be 'Adam' !O6 Need to autofill across the Main Page: Main Page ADE -Column headers are horizontal Group1, Group2...

Hello, wonder if you can help me. I have a list comprising of: <tbody> ID Title Name Dept 2223344 Mr Adam 1 Dept 3344555 Miss Hannah 1 Dept 7755882 Mrs Jade 2 Dept 9772348 Mr Joe 3 Dept </tbody> The external program that i use exports a csv however leaves out the 'Dept' Is there a...

I have a list of numeric values in Column F to look up. I am trying to see if the value in each row of column F is valid in ranges in columns J-K and if so, return the value in column L for that row into column G. If the value is not found in any of the ranges in columns J-K, return an error...

<tbody> intil lwp owp training black brink photo ark edge fellows bci rhino ocean arcitic barbara x x x barbara x x x x barbara x x x adam x x x x adam x x x adam x x x adam x x </tbody> and here...

Hi, I am trying to get all the values from rows with VLOOKUP. I have data which has seller name in merged cell and Product is in differrent rows.For Example: Adam seller has Bananas,Oranges And Lemons... <tbody> Seller Product Adam Bananas Oranges Lemons Robert Apricotes Lemons...

Hello all, bit of a problem here. Column P contains a list of 190,000 references and I would like to count how many times each name appears in the list, so I can sum up the final tally. <tbody> P W 1 Name Result 2 Adam 3 3 Dave 1 4 Craig 1 5 Mike 1 6 Pete 3 7 Adam 8 Pete...

Please can you help me make an application that make a security gards duty. 1 - in the first sheet the table is like that: name - last date (mon to friday) - last date saturday - last date sunday 2 - in the second sheet the history for every gard duty name - 1-2-3-4-5- ........31(january...

Hello, Have been searching and searching and can't seem to find an answer. Looking to use conditional formatting to highlight a cells that have partial duplications. Eg. Adam LL, Gatchel RI, Robinson RC Adams L, Gatchel R, Robinson R Afifi TO, Henriksen CA, Asmundson GJ, Agrawal A, Verweij KJ...

Hi, I wanted help if you can provide me i will be very thankful. My problem is that, i want to search a value in a sheet and replace the value of a cell in the same sheet where that value is find but another columns lets say that: sheet1 column A hussain farhan simon adam column c 900 1000...

I must have a nitrogen bubble in my brain or something similar, I cant remember how to use a for next loop to move across a column its easy down a row because they are numerical values but how do you do It for column A to F step 1 yours with amnesia Adam

Hi, I'm new to VBA and wanted some help drafting out a code that would help me automate the following process: 1. Create different sheets based off of names on a master sheet (eg: below) 2. List corresponding product names to a particular name in the respective sheets (for instance: Adam would...

<style><!--table {mso-displayed-decimal-separator:"\,"; mso-displayed-thousand-separator:"\.";}@page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding:0px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal...

Hello Team, Can anyone please simplify the below requirement? I am looking for a total worker working hours from the time of start of the shift to the end of the shift. Please add the formulae or create a template and share with me. Sample data are shown below : <colgroup><col><col...

Hello, I have a the below table with x's (only mine is 100x300). <tbody> Adam John Fred Frank Apples x x x Pears x Bananas x x x Grapes x x Oranges x </tbody> I spend an hour+ each day copying and pasting into the below format by copying sheet...

Hi I was wondering if anyone was able to help. I have a set of data in one Sheet and I need specific Data from that sheet moved to a second sheet and a comment added. So For example Sheet 1 has Columns A through E with all employees data. I would need this data moved to sheet 2, which has...

Hi, I have two ranges of cells. I would like to check if there is an item in both of those ranges and if so, to return the item. Example: <tbody> Range1 Range2 Return value Adam Zoe Adam Betty Xenia Chris Adam Danny Eva ... </tbody> Assumption: Item exists and there...