Hello, I have two excel spreadsheets. I want to know how I can find out which stock numbers are on both spreadsheets. Do I use VLOOKUP and if ...
If I put a name in cell AC4 then I want to transfer value of cell A4 & Y4 to other sheet. Can some some help me in this matter. Thanks Musharaf
Hello - I have two 2 spreadsheets. I want to find out which stock numbers are on both spreadsheets. Should I use VLOOKUP and if so - can s...
I have aproblem with positioning in excel and i have been doing this but i have failed can you give me an assistance like by positioning them lyke 1s...
Hi I have 9 different descriptions of trailer loads in Column D (they are programmed so I can choose them from a drop down list). Then in Column F ...
Hello, I need to bring back a value (customer Id) into Column J if column A from that workbook and Column A from another workbook are a match. T...
I want to do conditional formatting. But my numbers change if a certain box is checked..... how do I accomplish this??? i.e. A regular clean would...
Hello guys, I'm trying to classify a cell [G1] based on particular words found within 2 columns [D1 & E1]. This classification copies down from [...
Hello, I would like to request that Suppose this line of code is working for Column B MsgBox "You entered is Invalid" this will show the m...
Hello, I'm using Excel and when I put a date in a column it changes to a numeric code. For example: 4/5/15 now reads 42099. I've tried highlightin...
WPS require an automated process for adding new suppliers into the "Resource Management" workbook. There is data for three new suppliers (Agenda Corpo...
Hello, Configuration: Windows 7 / Internet Explorer 9.0 I am looking for a formula that will compare two columns with dates. It would be co...
Hi All.. i need a macro to copy data from one sheet to another in a different workbook and folder. There are 2 folders which contains files of same...
Hello, I would like to request if user copy data from "ExcFileB" Sheet1 to "ExcFileA" Sheet1 then it always Pasted as Values. Is this possible i...
Hello everyone, thank you in advance for any help I receive with is question. I have multiple worksheets in a workbook that have formulas in them b...
Hi The Below formula =IF(OR(D2="Best",D2="Worst"),FALSE,TRUE) used in Data Validation for Column E I would like to request that it could changes t...
Hello, Its being requested please fix the code given below the problem in this code is that any one of the given condition execute and once ...
Hi, I'm using Excel 2007. I've changed the date format to dd/mm/yyyy with no problems. However, as soon as I begin to edit a date, it changes to...
I run a weekly pub trivia and I use a spreadsheet to keep track of cumulative scores. There are 6 sheets in the file... Week 1 Week 2 Week 3 W...
Hello, I have 2 macros in 2 different workbook Currently i have to run 1 st macro(!st work book),then open 2nd macro workbook then have to run...
Hello, I need a macro that looks at 13+ sheets and locates the part id that is on the master sheet and returns the value under the Parent ID that ...
Hello, I am grateful if this query be solved. If user Enter any value in C2 and also user enter "Best" or "Worst" in Cell D2, how it may clear th...
Hello, How can I prevent a command button from running before data is entered into a cell? I have a workbook that refreshes data based on when a...
Hello, Its being requested please help in the below multiple IF function used in Data Validation =IF(ISNUMBER(E2),AND(E2>0,E2
If a column has a number entered into it, the second column needs to auto populate with corresponding text. eg column I: User enters "22" co...
I have a spreadsheet with various tabs including data which has been dumped in from various sources. Data includes: worked hours by department, and pr...
Hello, I was wondering if there is a way I can say to excel without coding: 1)IF cell A1 is equal or greater [equal or less] than cell B1, then...
I have a list of variables in column A. I also have their values in column B. I then have column C, which has variables from the list in column A but ...
Hello, I was wondering if there is a way I can say to excel without coding: I have three cells A1, B1 and C1. If A1 value (which constatly chan...
Hello, everyone I want to thank you in advance because I know that excel can be frustrating. I hope this is an easy one I have the following data list...
Hello, I want to thank everyone for their time in advance. My problem is that I have a two cells/rows (78 & 87) in a column on this worksheet ...
I'm using Windows 7. My Excel 2013 Jump List only lists the latest CSV files. How can I also get my excel files to show in the jump lists? (This...
Hello, I have two excel sheets. Sheet 1 has A,B,C,D columns and sheet 2 has A,B,C columns.Now I want to compare A,B,C columns in both the sheets. ...
Needing help finding a formula/function to use for this situation: I am holding a photo contest. There are 3 different types of photos people may ...
Hello, I have a table on Excel 2013. I would like a macro to do the following: 1) insert a row bellow a given cell 2) copy the format of the origi...
Hello, Can anyone help. I want to find the last column used so that I can compare it with the first column Configuration: Windows XP / Firefox ...
Hi Guys, I have created a macro that splits a master worksheet into separate tabs based on specific criteria then saves each tab as a separate wor...
Hello, i need to create a macro to find a cell based on the value of other cell. for e.g. i want find the cell by copying cell "DH1" (in which t...
Helo i need some formulas .e,g.TA,DA,HR,INTEREST% in like insurance. And Grade,%,fail,pass. Please help me undefinedHelo i need some formulas ....
Hello, Hello, I need a help if some one can help me. i a fresh in excel vba code writing. please provide a code to protect a cell with passwor...
Hi, I need to search and extract up to 10 lots of 46 sequential cells from column A containing 1400 cells. These 9 or 10 lots of 46 cells need to be c...
Hello everyone and thanks in advance! I have a report in excel 2010. In that i created a named range as "nmerng" which refers two columns s...
Hello, I am having a problem in excel I can't figure out. I have an example of what I am working with below. There are 3 columns A (SKU), B (Numer...
Hello, Not sure if what I am wanting is possible but thought I would ask... I have a database in which I will always update and add to. And ea...
Hello, I am trying to Copy from sheet's all values to another sheet. But its not coping with their cells formate.
Hello, I need to compare two columns with another two columns and return date from a third colum. Example I have a zip code with 90004 with 3 dif...
Hi all, I have a lot of social media messages in row 1 below eachother, and my goal is to find all the hashtages from the messages. For example: ...
Hello, I am trying to write a logic formula in excel without using "if" in the formula. I want it to say if less then or equal to 10 the answer is...
Hey guys can you please help a desperate girl out lol I have a report I do every 2 hours at work through excel. I have two reports that go into a m...
Hi Guys, I have created a macro that splits a master worksheet into separate tabs based on specific criteria then saves each tab as a separate workb...