excel help

I have a bit of a complex problem that i have been having trouble fixing. We currently perform alot of data entry and i would like this macro to avoid doing it manually. We recieve a list from our client and in column A is a list of their clients. I need the macro to verify as close a match as...

Hello everybody, if someone can assist me with this question i will greatly appreciate it! I am currently working on an excel spreadsheet and i am having trouble getting data from a cell after i filter the information. My data range runs from A4:G561 and when i filter i want to get the data...

Hi guys, I'm creating a spreadsheet for remuneration and there are three ranges: 0 - 20,000 20, 001 - 40, 000 40, 001 - They each have a percentage attached to them: 0 - 20,000 = 40% 20, 001 - 40, 000 = 45% 40, 001 - = 50% What formula would I input so that when I get a number i.e. 25,000...

I am looking to do a conditional formatting formula as follows: In one cell someone can write a date based on that date it will auto populate 4 other boxes. If a person types in a date 01/01/16 through 01/31/2016 into a cell the other four cells boxes will become: <tbody> 01/25/16 </tbody>...

Hello I need a formula which will copy a row of data from sheet1 to sheet2 if a number in column A on sheet2 matches a number on sheet1. Basically, sheet1 of the excel sheet is used as a master list an sheet2 is a short list so i need to filter data through to the short list when needed...

I'm working on a data entry project for work - credit card statements have been imported into Excel with 3 columns of information: Transaction Date(column A), Amount(column B), and the Merchant(column C). The spreadsheet contains 6 columns total; column E is automatically filled, depending on...

Hi, I have one excel it has 2 tabs first tab has all data in column A(all are unique rows). ex: column A A B C D in second tab column c has few rows(these rows are just part of first tab data) Ex: Column C C D my requirement is , if I select row D(hyperlink) in second tab, I want to go to...

Hi, I have one excel it has 2 tabs first tab has all data in column A(all are unique rows). ex: column A A B C D in second tab column c has few rows(these rows are just part of first tab data) Ex: Column C C D my requirement is , if I select row D in second tab, I want to go to first tab...

Hi, I have a data sheet with the following columns. Skill Name; Assigned Chats;Transferred Chats; Conference Chats; Total Chats; Average Worked Time; Averaged Wrap Time; Average Handle Time My hope is to sum the product of cells in Column E (Total Chats) * Column F (Average Worked time) when...

Hi Everyone, I recently downloaded some data from Medi Tech and received the following date information. I have never seen the icon in front of the date. What is it? I cannot click on it or drill down into the date but it does not allow me to use the date as a date. it...

I am new to this website so I apologize if this has already been answered. The spread sheet I am working on contains more information then these cells but they are the reference cells for the conditional formatting I am trying to accomplish. So I need to do a type of conditional formatting as...

Hi, I have a large data set over 200,000 rows but I would like to select a range i.e. A1-J2000 copy to another sheet then A1001-J2000 copy to another sheet? I was doing this manually but it will take forever does anyone have a simple code for my macro do this automatically without inputing...

I have a table query and I have a column called Class codes which contain SK8G, SNOW, VAS1A, VAS3A, VAS3B, and CFL1. I want the query to have a parameter to only pull records with "CFL1". I added my column to the criteria in the query and it was set to equal "CFL1". Then I try to return the data...

This is the 1st time I have posted, so if this is a duplicate I apologize. I am new to VBA and I have the coding below. What I am trying to have happen is, if cell p5 contains "CONSOL" to name the tab one name and if does not, name it something else. I am doing something wrong as all of the...

Hello Guys, Please help me.. I have large data in Excel sheet in following format <tbody> A 32423 2234325 12131 11231 2534R 323422 1245 224241 112125 21212 353453 464363 545352 12423 123525 22424 B 114343 12342 2E23R 1342 1423R 25346 1324 1234 2525 1234 2522 </tbody> I want to...

Hello all, I'm trying to set up a macro that will run when the workbook opens ,ultimately I want excel to email myself and 7 others when its time for recertification of 50 different workers and their dates are varying . Im over my head and could really use help , thanks.I will be using task...

Help! I need to create the following VBA: It needs to look at sheet1, columnA and see if the word "rec" appears. If yes, it then needs to compare the contents of that respective row's column N to the whole of Column N in sheet 1 of a different workbook. If it matches the column N data, then it...

I have an excel file that multiple people need to access. However, the file only works on my computer. When someone else opens the file it gives this error message: "Sorry we could not find your file. Is it possible it was moved, renamed or deleted?" It's so annoying considering I spent hours...

I am trying to run a ‘Do Until’ loop in my macro that will search for a word, if its found, select the whole row containing that word, delete it, find the next and repeat. So far I have:</SPAN></SPAN> Do</SPAN></SPAN> Cells.Find(What:="Find_Word", After:=ActiveCell, LookIn:=xlFormulas...

I have two tables pictured below: Table 1 <tbody> Columns Rows A B C D E F G H I J K L M N O P Q 1 2 Day of month 18 19 20 21 22 23 24 25 26 27 28 1 2 3 4 3 Date 2/18/2015 2/19/2015 2/20/2015 2/21/2015 2/22/2015 2/23/2015 2/24/2015...