Excel Forum
-
Find which stock #s are on both spreadsheets [Closed]
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 ...
-
Transfer of data to other sheet [Closed]
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
-
Compare data in 2 spreadsheets [Closed]
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...
-
Positioning in Excel [Closed]
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...
-
Excel multiple IF conditions [Closed]
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 ...
-
bring back a value (customer Id) [Closed]
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...
-
Conditional formating with If statements [Closed]
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...
-
Return header if word within cell matches word within any array [Closed]
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 [...
-
how to extract target value from other cell [Solved/Closed]
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...
-
excel is automatically changing dates to a numeric code [Solved/Closed]
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...
-
Excel Macro [Closed]
WPS require an automated process for adding new suppliers into the "Resource Management" workbook. There is data for three new suppliers (Agenda Corpo...
-
Formula for Date Comparison [Closed]
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...
-
Copy data to a different folder [Closed]
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...
-
Cut Copy Paste Option [Closed]
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...
-
Protecting your formulas in multiple worksheets [Solved/Closed]
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...
-
Data Validation Formula changes to VBA Code [Closed]
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...
-
Fix The Code [Solved/Closed]
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 ...
-
Date format changes when editing it [Solved/Closed]
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...
-
Copying entries from multiple sheets to new sheet, then summing [Solved/Closed]
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...
-
Merge two macros of 2 diffrent workbooks [Solved/Closed]
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...
-
Macro needed that looks up part id and returns part id [Closed]
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 ...
-
Remove or Clear Data [Solved/Closed]
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...
-
enter data to run command button [Closed]
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...
-
Multiple If in Data Validation [Solved/Closed]
Hello, Its being requested please help in the below multiple IF function used in Data Validation =IF(ISNUMBER(E2),AND(E2>0,E2
-
formula - if (text), "text" [Closed]
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...
-
Lookup Functions [Closed]
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...
-
Conditional Formatting of one based on the other cell. [Closed]
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...
-
Conditional copy of cells with corresponding values [Solved/Closed]
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 ...
-
Conditional Formatting of one cell based on the other cell. [Closed]
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...
-
Count formula (need help) [Solved/Closed]
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...
-
Using IF function with dates [Solved/Closed]
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 ...
-
Windows 7 Excel 2013 Jump Lists [Closed]
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...
-
Compare three columns in three sheets [Closed]
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. ...
-
Highest Value Between 3 Sheets [Closed]
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 ...
-
Insert a row below a given cell of a table [Closed]
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...
-
Finding the last used Column [Closed]
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 ...
-
Macros editing [Solved/Closed]
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...
-
how to create a macro to find the value in specified cell [Closed]
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...
-
Formullas [Closed]
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 ....
-
VBA to protect cell in excel [Closed]
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...
-
search and extract up to 10 lots of 46 sequential cells [Closed]
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...
-
refer only one column from named range [Solved/Closed]
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...
-
I need to copy 3 cells into one cell [Closed]
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...
-
Conditional Formatting in a vlookup [Closed]
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...
-
Trying to Copy from sheet all values to another sheet [Closed]
Hello, I am trying to Copy from sheet's all values to another sheet. But its not coping with their cells formate.
-
compare two columns with another two columns and return [Closed]
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...
-
Find a word based on # and copy word to another cell [Closed]
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: ...
-
Excel formula logic operator greater then and less then [Closed]
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...
-
data transferred from macro [Closed]
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...
-
Macro Editing [Closed]
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...
Subscribe To Our Newsletter!
