Excel Forum

Ask a question
Results 1701 - 1750 of about 9,840
  • Auto copy and paste cell range to a separate sheet Solved/Closed

    Hello, I am new to VBA/Macro with excel, but I want my code to automatically copy a range of cells in the same row that a change is made in a particu...

    bnoboa | Latest reply: bnoboa Dec 30, 2016
    4 replies
  • Need to create multiple tabs based on data in table Solved/Closed

    Good Afternoon, I'm trying to find a way to automate a few things to save some time: -Use the data in an input tab to create multiple tabs/documents...

    Kylana | Latest reply: vcoolio Dec 29, 2016
    6 replies
  • Copy cell from a column into multiple worksheets Closed

    Good Afternoon! I've got a column of data (Months) that I need to insert into a cell in multiple worksheets. I know if it was within one worksheet...

    KylanaG | Latest reply: KylanaG Dec 28, 2016
    0 replies
  • Return Value in Cell Address Closed

    Hello, I'm having an issue returning the value cell A32. I have "A32" stored in cell H3 (it was a long drawn out process to isolate the "A32" that i...

    Pluh | Latest reply: Mazzaropi Dec 28, 2016
    1 reply
  • Compare Data Closed

    Hello, I am working on ware house. We have different code for every material which was on system. Every month I need to take physical stock. I need ...

    crazybadri | Latest reply: Mazzaropi Dec 28, 2016
    5 replies
  • How To Copy Data Between Several Sheets using another sheet Closed

    Hi All, I have a requirement to copy the data from source to target using macro excel file name: Testbook1 Source sheets Target sheets Test_Src1...

    naresh117 | Latest reply: naresh117 Dec 28, 2016
    0 replies
  • how to delete misline rows one worksheet by using macro Closed

    Hello, how to delete misline cloums by using macro plz give me code.i hoping you give me answer.

    naveen | Latest reply: naveen Dec 28, 2016
    0 replies
  • Copy a range of cell x number of times Closed

    Hello, Friend my query is I want to copy value from range (E1:F1) Base on the value from G1 And paste on range from A1&B1. It should continue ...

    Jai | Latest reply: ac3mark Dec 27, 2016
    1 reply
  • transferring data from one sheet to another in Excel Closed

    I followed the instructions for transferring data between Excel spreadsheets using the +Sheet(X)!((XY) formula. So glad I found your article! This w...

    KKunard | Latest reply: vcoolio Dec 27, 2016
    2 replies
  • Excel changes field format from date to text when date entered. Closed

    I have an Excel worksheet that has a variety of formula's and conditional formating in it. There are four different date formated columns in the spre...

    dbjerke | Latest reply: dbjerke Dec 27, 2016
    0 replies
  • Popup Reminder Excel 2010 Closed

    I am completely new to VBA and do not really know how to manipulate a code. I was hoping someone would be willing to formulate the codes I need to i...

    mdeza81090 | Latest reply: vcoolio Dec 27, 2016
    1 reply
  • excel arrow keys are moving the entire spreadsheet Closed

    Hello, I'm working in Excel and my arrow keys are moving the entire spreadsheet and are not moving cell by cell up, down, right or left. I do no...

    kelvin | Latest reply: santa Dec 26, 2016
    1 reply
  • how to copy row to several sheets based on cell value Closed

    Hi Ladies and Gents i really hope i can get some help here and your patience and support is highly apreciated. i have a daily tracker for all daily ...

    MO | Latest reply: MO Dec 26, 2016
    0 replies
  • Find what is the number, that will make 2 cells ABS equal Closed

    Hey guys, I will appreciate your help on this. I'm trading on CFD's and trying to build something that will help me calculate different scenarios. ...

    albertask | Latest reply: yg_be Dec 25, 2016
    3 replies
  • Comparing and scoring 2 workbooks for students quiz Closed

    Hi all I am teaching students basic Excel skills and they have a quiz to do where they do certain basic tasks on a spreadsheet. I have a workbook wi...

    harryarnold | Latest reply: harryarnold Dec 25, 2016
    0 replies
  • function in excel 2013 Solved/Closed

    Hello Dear All. who I can do this function in excel 2013 If A2=AB return value from A1 cell , if A2 = CD return from A3 cell value Configuration: W...

    Saber Elajam | Latest reply: yg_be Dec 24, 2016
    1 reply
  • find what is the number, that will make 2 cells ABS equal Closed

    Hey guys, I'm trading on CFD's and trying to build something that will help me calculate different scenarios. As you can see on the file attached, I...

    albertask | Latest reply: albertask Dec 24, 2016
    0 replies
  • sum if.. it think? Closed

    Hi, I have a column of cells that may contain either a 1 or 2 or.5 I need to add the column together and get a 1 to equal 15min, 2 to equal 25min a...

    Beckstar11 | Latest reply: Beckstar11 Dec 23, 2016
    0 replies
  • Copy all data from 2 worksheets into summary, excluding headings Closed

    Hello, I would like to automatically copy the entire rows of 2 different worksheets (excluding the top 3 header rows) into one complete summary work...

    MMEP | Latest reply: MMEP Dec 22, 2016
    0 replies
  • How to compare data between two worksheets, Closed

    Hi I have "sheet A", and "sheet B". I need to match the information in sheet A with sheet B and select the information needed from sheet B and writ...

    luislugosan | Latest reply: luislugosan Dec 22, 2016
    0 replies
  • macro to create a new sheet by copying a template from a list Closed

    i have two sheets one is "profile" and second is "template" . this second sheet has a defined layout. in the first sheet i.e profile sheet contains a...

    natarajk | Latest reply: natarajk Dec 22, 2016
    0 replies
  • creating different sheets in same workbook from master sheet Closed

    Hello, I have data in master sheet from Column A to Column L and about 17,000 rows. Column H contains the name of the sales persons. I have to cre...

    Nabeel | Latest reply: TrowaD Dec 22, 2016
    1 reply
  • how to spell in euro Closed

    Hello, Dear sir / Madam I apologise for my latest message. I need your help concerning the formula to spell in figures that is euro 7000. Which for...

    RAVIN | Latest reply: TrowaD Dec 22, 2016
    3 replies
  • Any faster version of the same code to handle 5000+ records Closed

    Hello, May i plz get a faster code for the same? currently for around 5000+ records this code takes around 10 minutes... i.e. Match all the cellva...

    upan275 | Latest reply: Smallman1 Dec 21, 2016
    15 replies
  • Moving information from one table to another Closed

    I need to move data from one table to another, then loop back through until all the information has been moved, I suck at vba code etc... can any...

    karlkeegan | Latest reply: ac3mark Dec 20, 2016
    3 replies
  • Automatic inserting a picture in a cell field Closed

    Hello, I have maybe big unsolved problem. My question is how automatically insert picture to cell field, for example B1:H40, on condition that cell ...

    Romique | Latest reply: Romique Dec 20, 2016
    0 replies
  • Auto populating from one excel sheet to another Closed

    Hello, Hi I am trying to figure out how I can have my employees names and department auto populate in another excel sheet once updated in the master...

    alenoir82 | Latest reply: TrowaD Dec 20, 2016
    1 reply
  • Cell format - COUNTIF then subtract from another cell Solved/Closed

    Hi, I have a spreadsheet with holidays on. I'm using =COUNTIF(D16:D380,"H") I want to then subtract this number from another cell - What do I need ...

    kieferschild | Latest reply: ac3mark Dec 20, 2016
    5 replies
  • markup price Closed

    Hello, I am trying to find a formula for that will show the mark up price of a product. Configuration: Windows / Chrome 55.0.2883.87

    patty | Latest reply: ac3mark Dec 19, 2016
    1 reply
  • Save Group of Reports as PDF Macro Closed

    Hello, I created a sheet that pulls from other sheets in my workbook to create a report. When one cell value is changed, the entire report on my mai...

    beckae | Latest reply: beckae Dec 19, 2016
    0 replies
  • excel macro; automatically add text to number in column Closed

    Hello, I am a newbie in excel macro's and I was wondering if anyone could help me. I want to write a macro who once I write a number in a cell of co...

    pldhrcel | Latest reply: TrowaD Dec 19, 2016
    1 reply
  • need help autopopulating from master list Closed

    Hello, I am building a budget and inventory tracking system for a landscape company. I have data that I import from a field service tracking software...

    dillon4477 | Latest reply: TrowaD Dec 19, 2016
    1 reply
  • Private Sub Worksheet_Change(ByVal Target As Range) Closed

    Hello, please do the needfull.. I am trying to run the below macro,but it is not running,can anyone help me on this please, Private Sub Worksheet_...

    sdfgh | Latest reply: TrowaD Dec 19, 2016
    1 reply
  • Auto copy info/charts from a master sheet to a second sheet Closed

    Hello, I'd appreciate if somebody could please point me in the right direction on this... I'm a sales/supervisor for a rough interior construction ...

    somemikeguy | Latest reply: TrowaD Dec 19, 2016
    1 reply
  • date format in Excel Closed

    Hello, i want to know that howcan I change the dateformat in excel 2007 worksheet if I want it like :- 25101990 please give formula & example

    Balaji Ladke | Latest reply: SinghAkash Dec 19, 2016
    1 reply
  • generate a serial number for events with dates Closed

    Helllo, I have a problem of generating a serial number from an event on the spreadsheet that has date of event and time, amount. how do i get the form...

    degree | Latest reply: degree101 Dec 18, 2016
    2 replies
  • Add a ammount on a certain date. Closed

    Hi, I`m trying to add my pension on a certain date each month to a spreadsheet cell. IF((DATE(2016,12, 22) ;then_value(528.08);otherwise_value(0)) ...

    ColinG | Latest reply: yg_be Dec 18, 2016
    1 reply
  • VLookup issue Closed

    Hello, Some time in excel i come across the issue that VLookup is not working between two excel sheets. Why it so happen? Pl. resolve the issue b'cz...

    Hardik | Latest reply: yg_be Dec 17, 2016
    1 reply
  • If/Then Formula Help Solved/Closed

    Hello, I could use some help on the formula below. I need cells in one column (Y) to show specific text ("SEND") if cells in another column (G) has ...

    MrJags | Latest reply: MrJags Dec 16, 2016
    2 replies
  • variable range in vba function formula Closed

    Hello, If i want to do this formula ((1/c1)^2+(1/c2)^2 .............................. + (1/c)^2 )^(-0.5) for variable range by ( vba fu...

    a_elgazar | Latest reply: yg_be Dec 15, 2016
    2 replies
  • date format Solved/Closed

    Hello, i am trying to create a report which will show me the first date and last date of the previous month. I need first date in one field and seco...

    deakin1980 | Latest reply: deakin1980 Dec 14, 2016
    2 replies
  • Multiple Variable Formula Closed

    Hello, I'm trying to add to the following formula. =IF(AND(G14="Poor",D14

    Kylana | Latest reply: yg_be Dec 14, 2016
    1 reply
  • Unique identifier Closed

    Good day! I would appreciate if anyone could help me out! I'm a small reseller! I started out with a few items now i have almost one thousand! Is th...

    JC0389 | Latest reply: vcoolio Dec 14, 2016
    3 replies
  • I want to fetch data from another work book with help VBA/Macro Closed

    Hi, I have a master file with team members name in one column, and I create a sheet for Managers with only given name (same format) in one column and...

    Balwant | Latest reply: Balwant Dec 14, 2016
    0 replies
  • EXCEL 2013 :Searching for text and display a different value. Solved/Closed

    I am fairly new at this, but I work in excel files that are extracted from out problem management system. I created a formula that will look for a key...

    ka4harley | Latest reply: ka4harley Dec 13, 2016
    0 replies
  • Building a new spreadsheet using information from another Solved/Closed

    Hello everyone, I'm new to the forum and VBA and would like to thank you in advance for your assistance. I have received a spreadsheet that contains...

    wtmayoza | Latest reply: wtmayoza Dec 13, 2016
    4 replies
  • Change Date Format Closed

    Hello, I need to analyse some dates, only problem is that they are displayed as: Fri, 19 Aug 2011 19:28:17 -0000 Excel won't recognise them as dat...

    borsa | Latest reply: borsa Dec 12, 2016
    0 replies
  • Excel function Closed

    Hello, Am looking for a formula which can be used to find the fund name from the subject line For eg. xyz capital market ltd-fund name Subject lin...

    Karthik | Latest reply: Karthik Dec 9, 2016
    0 replies
  • Conditional data copying Closed

    Hello, I require assistance in allocating employee codes to a specific PC. Those Employee codes are available in Pivots and i have to change date a...

    pkawale | Latest reply: pkawale Dec 9, 2016
    0 replies
  • Need macro code to make a report with 5 files on daily things Closed

    Hello, Please, can any one help me on this task, it would be great pleasure , I need a macro code to make a report with data in 5 different files o...

    Shiva | Latest reply: Shiva Dec 9, 2016
    0 replies