Excel Forum

Ask a question
Results 601 - 650 of about 9,830
  • 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
  • Required value as per the scanned data Closed

    Hi Everyone, I use VLOOKUP on a very frequent basis for my day to day work. I have a sheet full of data of inventory while doing my stocks audi...

    mebaznm14 | Latest reply: TrowaD Mar 27, 2018
    1 reply
  • Change date format dd.mm.yyyy to dd/mm/yyyy Solved/Closed

    Hello, I Want to change date format dd.mm.yyyy to dd/mm/yyyy in MS Excel 2003 Please solve my problem urgently Shatrughna System Configuratio...

    shatrughna | Latest reply: Ray Mar 26, 2018
    47 replies
  • Excel partial match Solved/Closed

    Hello, Hello, I have a small query related to Excel Search function. Suppose I need to search the below data in target cell which has some ...

    machoman4lyf | Latest reply: machoman4lyf Mar 25, 2018
    6 replies
  • Create a macro to open workbooks Closed

    Hello, Please help me to create a macro which will help me to open different excel workbooks and copy particular data/ figures from excel sheets t...

    Fazil27 | Latest reply: Fazil27 Mar 24, 2018
    2 replies
  • How to create a macro to open different workbooks Closed

    Hello, I have around 45-50 excel workbook with 3-5 sheets in each workbook. Each workbook is named as different unique number such as 823456,82...

    Fazil27 | Latest reply: Fazil27 Mar 24, 2018
    0 replies
  • Moving data to multiple sheets Closed

    I have a spreadsheet that I want to enter data into a main location and then have it go to specific sheets based on state and date entered. My data i...

    mingalls1 | Latest reply: ac3mark Mar 22, 2018
    1 reply
  • How to place and X in cell F7 Closed

    Hello, I am in excel, I want to be able to place and X in cell F7 and have the time automatically be placed in cell G7. can someon please help me. T...

    BWitham5 | Latest reply: ac3mark Mar 22, 2018
    1 reply
  • Applying conditional formatting rule to other rows Closed

    I have a row with multiple cells. two cells have drop down lists. If the first cell has value "A" from the dropdownlist, and cell 2 has value "B" from...

    FrejaOlsen | Latest reply: TrowaD Mar 22, 2018
    1 reply
  • Excel vba Closed

    Hello, i want that the button do the next action automatically with one click in excel vba System Configuration: Windows / Firefox 59.0

    fawad | Latest reply: fawad Mar 22, 2018
    0 replies
  • Transfer data from 1 sheet to another with cond. Solved/Closed

    Hi, I am having trouble working out how I would code this using VBA: In Sheet 1 I have 2 rows. The first row is the title and then the second ro...

    Kate.K22 | Latest reply: vcoolio Mar 21, 2018
    3 replies
  • Macro to manipulate lines of text Solved/Closed

    I have data that is arranged as this in four columns x emailx nameofx 123 x emailx nameofx 4456 x emailx nameofx 67 y emaily nameofy 12 z email...

    yuenja | Latest reply: TrowaD Mar 20, 2018
    26 replies
  • Macro for inserting pictures from folder to Excel Closed

    Hi guys I am new here and would appreciate any help for the following issue: I have an excel sheet with more than 100 product codes (e.g. 00501-016...

    Grig280390 | Latest reply: TrowaD Mar 20, 2018
    1 reply
  • Find and replace from a dropdown Solved/Closed

    hi Guys, second and hopefully last question for now. Is there a way to the following: I have a dropdown list with names of tabs of the excel file...

    DG83 | Latest reply: DG83 Mar 19, 2018
    2 replies
  • DOB conversion in Excel Closed

    Hello, how to do work DOB conversion in excel sheet System Configuration: Windows / Chrome 64.0.3282.186

    chandar | Latest reply: xpcman Mar 19, 2018
    1 reply
  • How to easily cummulate data Solved/Closed

    Hi there, I was wondering if you guys know how to do this: got 13 weeks, each week has a figure underneath it. Let's say week 1 has 1 under it, wee...

    DG83 | Latest reply: Mazzaropi Mar 17, 2018
    3 replies
  • VBA code to create Pivot Table Closed

    Dear all, Attached and show below the xls sheet. I need help from the forum, once I click the button, a pivot table to be generated in a new s...

    sarisri7 | Latest reply: ac3mark Mar 16, 2018
    1 reply
  • Change color of cell comparing contents to 2 cells Closed

    Hello, Hope someone in this community can help me write a vba code to for example: Cells B3 and C3 have a value When I input values into cells r...

    sjohn | Latest reply: sjohn8220 Mar 16, 2018
    1 reply
  • paste range of cells to next blank cell Closed

    I have a fixed copy range of 11 cells that I need to paste to next blank cell in the same column to a list of 32000 tasks. please can you help with ma...

    PHILIPSTREETS | Latest reply: PHILIPSTREETS Mar 16, 2018
    0 replies
  • Pull data from sheet 1 to sheet 2 Closed

    I would appreciate any help for my case. So in sheet 1 called WIP, consist of item descriptions (C1) and quantity to be build (D1). The item descripti...

    zachou874 | Latest reply: ac3mark Mar 14, 2018
    1 reply
  • Copy Paste in loop in loop Closed

    Hi Trowa, I am new to Macro - but i have similar request to copy paste in 2 loops 1. copy a number times Sheet 1 Column 1 data ( say having 3 val...

    manojsaxena | Latest reply: ac3mark Mar 14, 2018
    5 replies
  • Automatic Payroll Computation Closed

    Hi everyone. Im just new to my job and one of the task assigned to me is to compute payroll for our employees. im not that knowledgable with excel, m...

    gracia27 | Latest reply: Mazzaropi Mar 14, 2018
    2 replies
  • VLookup plus and and or match Closed

    Hello, I am trying to compare two different pulls from and HRIS system in Excel to create a monthly Delta file, I not only need to look up and r...

    Gbinney | Latest reply: Gbinney Mar 12, 2018
    0 replies
  • Automatically change the cell from general to date Closed

    Hello, System Configuration: Windows / Chrome 64.0.3282.186 Somehow i am facing an issue again and again in my office 365 excel, when i sa...

    iamdinesh | Latest reply: TrowaD Mar 12, 2018
    1 reply
  • copy text from one work sheet to another Closed

    Hello, Could some one help explain how I can simply copy text from a cell in a different work sheet. I'm trying to make a report using the months of t...

    meljam | Latest reply: Tannu Mar 9, 2018
    3 replies
  • If then formula Closed

    Hello, I am working in excel 2016. I would like to use a formula in regards to days and a project time line. For instance if a project has 365 d...

    Stephanie | Latest reply: Stephanie Mar 9, 2018
    0 replies
  • How do you change cell colour based on date Closed

    Hello, How do you change cell colour automatically based on date. I am trying to set my training spreadsheet so I can clearly see when staff membe...

    samdawn88 | Latest reply: Mazzaropi Mar 8, 2018
    3 replies