Excel Forum

Ask a question
Results 601 - 650 of about 9,870
  • Data from one master sheet to 100 other sheet Closed

    Hello, I have this kind of problem that i have serial numbers xxx-xx-xx listed in 1200 rows in A column of master sheet. I have already macro for ...

    anakonda93 | Latest reply: TrowaD May 7, 2018
    4 replies
  • Look up tables across workbook Closed

    Hello there! I am currently working on a spreadsheet for my organization. As far as the data is concerned, it is collected by another part of the o...

    MACrucible | Latest reply: vcoolio May 7, 2018
    1 reply
  • Move that tab to a new workbook Closed

    Im relatively new to excel macros and have done half of what i need to do. I created a macro that takes data from one tab (which contains a pivot tab...

    eaja2 | Latest reply: ac3mark May 6, 2018
    1 reply
  • How to insert pictures in Excel using Macro Closed

    Hi, I'm facing 2 issues in using below code. 1st, suppose the image names are in column B from B2 to B11. Now, if the image against the image name ...

    atulmangal | Latest reply: ac3mark Apr 30, 2018
    1 reply
  • Resize cell to match picture size Closed

    Hello, Using above codes pictures are getting sized but the cell remains the same. pictures are overlapping each other. please help

    san | Latest reply: ac3mark Apr 30, 2018
    1 reply
  • Failing to sign in to excel Closed

    hie can you be of assistance im failing to sign in to excel it keeps telling me that there is a problem with my account. i have tried resetting the pa...

    kemielgeal | Latest reply: Ambucias Apr 30, 2018
    3 replies
  • Excel "IF" function w/ date in test cell Solved/Closed

    Hello, I am trying to use the IF function with a date in the logic test cell; If the logice test cell has a date then I want the word "DONE" to sho...

    Mike in PA | Latest reply: salim Apr 29, 2018
    6 replies
  • Updating a sheet name in Excel without macros? Closed

    Hey everyone, I've been working on a project and in order to do it how I was planning, I need to update sheet names dynamically without using macro...

    Graudenzo | Latest reply: ac3mark Apr 26, 2018
    3 replies
  • calculate how many times member A visit the cafe Closed

    Hello, member A register at cafe on a date 12 april 2017. He visited the cafe every times started from the registed date when the cafe opened at ...

    jeff | Latest reply: TrowaD Apr 26, 2018
    1 reply
  • transferdata from 1 sheet to other sheets criteria Closed

    Greetings! I have been trying to look for vba codes and formulas but am still at a lost as to how to even start. Am a total newbie at this whole vb...

    Sheiraa | Latest reply: ac3mark Apr 24, 2018
    1 reply
  • Auto Update a workbook with multiple sheets on one sheet of the same workbook. Closed

    Good pm. I need your help in order to enable me carry out update in ms excel. I have a workbook with multiple sheets (namely, creche , nursery1, ...

    topkentalk | Latest reply: ac3mark Apr 24, 2018
    1 reply
  • Table Values used to auto calculate and return val Closed

    Is there a way in a formula to have Excel continually look in a table, and insert a value in a cell , so that the value in another cell will never be ...

    LeedMe | Latest reply: ac3mark Apr 24, 2018
    13 replies
  • VLookup formula gives error Closed

    =VLOOKUP(A29,'I:\Vending Reports\2018\3. March 2018\[March 2018.xlsm]Crews'!$A$1:$H$370,8,FALSE)+G29 This is my formula. It is supposed to look f...

    ltlrose | Latest reply: TrowaD Apr 24, 2018
    6 replies
  • Copy data from one sheet to another Closed

    How can I copy data from one sheet to another on the basis of value in cell G10, say if value is DELHI then set of column corresponding to delhi will ...

    vipulk | Latest reply: ac3mark Apr 23, 2018
    1 reply
  • Concatenate columns in Excel Closed

    Hey actually i have a prob, i have 4 columns in my excel sheet, among them based on 2nd column i have to concatenate the contents of 4th column...

    karthikkp | Latest reply: ac3mark Apr 23, 2018
    1 reply
  • Pulling in missing data between spreadsheets Closed

    I receive a spreadsheet every week that has a list of IP addresses of servers that need updates. Not all servers need updates every week so this sprea...

    mikejj24 | Latest reply: TrowaD Apr 23, 2018
    1 reply
  • Salary calculator in Excel Closed

    I want to make a salary calculator( in excel ) in which I want to add 3% increment in "basic". My columns are :---- 1. "Month"=march 2017, April 2017 ...

    Devashish | Latest reply: TrowaD Apr 23, 2018
    1 reply
  • Auto populate specific data from sheet to another Closed

    Hello, I'm trying to auto populate data from one workbook to another, or sheets if that makes it easier. In the sample I've included I'm trying to...

    V_torres | Latest reply: TrowaD Apr 23, 2018
    1 reply
  • Adding fields to formula at one time Closed

    Hi guys, Not sure if there's a quick way for this: Do you know if possible to do this: Sheet 1 A1 field contains formula: sheet 2 A1 plus sheet 3 ...

    DG83 | Latest reply: TrowaD Apr 23, 2018
    1 reply
  • Excel date conditions Closed

    I have to go in every 2 weeks to update a spreadsheet, based on whether the date in the row is current or in the past. Is there a way to set it up s...

    Chantalehoney | Latest reply: ac3mark Apr 20, 2018
    3 replies
  • Leaving a Copied Cell Blank if no data Closed

    I have several spreadsheets containing different information on the same patient. Patient is ID a number. The ID has to copy over to several different...

    LLL | Latest reply: LLL Apr 19, 2018
    0 replies
  • Copying non blank cells from one sheet to another Closed

    Hi all I have some code here that works great but I am looking at adding in some additions. I am currently struggling and I hope that maybe someone on...

    JohnMcLaughlin | Latest reply: JohnMcLaughlin Apr 19, 2018
    2 replies
  • Extract missing word from text string Closed

    Hello, Hello, i have data in 2 columns, for ex: Column A: Bearing, Ball, 1/2 in, Cast Iron Column B: Bearing, Ball, Cast Iron by s...

    surendra | Latest reply: TrowaD Apr 19, 2018
    3 replies
  • Change color for specific number of cells by value Solved/Closed

    I have a excel sheet with data of planned and pending projects. In column "I" it states number of weeks required for completion of the project. Each r...

    ChrisK | Latest reply: TrowaD Apr 19, 2018
    3 replies
  • Auto populate from master file to other Solved/Closed

    Hi Good afternoon!! I have a master data file that comprises of data of overall activities of the project including sales,contract value, wo...

    MohamedGhouse | Latest reply: TrowaD Apr 19, 2018
    7 replies
  • VBA Copying cells based on if there is a value Closed

    I have this code which works great thanks to help I received here. I am looking to see if it is even possible to add in some addition functionality. C...

    JohnMcLaughlin | Latest reply: JohnMcLaughlin Apr 18, 2018
    0 replies
  • VBA Copy data based on count result Closed

    Hi, I am trying to build in the following code in order to count how many cells in a row have data. Based on the count I then need to Copy cells by t...

    JohnMcLaughlin | Latest reply: JohnMcLaughlin Apr 18, 2018
    2 replies
  • Top 10 in descending order Closed

    Hi guys, I'm struggling to find a solution for this. There is a list that contains, time-frame as Q12016 up until Q42018, then cities as London, Pa...

    DG83 | Latest reply: DG83 Apr 17, 2018
    2 replies
  • Autopopulating data from master Excel to new Excel Closed

    Hello All, I am stuck with a problem and would appreciate if someone can help me. Here my question. I have a master sheet where column A, B, C e...

    parthmehta0999 | Latest reply: ac3mark Apr 16, 2018
    1 reply
  • Copy data in one worksheet to another VBA Closed

    Hi all, I am trying very hard with little success to automate this with VBA. I am trying to copy data from Sheet1 Row1 in Column A, B & C and t...

    JohnMcLaughlin | Latest reply: ac3mark Apr 16, 2018
    14 replies
  • Auto create info sheets from master spreadsheet Solved/Closed

    UPDATE: I am able to automatically generate the excel sheets and then automatically convert those sheets into separate files using a macro. My remaini...

    wbarn17 | Latest reply: ac3mark Apr 16, 2018
    3 replies
  • Formula that will adjust dates based on a change Closed

    what formula can i use so that the days (mondays-sundays) will automalticaly adjust when im changing the date (March 12, 2018)? It's for the DTR (dail...

    mad_09 | Latest reply: ac3mark Apr 16, 2018
    3 replies
  • Autopopulating data from master excel sheet Closed

    Hi, I have a master sheet where column A, B, C etc. resides username, password, application etc. information. Now I have created a report which ...

    parthmehta0999 | Latest reply: parthmehta0999 Apr 15, 2018
    0 replies
  • Query on developing table and chart automatically Closed

    Hello, Please guide me how to develop a table & chart automatically based on the below input data. I am able to develop table and chart manually ...

    machoman4lyf | Latest reply: ac3mark Apr 13, 2018
    1 reply
  • Automatically move data from one sheet Closed

    How to automatically move/copy data from one sheet to another if certain criteria met. Hi. I have two sheets, sheet1 I have data where each cell has ...

    bustosjuan | Latest reply: ac3mark Apr 12, 2018
    1 reply
  • Conditional Formatting Closed

    I have cell G8 in excel which is a time stamp. I want it to be highlighted when it is greater than cell A8 which is a scheduled time.

    BWitham5 | Latest reply: ac3mark Apr 6, 2018
    3 replies
  • Copy data from one Workbook to another Closed

    Hello, I have to save data from one Sheet 1 of Workbook 1 to Sheet 1 of workbook two. EX: Sheet 1, Workbook 1 Date Name Salary 1/1 ABC 100...

    Hoshang | Latest reply: ac3mark Apr 5, 2018
    1 reply
  • Consolidate based on a value in Excel Closed

    Hi All, I have 2 worksheets and i want to consolidate them into a third sheet based on the value of column P. If column P on either sheet (named...

    Sgot101 | Latest reply: ac3mark Apr 5, 2018
    5 replies
  • Excel - Lookup Query... Closed

    Hi, I'm trying to find something similar to this but I'm having trouble. Im no way an expert but I know my way around and basic functions.... ...

    J.dot.E | Latest reply: TrowaD Apr 5, 2018
    2 replies
  • Convert data with rows into columns Closed

    Hello, I wanted to convert huge amount of data with rows into columns , with few conditions please let me know if you can help. System...

    pooja.bs | Latest reply: TrowaD Apr 3, 2018
    2 replies
  • Find Partial text Match Closed

    Hi, Please help me with the function to highlight a partial text Matches in column with other column. For example Column A: SWDP9233 When a co...

    mghore | Latest reply: TrowaD Apr 3, 2018
    1 reply
  • Copy Single row from working file to Master file Closed

    Hello Sir, I have one working file containing multiple rows, I have one other Master file with 2 tabs. I need to copy Single row from working file ...

    mahajangurudas | Latest reply: TrowaD Apr 3, 2018
    3 replies
  • macros Closed

    how to convert multiple columns into rows with few conditions

    pooja.bs | Latest reply: pooja.bs Apr 2, 2018
    0 replies
  • How to recover a corrupt Excel file? Closed

    how to recover corrupt excel file

    chandraabhay | Latest reply: chandraabhay Mar 28, 2018
    0 replies
  • Use in Scripting.Dictionary- item join string 3col Solved/Closed

    Hello, I'm looking for example to use scripting.dictionary. on topic user Smallman1 https://ccm.net/forum/affich-947210-any-faster-version-of-the-sa...

    mokie1 | Latest reply: mokie1 Mar 28, 2018
    1 reply
  • How to change date format from yyyymmdd to mm/dd/yy in Excel? Solved/Closed

    Hello, I have data with dates arranged in yyyymmdd format. Is there an easy way to change the format to mm/dd/yy in Excel 2010? Thanks!

    lmw | Latest reply: Sf Mar 28, 2018
    12 replies
  • How can I automatically copy table to next sheet? Solved/Closed

    Hello, I have an Excel file with 30 sheets containing the same table. In the table, the last column is a Yes/No (using data validation). Once a d...

    DanielOfir15 | Latest reply: vcoolio Mar 28, 2018
    13 replies
  • Small business tracking in Excel Closed

    I have not found a small business software that meets my needs, and have created a tabbed spreadsheet. However, it has become a bit cumbersome, and ...

    gwhite83g | Latest reply: TrowaD Mar 27, 2018
    1 reply
  • Copy and paste spaces inbetween data into a range Closed

    Hello, I have file of student registrations that arent exporting to excel to properly. So I decided to copy all the cells and paste it into excel....

    PeteMohr | Latest reply: TrowaD Mar 27, 2018
    1 reply
  • Using VBA code to search and minus cell value Closed

    Hello! I'm desperately trying to do a macro button that can lookup a table's column and row headers (from 2 lookup_values entered in 2 cells), then...

    Ly2424 | Latest reply: TrowaD Mar 27, 2018
    1 reply