Excel Forum

Ask a question
Search
Close
Results 3551 - 3600 of about 9,850
  • Finding a particular row title and editing the value in next col Closed

    Hello All, I have excel data sheet in following format Row Heading Row Value name XYZ address ab id 11 Now I need to write a macro which can ...

    pranoopz | Latest reply: pranoopz Jul 23, 2015
    0 replies
  • How to find a row heading and replace the data in the next col Closed

    I have excel data sheet in following format Row Heading Row Value name XYZ address ab id 11 Now I need to ...

    pranoopz | Latest reply: pranoopz Jul 23, 2015
    0 replies
  • EXCEL/VBA copy multiple cell from other workbook into 1 workbook Closed

    Hello, I would like to copy couple of cell from multiple workbook into 1 workbook using Marco/VB. Example: Source C:\temp\A.xls. Cell needed ...

    hlfoong | Latest reply: hlfoong Jul 23, 2015
    0 replies
  • macros to add numbers Closed

    Hello, I need to create a button and on every click of that button it should add 1 to it. For Eg first click it should take data as 1 and second ...

    Koushik | Latest reply: vcoolio Jul 22, 2015
    1 reply
  • change date format Closed

    Hello, I Want to change date format dd.mm.yyyy to dd/mm/yyyy in MS Excel 2010 Please solve my problem urgently Configuration: Windows 7 / Chr...

    Mani | Latest reply: TrowaD Jul 21, 2015
    8 replies
  • Macro to cut & paste a row on same excel sheet Closed

    Hi, I have a list of values. You can consider them as text. These values are listed in a different sheet (in one column) on same particular Excel fil...

    Thakshila | Latest reply: Thakshila Jul 21, 2015
    0 replies
  • Comparing values from different sheets Closed

    Hello, I want to Compare Values from 2 different sheets and if duplicate. I am thinking of values on Column A & B of sheet1 to columns D & E of sh...

    D.P. | Latest reply: D.P. Jul 21, 2015
    0 replies
  • Need a macro to searched data in another Excel Closed

    Hello, I have a requirement , where in in one excel sheet i have data with 5 columns (A, B , C , D , E) now i want to search the excel on data wit...

    Nishi | Latest reply: M.Hanzla Jul 21, 2015
    4 replies
  • Date format Closed

    Hello, In my system date is in dd/mm/yyyy but I required in this format dd-mm-yyyy how it will possible pl let me know Configuration: Win...

    veeru | Latest reply: TrowaD Jul 20, 2015
    1 reply
  • automate vlookup Closed

    two sheets.in one excel sheet columns are name, isbn, qauntity and many so.... in another excel sheet columns are only three columns are sku, isbn, q...

    gajrajbhardw... | Latest reply: gajrajbhardwaj1990 Jul 20, 2015
    0 replies
  • Excel info Closed

    Hello, I am trying to enter data in one sheet and the total should be recorded in the other sheet. I want the total to be recorded in next cell a...

    Jiniz | Latest reply: Jiniz Jul 19, 2015
    0 replies
  • Date Interval within a specific span Closed

    Hello, I need some help with calculating the time difference between two time stamps within a specific span (like 12.30 PM to 22.30 PM). For Eg ...

    L | Latest reply: L Jul 19, 2015
    0 replies
  • Apply Autohide Rows VBA code to entire workbook in Excel 2013 Closed

    Hello, I want to apply this code to all worksheets: Private Sub Worksheet_Calculate() Dim LastRow As Long, c As Range Application.EnableEvents...

    Asif | Latest reply: Asif Jul 18, 2015
    0 replies
  • Autorun different macros dependent on dropdown and cell value Closed

    Hello, I have 4 macros activated by 4 buttons these are macros stage2, stage3, stage4 and stage5. If I enter values into fields D7, D8 and D9 then...

    Markdiv | Latest reply: Markdiv Jul 18, 2015
    0 replies
  • Macro needed to find A and look at B Closed

    Hi this is my first ever post! I am setting up a userform in VBA that allows data capture. This form currently copies the information entered to ...

    paulexcel | Latest reply: paulexcel Jul 18, 2015
    0 replies
  • Condition formatting on changing cell color based on another cel Closed

    hi, wanted to check if it's possible to do condition formatting on cell color based on another cell's text. For example I have cell A1 with Text Pa...

    Saitoh7 | Latest reply: Mazzaropi Jul 17, 2015
    1 reply
  • how to read the file from shared PC in same work environment Closed

    Hi all can anyone please guide me on this. I want to open the file which is stored in shred system in our work environment. those will be accessible...

    ashishvb | Latest reply: ashishvb Jul 17, 2015
    0 replies
  • to copy data to other workshet by suming the value based on co Closed

    Hello, I am having table like below with large data in DATA.xlsx file Pls see attached file for table details My requirement is to selec...

    ashishvb | Latest reply: ashishvb Jul 17, 2015
    1 reply
  • Auto - input box/date timestamp Closed

    Hello, I am creating an inventory spread sheet. I am using Excel 2013. I have data from A2:O1243. I have several macros running. My macros are as ...

    DC1982 | Latest reply: DC1982 Jul 17, 2015
    0 replies
  • Autorun Macro on various cell changes Closed

    Hello, I have 4 macros activated by 4 buttons these are macros stage2, stage3, stage4 and stage5. If I enter values into fields D7, D8 and D9 the...

    Markdiv | Latest reply: Markdiv Jul 17, 2015
    0 replies
  • compare filename1 sheet1 with filename2 Closed

    Hi all, i need help, i want to compare filename1 sheet1 with filename2 sheet and result in filename3 sheet as pass or fail. filename1 sheet1 insert ...

    real2014 | Latest reply: real2014 Jul 16, 2015
    0 replies
  • Autofill on excel or formatting? Closed

    I have two separate worksheets. When a customer calls in I will fill out there name, address, phone number, and email address in worksheet 1. I was th...

    Tasha | Latest reply: Tasha Jul 16, 2015
    0 replies
  • Excel / CSV query Closed

    I will be receiving a weekly CSV data set of holiday information that I need to do the following with: Save into XLS format Create 3 identifier ...

    Mattjones | Latest reply: Mattjones Jul 16, 2015
    0 replies
  • auto populating from one spreadsheet to another Closed

    HI there, this is my first question and I am hoping someone can help me please. I am setting up a database in excel and I am an basic to intermedia...

    bsbnz | Latest reply: vcoolio Jul 16, 2015
    3 replies
  • need formula to populate total sales for each employee by month Closed

    Hello, Im working on a spreadsheet and i cant come to a formula that works for me. I want to total the amount of apples each employee sold e...

    Andre_a1234 | Latest reply: Mazzaropi Jul 15, 2015
    1 reply
  • get data present in Row1 of Sheet1 copied into row1 of Sheet2 Solved/Closed

    Hello, I need to get data present in Row1 of Sheet1(Central OPD) to be copied into row1 of Sheet2(Departmental OPD) based on Department Column of Sh...

    ShambuKarpur... | Latest reply: vcoolio Jul 15, 2015
    11 replies
  • spellnumber function Closed

    Hello, Spellnumber function which was working in excel version earlier than office 7, does not work from office 7 onward versions. I can not get t...

    Shushil Bhoot | Latest reply: Shushil Bhoot Jul 15, 2015
    0 replies
  • copying rows to certain worksheet Closed

    Hello, I think i can accomplish this without a macro but can figure it out. I have a project list on sheet1, I would like to copy a projects row to...

    help | Latest reply: vcoolio Jul 15, 2015
    1 reply
  • Merge cells with different value into one row Closed

    Hello all, I would like to do a VB macro in MS Excel 2010 which will do the following: Before applying macro: Row Number Year Code ...

    Tanca | Latest reply: Tanca Jul 15, 2015
    0 replies
  • Conditional formatting a cell based on another cell Closed

    Hello, What I'm looking to achieve is a font in column A to be a colour (blue) if there is no text in column S, however, if there is text in colum...

    Tom | Latest reply: Tom Jul 15, 2015
    0 replies
  • lookup match difference Closed

    Hello, I have 2 sets of data: a b c d MEL MEL2 BOB BOB2 yx124 $100 xyz ...

    Naser2015 | Latest reply: Naser2015 Jul 14, 2015
    0 replies
  • I need a Macro to Add Another Sheet to the Current Workbook Closed

    Hello, I have a public file that I want a macro to import that worksheet into my current workbook. I have payload data that gives me timestamps an...

    Greg | Latest reply: Greg Jul 14, 2015
    0 replies
  • Last value in a row Closed

    Hello, I want a cell which is a summary of the entire row values, but it should display the latest value in the row.Suppose I have entered a value a...

    Jovy | Latest reply: Mazzaropi Jul 14, 2015
    1 reply
  • How do you specify a different location to save the file to? Closed

    Hello, I was wondering if you could tell me how to save this file to a different location than where the current file is saved? Configuration: ...

    paul | Latest reply: TrowaD Jul 14, 2015
    1 reply
  • sheet in which the next column gets automatically filled Closed

    Hi I need an excel sheet in which the next column gets automatically filled the moment existing cell is filled.Suppose, I have 10 employee names and ...

    JyotirmoyGuha | Latest reply: TrowaD Jul 14, 2015
    1 reply
  • copying data fromm different excels into one new sheet by cond Closed

    Hello, I have 2-3 different excel sheets. by specifying the criteria ie if the category:ABCD then copy all the data pertaining to match should be ...

    chaitrali | Latest reply: chaitrali Jul 14, 2015
    0 replies
  • Excel Macro to Copy Filtered Data to a New Sheets Closed

    Hello, I am writing an Excel macro that: 1- For every name on a list of values, creates a new sheet using the value from the list (DONE) 2- Filt...

    AliceS90 | Latest reply: AliceS90 Jul 14, 2015
    0 replies
  • Copy rows from master sheet to specific sheet Closed

    Hello, I am currently working on excel to copy rows from master sheet to individual sheet. These individual sheet have to be automatically filled...

    kaushal1234 | Latest reply: kaushal1234 Jul 14, 2015
    0 replies
  • multiple sheet to one sheet without blank cells Closed

    Hello, Hello, i have an excel file with more than 250 sheets, i want to merge these files into one sheet, i dont want to copy blank cells an...

    TharaSunu | Latest reply: TharaSunu Jul 13, 2015
    0 replies
  • Checking if value in 2 or more columns are repeated in a table Closed

    Hi Guys, Please help with below table, NAME SURNAME ID NUMBER STATUS NAME1 SN1 ID001 CLOSED NAME2 SN1 ID...

    Suraj | Latest reply: Suraj Jul 13, 2015
    0 replies
  • generating alphanumeric code Closed

    Sir, Can anybody help me in writing vba code for excel to generate alphanumeric code having first entry as L,P,G,T(based on a condition), next four...

    Pankaj2411 | Latest reply: TrowaD Jul 13, 2015
    3 replies
  • SAS datasets Closed

    Hello, there is a sas data set like: col1 col2 1 1 1 abc 1 2 2 def 2 2 3 3 3 ghi 3 3 expected outp...

    sindu | Latest reply: sindu Jul 13, 2015
    0 replies
  • formula - If C2 is not blank, and b2 Is blank, then copy c2 to Solved/Closed

    Hi all - Am looking for help on formula - I want excel to look at cell C2, then if it has anything (text or numbers), then to look at cell b2. If ...

    Eirualmac | Latest reply: Eirualmac Jul 12, 2015
    2 replies
  • Private Sub Closed

    Hi Team, Please request your assistance in creating a private sub macro, I am looking to create a file with all the data entered in worksheet 1 to ...

    yogesh | Latest reply: yogesh Jul 12, 2015
    0 replies
  • Copying Data From 1 sheet to another Closed

    hello i had made a bill in excel and also entered module of converting indian rupees in numbers.but if i copy my sheet to second sheet to prepare bi...

    suklaasd | Latest reply: suklaasd Jul 12, 2015
    0 replies
  • Excel Challenge! Closed

    Hello, I have text in A1:A2554 and text in B1:B1962. Although the columns do not have the same number of rows of information, it has relative inf...

    Jeremy | Latest reply: Jeremy Jul 11, 2015
    0 replies
  • data transpose Closed

    Hello I'd like to learn how to transpose my data in excel. Here is an example. Buy side/Sell side New York Paris Vienna Barcelon...

    mgorange10 | Latest reply: mgorange10 Jul 11, 2015
    0 replies
  • Need Help With Macro For Break Management Of Employees Closed

    Hello, Please help in defining a macro to record and monitor break timings of employees on shift. Requirements: Will need a Front End which w...

    avtarit | Latest reply: avtarit Jul 11, 2015
    0 replies
  • Private sub Closed

    Hello, Need a assistance in creating a private sub macro, I want all the data entered in worksheet 1 to auto update in worksheet 2. here I may e...

    Yo | Latest reply: Yo Jul 11, 2015
    0 replies
  • how to sort data according to shift Solved/Closed

    i want to sort according to person shiht

    bharatdevekar | Latest reply: bharatdevekar Jul 11, 2015
    0 replies