Excel Forum

Ask a question
Results 1151 - 1200 of about 9,840
  • Require macro or logic in Excel Closed

    Hi i am looking for solution refer attached excel snapshot need to call or create predefined series in column by entering single value in cell ...

    vijayrsable | Latest reply: vijayrsable Jul 8, 2017
    0 replies
  • Need to compare data on the work book by giving deferent colour Closed

    Hi There are columns in a workbook with numbers in various cells. I want to compare values in each column with the previous column. Cell b1 should...

    ganesh7nadar | Latest reply: ganesh7nadar Jul 8, 2017
    0 replies
  • Script is really slow and sometimes crashes Solved/Closed

    Hi, My script is really slow and sometimes crashes when there's too many rows. Can someone help me figure out how to make it faster? Dim b A...

    josh07429 | Latest reply: vcoolio Jul 7, 2017
    5 replies
  • Need VBA Macros to copy specific data based on condition Closed

    Suppose I file A which contains yearly data which we update on daily basis. lets say File A contains the data for year 2017 with following columns. ...

    sayureepreeti | Latest reply: ac3mark Jul 7, 2017
    1 reply
  • Compare five Excel workbooks and copying matched data to new one Closed

    I'm trying to compare five workbooks in excel and have matching column data copy the entire rows into a new workbook (ReportWorkBook). Ex: Compare ...

    net1media | Latest reply: net1media Jul 6, 2017
    0 replies
  • Help required to apply IF formula Closed

    Hello, I need a favor to add multiple if formulas for below conditions Column A Column B Column C Result Transactions ...

    hksanthosh | Latest reply: hksanthosh Jul 6, 2017
    0 replies
  • Need Help Creating a Formula for EXCEL Closed

    I'm not too familiar with excel, i'm trying to start a small home business and i'm creating invoices using excel. I need help with a formula that woul...

    five2588 | Latest reply: five2588 Jul 5, 2017
    3 replies
  • Colour excel cell based on Regional Post Code Closed

    I want the cell colour to change based on the Regional Post Code I have used in segmenting the UK. It's my own project.

    Geofi | Latest reply: ac3mark Jul 5, 2017
    1 reply
  • Formula Help Closed

    Hi Friends- I am trying to generate a formula to help simplify a project I am working on. Here is what I am trying to come up with: I have a col...

    aponce11 | Latest reply: aponce11 Jul 5, 2017
    0 replies
  • Need help with script or formula Solved/Closed

    Column A shows "Date" while column B shows "Passenger #" I want to Copy and paste the Passenger # to Column C "Total Passenger" The problem is I o...

    josh07429 | Latest reply: josh07429 Jul 5, 2017
    5 replies
  • Loop A1 value based on columns with value Closed

    Hi guys, hoping you can help me achieve what I want to display in MS excel 2013. What I have is this What I want to achieve is this Pleas...

    krbymntj | Latest reply: krbymntj Jul 4, 2017
    0 replies
  • Matching cells but exclude blanks Solved/Closed

    Hello, I am trying an "IF" formula to see if A1 matches B1 and if so I want to return C1 but if the two cell are blank its working I want to exclud...

    Tom9o | Latest reply: Hira Jul 4, 2017
    11 replies
  • Need macro coding for find, copy, and paste Closed

    Hi Friends, I need a macro coding for the below example. In sheet 1 I have extracted webpage results like profile page it includes (Quality s...

    redspura | Latest reply: redspura Jul 3, 2017
    0 replies
  • VBA Code for adding sheet from range specified in another sheet Closed

    Hi Everyone, I am not well versed with VBA. I m looking a code if any one can help. I have a fixed template in sheet"4" which contains the name o...

    hitrus87 | Latest reply: hitrus87 Jul 3, 2017
    6 replies
  • Macro for specific worksheets Closed

    Hi, I would like to hide and unhide specific rows by one toggle button in multiple worksheets. Could someone help me with specifiyng the macro? I ...

    Elise_123 | Latest reply: Elise_123 Jul 3, 2017
    0 replies
  • Macro to compare cells in a table and populate max value Closed

    Hi all! Hope you can help me out, :-D I have a Table in Excel (nicely named Table1) and it's full of data which cannot be sorted or columns in ...

    vdmarel | Latest reply: vdmarel Jul 2, 2017
    0 replies
  • How to remove links at once from all excel files in a folder Closed

    Hi friends, I have a folder having number of excel files say like 100 files and each having copy links from other files. Can I able to remove link...

    salimckm | Latest reply: salimckm Jul 1, 2017
    0 replies
  • Rounding up time Solved/Closed

    Hi, Im having a problem on rounding up time, I've use =mround(A1,"1:00") it works fine on dates and time like this "5/2/2017 7:01 AM" but whe...

    josh07429 | Latest reply: nickname missing Jun 30, 2017
    1 reply
  • Match and Paste Closed

    Hello, I have two spreadsheets that have two columns that are similar and a third column that is only correct on the 2nd worksheet. Example ...

    Radjolt | Latest reply: Radjolt Jun 30, 2017
    0 replies
  • Automatically transfer data Closed

    Hello, I am facing problem to make an excel sheet in which i want entry in a cell of sheet 1st automatically should be transferred into 2nd sheet ...

    bablu singh | Latest reply: bablu singh Jun 30, 2017
    0 replies
  • Adding formulas Closed

    Hi guys need help with some formulas I am currently trying to combine. the Rules is 1. If there is a "Form submitted" in the day I have to copy wh...

    josh07429 | Latest reply: ac3mark Jun 29, 2017
    1 reply
  • Automatically copying columns from one work book to another. Closed

    Please I need assistance with a problem I've struggled with for quite awhile. If I could write code I'm sure it would be quiete easy. My issue is: I...

    Eqgoddess | Latest reply: vcoolio Jun 28, 2017
    1 reply
  • Graphing student data Closed

    As a tech teacher, I run typing reports on my students each day/week. Each report is saved as a worksheet in a quarter workbook. The list of student ...

    Leitzel83 | Latest reply: ac3mark Jun 28, 2017
    1 reply
  • VBA compile Error: Do without Loop Solved/Closed

    Hello, So I modfied this code from an CCM post. I have Do I have an End IF Why am I getting the Error? This query is copying data from s...

    Arisfish | Latest reply: ac3mark Jun 28, 2017
    1 reply
  • Inserting pictures from a file name that is made from 3 cells Closed

    I am looking for a macro to insert all of the pictures from a folder who's address is derived from multiple cells. Picture location is as follows: ...

    Ritna | Latest reply: ac3mark Jun 28, 2017
    3 replies
  • Excel formula help Closed

    Hi guys need help with some formulas I am currently trying to combine. the Rules is 1. If there is a "Form submitted" in the day I have to cop...

    josh07429 | Latest reply: josh07429 Jun 27, 2017
    0 replies
  • Sorting the highest value with dates Closed

    Need help with formula or script Where I need to look for the Van's highest Passenger# with the latest month available for example van 800's l...

    josh07429 | Latest reply: ac3mark Jun 27, 2017
    6 replies
  • Conditionally copy col values from one sheet to master sheet Closed

    I have 3 workssheets, Master , Billing and EA.I'm trying 2 diff things: 1. update the master sheet when either of the Offer or EA sheets are updated/...

    avittal | Latest reply: hitrus87 Jun 27, 2017
    9 replies
  • Compare of two column Closed

    I have 2 columns column a have unique record in repetition and in column b I have non unique values ...now what I want ...I want to place the remark...

    dev_raghav1982 | Latest reply: TrowaD Jun 27, 2017
    1 reply
  • Dates in Excel are all mixed up and won't convert Closed

    Hi, I downloaded some data from my bank for some transactions. Using MS Excel 2008 V 12.2 on a Imac 2015 I usually convert the dates to YYYY-MM-...

    stuey | Latest reply: TrowaD Jun 27, 2017
    1 reply
  • Help creating a VBA macro Closed

    Hi - I just started a new job and I'm trying to create a VBA macro to automatically run for the P&L template I put together (smartview) using somethin...

    drevere | Latest reply: drevere Jun 26, 2017
    0 replies
  • Problem with script in Excel Solved/Closed

    Hello, I have a problem with my script. What I want is IF the value in column J is equals to "0" then I want the column H to be blank. Ex. J1 ...

    josh07429 | Latest reply: josh07429 Jun 26, 2017
    6 replies
  • Conditional formatting rule Closed

    I was wondering if anyone could help me to set up a conditional formatting rule for a cell that may contain any text that has not already been specifi...

    Almunda | Latest reply: Mazzaropi Jun 26, 2017
    3 replies
  • MACRO to split data into multiple sheet Closed

    I have a data sheet with below columns, would like a macro to split data into each tab according to cardholder_name if this is possible Cardholder_...

    kittyluting22 | Latest reply: TrowaD Jun 26, 2017
    1 reply
  • Auto copy excel cells to my systems Closed

    Hello, This Lim, can i have some help to solve "manual things" problems? This is my excel worksheet (contains orders numbers) Everyday I...

    kohlim | Latest reply: TrowaD Jun 26, 2017
    1 reply
  • Cell colour containing specific info Solved/Closed

    Hi, I am currently using Microsoft Office Excel 2016. I am busy doing a spread sheet for work and need to know how to change a cell colour if a differ...

    JohannGC | Latest reply: JohannGC Jun 23, 2017
    6 replies
  • Validate copied data in excel Solved/Closed

    Hi, I have a below scenario one row is copied and pasted, this pasted row needs data validation such that total of each cell shouldn't exceed the r...

    chint99 | Latest reply: chint99 Jun 22, 2017
    2 replies
  • Formula to find matching IP values in two sheets Closed

    I really need help figuring out this issue that I am not too sure that actually has a solution. I have two separate spreadsheets (lets call them "s...

    c4rn3v1l | Latest reply: vcoolio Jun 22, 2017
    5 replies
  • Automatic Macro required to copy and paste Closed

    Dear Sir, I have one excel sheet where all data is save from A1 to F46 Cell. I want to copy this data from A1:A46 and paste it into new excel Shee...

    Madhav_147 | Latest reply: Madhav_147 Jun 21, 2017
    0 replies
  • Multiple worksheet data input Solved/Closed

    hi TrowaD, I am an on the job trainee at a company, i was ask to encode data from our furnace but its too much time consuming for me to encode all...

    vintacu | Latest reply: vintacu Jun 20, 2017
    2 replies
  • Conditional format based on text in same row Solved/Closed

    Hi all, New to this forum. I'm running Excel 2016 on Win7 -- my spreadsheet has results of inspections in columns E, G, and J. The possible valu...

    joshcamp | Latest reply: Mazzaropi Jun 20, 2017
    3 replies
  • Excel Monthly and Daily sheets Closed

    Hello, Hi, I have an excel worksheet we use for daily retail business paperwork. It has 3 sheets with Daily Toatals, monthly Totals and Yearly Tot...

    Waseem | Latest reply: TrowaD Jun 20, 2017
    1 reply
  • How to manage hours and rounding in Excel Solved/Closed

    Hello, I need to know how to add a function to a cell in which I have figured a days hours worked with a lunch. The current formula is =(C7-B7)+(E...

    Theresa | Latest reply: Theresa Jun 19, 2017
    2 replies
  • How to Compare two workbooks and see if data has moved or not? Closed

    Hello, I would like to preface this by saying thank you in advance. I'm interning and one of my superiors has asked me to compare workbooks These ...

    hoosier1851 | Latest reply: TrowaD Jun 19, 2017
    1 reply
  • Autopopulate sheets from summary page Closed

    Hi, I know this question has been asked in varying forms on here and I tried to modify the macros presented to work for my particular spreadsheet b...

    cmarie88 | Latest reply: TrowaD Jun 19, 2017
    1 reply
  • Make a shared file that can store data for the whole year Closed

    how can I make a shared file that can store data for the whole year and you can select the file for a specific month, day, and year? Using Macros. or ...

    adejesus | Latest reply: TrowaD Jun 19, 2017
    1 reply
  • Find out values difference between 2 excel sheet Closed

    Hello, Dear Friends, I have facing a big problem in my generate billing per month because i have 2 excel sheet 1st one create manually (Manua...

    FirstLog | Latest reply: TrowaD Jun 19, 2017
    1 reply
  • How to set up multiple taxes inclusive formula in Excel Closed

    I have a reverse calculation problem- Lets say the price of an item is $10.00 with two taxes @ 10% and 20%. Now to calculate the inclusive tax amoun...

    Bucks. | Latest reply: U Know Me Jun 17, 2017
    3 replies
  • excel error Closed

    Hello, hi, This is dinesh from axis bank employee i get the result when type for date formet like 5-june in 20206 somebody help me. Syst...

    dinesh0170 | Latest reply: dinesh0170 Jun 17, 2017
    0 replies
  • Workbook to track subcontractor invoices and payments Closed

    Hi i need some help with a workbook im working on and i cant figure out how or if what i want to do can be done. the workbook is to track subcontra...

    Vanhardy | Latest reply: vcoolio Jun 16, 2017
    1 reply