Excel Forum

Ask a question
Search
Close
Results 3101 - 3150 of about 9,830
  • Copying Conditional Formatting to Several Cells Then Editing Closed

    I'll start off by saying I am a novice (at best) when it comes to using Excel. WHile I have figured out some things I am sure I am probably not doing ...

    CKJ | Latest reply: CKJ Nov 13, 2015
    0 replies
  • Excel: If Date =, then enter a value Solved/Closed

    I am using this formula and it works well: =IF(A8=DATE(2015,3,27),"1","--") How do I now create a string to check a number of dates (company holid...

    JerrySD | Latest reply: BrianGreen Nov 13, 2015
    4 replies
  • Auto Copy based on Condition Closed

    Hello, I have developed an Auditing sheet in Excel in which the results are copied into a Word document to create an audit summary report. How d...

    Tara | Latest reply: Tara Nov 13, 2015
    0 replies
  • Adding two non-adjacent cells (number and text) Solved/Closed

    Hello, I seem to be having a problem with a nested IF(statement) I am on a separate worksheet that I use to calculate my formulas for my summary page....

    dkayeh1 | Latest reply: dkayeh1 Nov 13, 2015
    8 replies
  • Connecting Excel database to the company's website Closed

    Hello everyone and thank you for any help on this problem that I have. My boss just asked me to connect the excel database I am finishing up on cre...

    dkayeh1 | Latest reply: xpcman Nov 12, 2015
    1 reply
  • Drawback of Copy and Clear code Solved/Closed

    Hello, I have requested that please solve this issued if it could be solved. I have found major drawback (May be I am wrong) in the code of Copy ...

    smuneeb | Latest reply: smuneeb Nov 12, 2015
    2 replies
  • Macro to create list from master sheet Closed

    Hi! I need to create a macro that will generate individual lists for employees based off a master sheet. on my master sheet (that is what the sheet...

    needshelp | Latest reply: TrowaD Nov 12, 2015
    1 reply
  • changing a frequency into a list Closed

    Hello, I have a list of names and numbers and I would like the list in full i.e. jane 4 chris 2 result jane jane jane jane chris chri...

    jane | Latest reply: jane Nov 12, 2015
    0 replies
  • Dynamic Hyperlinks Closed

    Hello, I'm currently working on a spreadsheet which has links to external files for example A1 - link 1 - file1.pdf A2 - link 2 - file2.pdf A3 - li...

    nathan | Latest reply: nathan Nov 12, 2015
    0 replies
  • how to copy a data of a workbook to another work book Closed

    Dear All, i have a folder namelly dealer1 which is having 20 excel file & each excel files containing 10 sheets, now i want to copy all the exc...

    soubhagya | Latest reply: soubhagya Nov 12, 2015
    0 replies
  • 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 ...

    Dawn | Latest reply: vcoolio Nov 11, 2015
    1 reply
  • 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

    musharafpk | Latest reply: vcoolio Nov 11, 2015
    5 replies
  • 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...

    akroncantont... | Latest reply: akroncantonterriers Nov 11, 2015
    0 replies
  • 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...

    solomon | Latest reply: rizvisa1 Nov 11, 2015
    1 reply
  • 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 ...

    RPJ | Latest reply: rizvisa1 Nov 11, 2015
    1 reply
  • 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...

    Grainne | Latest reply: rizvisa1 Nov 11, 2015
    1 reply
  • 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...

    Christy | Latest reply: ac3mark Nov 10, 2015
    5 replies
  • 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 [...

    DonJuan | Latest reply: rizvisa1 Nov 10, 2015
    1 reply
  • 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...

    smuneeb | Latest reply: smuneeb Nov 10, 2015
    2 replies
  • 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...

    mamagiglio | Latest reply: mamagiglio Nov 10, 2015
    2 replies
  • 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...

    saemmt | Latest reply: rizvisa1 Nov 10, 2015
    1 reply
  • 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...

    Erin | Latest reply: rizvisa1 Nov 10, 2015
    1 reply
  • 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...

    Samratprincy | Latest reply: Samratprincy Nov 9, 2015
    0 replies
  • 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...

    smuneeb | Latest reply: smuneeb Nov 9, 2015
    5 replies
  • 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...

    dkayeh1 | Latest reply: rizvisa1 Nov 9, 2015
    5 replies
  • 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...

    smuneeb | Latest reply: smuneeb Nov 9, 2015
    6 replies
  • 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 ...

    smuneeb | Latest reply: rizvisa1 Nov 9, 2015
    3 replies
  • 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...

    Rich | Latest reply: rizvisa1 Nov 9, 2015
    5 replies
  • 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...

    polyrhythm | Latest reply: nahidule Nov 9, 2015
    2 replies
  • 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...

    rash | Latest reply: rash Nov 7, 2015
    6 replies
  • 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 ...

    Monique S | Latest reply: Monique S Nov 6, 2015
    0 replies
  • 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...

    smuneeb | Latest reply: smuneeb Nov 6, 2015
    10 replies
  • 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...

    andjan | Latest reply: rizvisa1 Nov 6, 2015
    1 reply
  • 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

    smuneeb | Latest reply: smuneeb Nov 6, 2015
    3 replies
  • 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...

    bmc | Latest reply: rizvisa1 Nov 5, 2015
    1 reply
  • 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...

    Art_Vandelay | Latest reply: TrowaD Nov 5, 2015
    1 reply
  • 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...

    Dimi | Latest reply: TrowaD Nov 5, 2015
    4 replies
  • 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 ...

    DR999 | Latest reply: DR999 Nov 5, 2015
    2 replies
  • 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...

    Dmitry | Latest reply: nogapok1 Nov 5, 2015
    2 replies
  • 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...

    dkayeh1 | Latest reply: RayH Nov 4, 2015
    1 reply
  • 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 ...

    dkayeh1 | Latest reply: RayH Nov 4, 2015
    18 replies
  • 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...

    Sandy | Latest reply: Sandy Nov 4, 2015
    4 replies
  • 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. ...

    Summer | Latest reply: rizvisa1 Nov 4, 2015
    1 reply
  • 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 ...

    mandylynn4 | Latest reply: mandylynn4 Nov 3, 2015
    0 replies
  • 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...

    om_rod | Latest reply: rizvisa1 Nov 3, 2015
    1 reply
  • 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 ...

    Al | Latest reply: Rayh Nov 3, 2015
    8 replies
  • 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...

    jimmi_10 | Latest reply: rizvisa1 Nov 3, 2015
    1 reply
  • 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...

    prashanth | Latest reply: rizvisa1 Nov 3, 2015
    1 reply
  • 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 ....

    Jawharjavaid | Latest reply: TrowaD Nov 3, 2015
    1 reply
  • 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...

    hemu | Latest reply: TrowaD Nov 3, 2015
    1 reply