Excel Forum

Ask a question
Results 1051 - 1100 of about 9,840
  • Search for input criteria, return designated cells. Solved/Closed

    Hey all, I am trying to write a VBA command/macro that essentially takes a criteria input from the destination worksheet, searches and matches the ...

    crlarus | Latest reply: vcoolio Aug 19, 2017
    12 replies
  • Inserting and formating date with userform Closed

    Hello, I am trying to Insert a date with a Textbox in a Userform. It should have this format: Friday, 18.08.2017. This entered Date is used...

    Scencea | Latest reply: ac3mark Aug 18, 2017
    1 reply
  • Copying dates to another worksheet. Solved/Closed

    Hello, I found this script from vcoolio, thanks for that! Sub Advise() Dim x As Integer Dim lRow As LonglRow = Range("E" & Rows.Count...

    Scencea | Latest reply: vcoolio Aug 17, 2017
    12 replies
  • How to convert numeric into words in Excel Closed

    What is the formula to convert numeric in words?

    Sanjeev.me | Latest reply: ac3mark Aug 17, 2017
    1 reply
  • Excel formula - Add days to date based on drop down selection Solved/Closed

    I want to add days to a date based on options selected from a drop down list. For example, if cell C5 reflects "New Hire" or "Post New Hire", I want ...

    Sabernethy | Latest reply: Mazzaropi Aug 17, 2017
    3 replies
  • Comparing Two Excel Sheets and copying like data to third sheet Closed

    Hi, In your below coding, I can copy paste the alike data from sheet 1 only, I need to copy paste both from sheet 1 and sheet 2 line by line matchi...

    jvignesh07 | Latest reply: ac3mark Aug 16, 2017
    1 reply
  • VBA: Cell Range Closed

    Hello, I am a beginner with VBA and I have a question that might sounds stupid to some. I have created a function of IfElseIf and I want to run it...

    shellboy | Latest reply: ac3mark Aug 16, 2017
    3 replies
  • Search for text , cut and paste into new work sheet Closed

    Hi , can anyone help me with the below vba code : Logic Find text If next row starts with number Then - cut 1 row above text and 3 rows below ...

    JoeRooney | Latest reply: JoeRooney Aug 16, 2017
    1 reply
  • Dropdown menu disappears quickly before you can even choose Closed

    My excel has been acting weird lately. All dropdown menu disappears quickly before you can even choose your choices. This happens in Data Filter fun...

    rsa10 | Latest reply: rsa10 Aug 16, 2017
    0 replies
  • Transfer data from one sheet to another Closed

    Hello, i have started an inventory sheet on excel what I want to do is take the list of inventory and when it is sold, have it transfer to the second ...

    Thanks for t... | Latest reply: themorgan Aug 15, 2017
    2 replies
  • How to compare two excel sheets and combine matching data Closed

    Hello, I'm looking for a macro that will match data in column A from sheet 1 to the data in column A from sheet 2 and copy the corresponding rows f...

    jfitz | Latest reply: vcoolio Aug 15, 2017
    1 reply
  • Generate new workbooks based on column value from multiple works Closed

    I am a beginner in VBA. Basically I need a code that generates a new workbook for each specific column value in multiple sheets. The key in each sheet...

    TheBeginner | Latest reply: TheBeginner Aug 14, 2017
    0 replies
  • How to auto-populate values from certain cells into a new sheet Solved/Closed

    Hello guys, Hope everyones doing okay. I've been working on a billing sheet for a company with multiple product codes and rates etc to be pulled f...

    Roadknee | Latest reply: vcoolio Aug 12, 2017
    18 replies
  • Copy and Paste entire row if a specific cell agrees with if cond Closed

    Hello guys! I have been writing a vba code for a while and I cant find the mistake that I am making... I have a big table and I am comparing the va...

    PeriGr | Latest reply: PeriGr Aug 12, 2017
    13 replies
  • Date entered wrongly Closed

    Hello, I entered dates as 'Apr 24' wherein I meant 24th of April..Excel has taken it to be '01 April 2024'..how do I correct all such entries, if ...

    ANJU BIDASARIA | Latest reply: ac3mark Aug 11, 2017
    1 reply
  • How to highlight a row when I enter a date in column I Closed

    Hello, I am trying to highlight a row when I enter a date in column I. How is this achieved?

    renapearl | Latest reply: ac3mark Aug 11, 2017
    1 reply
  • Copy Specific number of rows and insert n time after 3 rows Closed

    Hello, Please help I want to Select & copy 35 rows data and after 3 rows I want to insert the copied rows n number of times. I need the Row widt...

    manishercv | Latest reply: ac3mark Aug 11, 2017
    1 reply
  • Transfer data Closed

    I have an excel spread sheet that has columns for last name, first name, office locations, and date. I may have 10 items listed in the column locatio...

    Jojo537 | Latest reply: Jojo537 Aug 11, 2017
    0 replies
  • Highlight only one column which has greater value Solved/Closed

    Hello, i am inputting numbers in column A , B , C and D so i wanna highlight only one column which has greater value from others. is there any pos...

    Awais Munir | Latest reply: Mazzaropi Aug 11, 2017
    3 replies
  • Using macro beta Closed

    Hello All, Looking for a help here. Below is the data I am putting for understanding-- Column- A B C D E F G Row 1 - ...

    Deepak | Latest reply: Deepak Aug 10, 2017
    0 replies
  • Spellling error in Excel Closed

    Hi Friends 1st, i want to say sorry for my broken english 2nd Did any one noticed what is resulf if you have only 00.50 Cent and your Spell num co...

    Siddique91 | Latest reply: Siddique91 Aug 10, 2017
    0 replies
  • Multiple data types in Excel Closed

    Hello, I had a group of members contains in 4 fields and all these are enter into one simple format (example certificates) which is seperate works...

    Sateesh | Latest reply: Sateesh Aug 10, 2017
    0 replies
  • Date conversion in Excel Closed

    Hello, how to convert birth date in word in MIcrosoft excel

    Nasim Shaikh | Latest reply: xpcman Aug 9, 2017
    1 reply
  • Consolidate data from multiple sheets to one sheet. Closed

    Hello, I have a workbook containing customer data (name, contact #s, addresses, etc.). The workbook is broken down into sheets according to which ...

    Chelseybell | Latest reply: vcoolio Aug 9, 2017
    3 replies
  • Unprotect VBA project with a macro Closed

    How can I unprotect a Excel Book VbaProject with code VBA (I know the protection password)

    isabel_duque | Latest reply: isabel_duque Aug 8, 2017
    0 replies
  • Auto update hyperlink on the other sheet Closed

    Hello guys =) Please help... I have a sheet with names and IDs which are in hyperlink and the same data i have also in the other sheet. If the I...

    eunice3301 | Latest reply: eunice3301 Aug 8, 2017
    3 replies
  • Automate transfer data from masterfile to another sheet Closed

    Dear All, Hope you guys are doing well. I am not an expect in excel, I really hope you guys can provide me some sort helps/advise/how to automat...

    CanCanKen | Latest reply: CanCanKen Aug 7, 2017
    0 replies
  • Transfer rows to another sheet via color or letters of row Closed

    the Excel sheet has information pertaining to record numbers. I check numeric record from a database and see if they are correct. if the information i...

    RobertVbarrise | Latest reply: RobertVbarrise Aug 7, 2017
    0 replies
  • Formula cell value change Closed

    Hello, I have 2 columns..... say A & B If I type "Approved" in Column B1, then A1 should automatically change to "COMPLETED" If I type any ...

    max | Latest reply: max Aug 6, 2017
    0 replies
  • Reminder by cell flashing /blinking Closed

    Hello, Hi! I have a trouble call log. This is what I want to do.... Have a cell (or row of cells) flash or blink at a specific time from when...

    pooter | Latest reply: pooter Aug 5, 2017
    0 replies
  • Excel if statement with multiple text values in a column Closed

    Hello, I am using excel 2017. I am trying to use this if statement to give me a value of 1 or 0. =IF((CQ2="Computer");1;0) The problem i...

    hnew16 | Latest reply: Mazzaropi Aug 5, 2017
    1 reply
  • Changing format of date in Excel Closed

    Hello, Good morning, please I have a question. Question: Want to make use of a function such that with a date ( e.g 2/1/2017 formatted to b...

    Big Joe | Latest reply: Big Joe Aug 5, 2017
    0 replies
  • Excel 2016 filters do not work Closed

    Hello, My filter stopped working in 2016. It is completely inactive - doesn't show any other option only the one it froze on. In the menu the filt...

    PetraT | Latest reply: ac3mark Aug 4, 2017
    1 reply
  • VBA code to range of days Closed

    Hello, Please help guys... I have a code below: Sub Auto_Open() Dim r As Long For r = 2 To 53 If Range("I" & r).Value = Range("I...

    eunice3301 | Latest reply: ac3mark Aug 3, 2017
    4 replies
  • Copy full row in Excel Closed

    Hello, I want ti copy full row for example B2:H2 if cell L1 is having text "unlisted". Please help

    Shobhit | Latest reply: Shobhit Aug 2, 2017
    0 replies
  • Conditional formatting Closed

    Hello, If I have a value on one cell "D3"of let's say "2" and in cell F3 a value of let's say "1" then I want cell G3 to say a text, let's say "Good"...

    KingFloyd | Latest reply: Mazzaropi Aug 1, 2017
    3 replies
  • VBA Worksheet data transfer Closed

    hello, I haven't done anything with code for years and I am so lost in this, I have a table on sheet 1 which goes from A-J and 1-8221 and conta...

    unhappydoughnut | Latest reply: Unhappydoughnut Aug 1, 2017
    5 replies
  • Run all vba at once after opening excel file Closed

    Hello, Please help me. I want to run the macros at once after opening the excel file. I have different codes in each sheet. Please i need yo...

    eunice3301 | Latest reply: eunice3301 Aug 1, 2017
    2 replies
  • Looking up 2 columns and displaying 3rd column on new sheet Closed

    I am trying to figure out how to display the color onto a second worksheet. If column a=1 AND column b=1, then I want the value of C2 displayed on...

    mikequick | Latest reply: ac3mark Jul 31, 2017
    1 reply
  • VBA for birthday message box alert Closed

    Hello, Please help me. I am very new in vba. i have no idea how to create codes. I have names in in column b and birth dates in column c. I need...

    eunice3301 | Latest reply: eunice3301 Jul 31, 2017
    0 replies
  • Run a Macro only for specific cells Closed

    Hello, can you please help me with one problem I am currently having with Excel Macro? I want to be able to run a macro only for specific cells .....

    PeriGr | Latest reply: PeriGr Jul 31, 2017
    2 replies
  • How to repair xlsx Excel 2010 Microsoft file? Closed

    Hello, How to repair xlsx Excel 2010 Microsoft file? I see a file with non-zero size but cannot open it. System Configuration: Windows / Chrome...

    jeanrichard17 | Latest reply: Priyanka Jul 31, 2017
    2 replies
  • Enter data into a master sheet to update subsequent sheets. Closed

    I'd like to be able to enter data into a master spreadsheet which will update other spreadsheets to prevent me from having to enter the same data seve...

    Lrc1 | Latest reply: vcoolio Jul 30, 2017
    1 reply
  • lookup unique text values with criteria Closed

    Hello, Data as follows cheque date tr code amount realised on 1/Jan/2011 164845 1000 1/Jan/2011 1/Jan/2011 154375 2000 1/Jan/2011 1/...

    Sandesh007 | Latest reply: Sandesh007 Jul 29, 2017
    0 replies
  • Search and code Closed

    Hello, so I have this problem in excel where I need to compare the words that are in a certain cell and compare them to the separated word if it finds...

    Ireh666 | Latest reply: stankirsolkar Jul 28, 2017
    4 replies
  • Macro Code Help - Copy Row Based on Criteria Paste on One Sheet Closed

    Hello, I have a spreadsheet that is tracking sales number from multiple sales people. Each person has their own tab & all the columns are the same...

    sillybear | Latest reply: ac3mark Jul 28, 2017
    1 reply
  • Auto populating data Closed

    Hello, i have to daily update supplier name, part name , part number to my daily list . i want it to auto populate this to all my master-sheet , i ...

    venktesh | Latest reply: ac3mark Jul 28, 2017
    1 reply
  • Formulas Closed

    I know the basic but I am trying to formulate cells that will automatically that when you enter a figure in the cell it will multiply that said number...

    donnawatson | Latest reply: ac3mark Jul 28, 2017
    3 replies
  • Automatically insert rows in associated spread sheets Closed

    Hello, I have created an accounting workbook of 15 sheets to produce accounts and associated information for a group of around 85 people. The names...

    ManxEd | Latest reply: ManxEd Jul 28, 2017
    2 replies
  • Formatting a cell containing text Closed

    I have a task tracker where once the task is completed and the 'hasten' cell is 'yes' then I want the entire row to be formatted so the text within th...

    markyprest | Latest reply: stankirsolkar Jul 28, 2017
    1 reply