Office Software Forum

Ask a question
Search
Close
Results 2201 - 2250 of about 16,600
  • Compare Value Randomly Closed

    Hello, Hello, I have 4 columns: vendor_url reprice_sku Item ID URL for Item ID URL1 2...

    klieger | Excel | Latest reply: klieger Nov 30, 2016
    0 replies
  • Adding a specific number of rows between data change in excel Closed

    Hello, please advise on the code for adding a certain number of rows in the excel data at a change in value. I want to add 12 blank rows between th...

    AT | Excel | Latest reply: yg_be Nov 30, 2016
    1 reply
  • embarrassing Closed

    Data is automatically (or unintentionally) are copied from one worksheet to another taking up time and memory. How can I prevent Excel do this? Is the...

    kodosalbion | Excel | Latest reply: kodosalbion Nov 30, 2016
    0 replies
  • A and B column query to provide Sum of column C Solved/Closed

    Hello and thank you for your help. Please use this scenario for reference: - A B C 1 abc x 1 2 abc y 2...

    Rian Crabtree | Excel | Latest reply: yg_be Nov 29, 2016
    1 reply
  • search, find & display Solved/Closed

    Hello, I have been manually filling out the week no's, in a budget sheet, but want to try and auto populate. I have a table with dates and Week No...

    noob | Excel | Latest reply: learningenquirer Nov 29, 2016
    5 replies
  • VBA Help - Copying Rows into a new sheet, based on 3 Characters Closed

    Hello Friends, I am looking to build a VBA Macro that extracts the entire row of information based on the first three letters of Column C (Postal). ...

    kgan4 | Excel | Latest reply: yg_be Nov 29, 2016
    7 replies
  • How to Insert Video into PowerPoint? Closed

    I want to spruce up my PowerPoint presentations with some local videoo, but I have no idea how to make that. Any suggestions?

    Gloriaivy | PowerPoint | Latest reply: cody-peter Nov 29, 2016
    1 reply
  • Copy past using VBA Closed

    I am in Excel trying to copy data from from one worksheet to another. The idea is new data would be added to the next row each time data is added. Eac...

    ntmn8r | Excel | Latest reply: cody-peter Nov 29, 2016
    6 replies
  • I want to validate the data format Closed

    Hi I need to verify/validate the data in a column, it should be "AAAA-16-0001" format. If the data is not in the specified format, i need to have a...

    yuva69 | Excel | Latest reply: yg_be Nov 29, 2016
    3 replies
  • automatilcally transfer to data to other spreadsheet Closed

    Hello, I have one master sheet and 12 monthly sheets, I want to transfer the data from Master sheet to all the respective monthly sheet, automatical...

    aziz5289 | Excel | Latest reply: aziz5289 Nov 29, 2016
    0 replies
  • Help! Cant open Open Office Closed

    I'm using Windows 7. Thanks. Larry

    larryblau | Open Office | Latest reply: Ambucias Nov 29, 2016
    1 reply
  • Outlook .ost is in use Closed

    Hello, After I have installed Office Suite Service, i tried to start Outlook 2007. But when i attempted to start it a pop-up box stating: Outlook .o...

    cemerson22 | Outlook | Latest reply: cemerson22 Nov 28, 2016
    3 replies
  • Excel formula query Closed

    Hello, If I enter 1 in column A1 I want column C1 to equal the content of column C2 Configuration: iPad / Safari 9.0

    Ian | Excel | Latest reply: Mazzaropi Nov 28, 2016
    1 reply
  • Verify data format in all rows for a column Closed

    Hello, I have 2 worksheets (sheet1, sheet2) which has about 50 columns each. The sheet has customer informations for the company for 2 different yea...

    yuva69 | Excel | Latest reply: yuva69 Nov 28, 2016
    0 replies
  • Transferring data between sheets Closed

    Hello, Thanks in advance for reading my question. I am have two excel sheets. The first sheet contains the columns: first name, last name and i...

    n_sheikh | Excel | Latest reply: TrowaD Nov 28, 2016
    1 reply
  • coloring line indicated the name, by the table where there is th Closed

    Hello, I have four tables with four different colors, are 4 different categories of staff. First with font color blue Second with font color red...

    NickBR | Excel | Latest reply: Mazzaropi Nov 28, 2016
    5 replies
  • Autofill based on filename in same/different folder. Closed

    Hello, I'm looking for a way to pretty much automate part of my job, which is creating manhole sheets. In folder there are 10 files, each is calle...

    Jacek | Excel | Latest reply: yg_be Nov 28, 2016
    3 replies
  • Copy query from all worksheets of same workbook Closed

    Hello, Please help me with below, I have 600 worksheets file, out of which i want to add only fiest column of all sheets in one master file and th...

    aj | Excel | Latest reply: yg_be Nov 28, 2016
    1 reply
  • conditional formatting based on multiple values Closed

    Hello, I want to color my cell if one of few drop down list is picked for example: if appe or orange are getting picked, it needs to color it in gr...

    ziii | Excel | Latest reply: Mazzaropi Nov 27, 2016
    1 reply
  • change password Closed

    Hello, Pls forget my password Configuration: iPhone / Safari 4.0

    panu | Word | Latest reply: Ambucias Nov 27, 2016
    1 reply
  • I NEED A HELP IN VBA CODE Closed

    i'm trying to create stock inventory by 3 userform in different worksheet is Stock Inwards, Outwards and Sales Return but i transfer qtys to last wor...

    mdsarkar29 | Excel | Latest reply: mdsarkar29 Nov 26, 2016
    0 replies
  • Attendance sheet Closed

    Hello, i am using excel for attendance card scanning, in that sheet i have applied v lookup formula for getting the employee name and other informa...

    khan | Excel | Latest reply: khan Nov 26, 2016
    0 replies
  • Change cell color based on another column Solved/Closed

    Hi All, I am not very good at excel, however I am looking for a solution for the following problem. There are two columns (Column A and Column B...

    ritzutak | Excel | Latest reply: Ambucias Nov 24, 2016
    5 replies
  • Default ´Value in a Cell for User to fill it Closed

    Hello Guys, I would like to know if there is a way to input a default value in a cell so that it can indicate the user about the information to ...

    adikademani | Excel | Latest reply: yg_be Nov 24, 2016
    1 reply
  • Underlining a Value in a Variable Closed

    Hello Guys, I have a variable which contains some value. I would like to underline it before printing it into a cell. I have used the following lin...

    AdiK | Excel | Latest reply: yg_be Nov 24, 2016
    2 replies
  • Incorporating the text formating when Formula in used Closed

    Hello Guys, In Cell A1, the text is "abc" (Note that "abc" is underlined). If i choose cell B1 and apply a formula as "=A1", the cell B1 shows "ab...

    adikademani | Excel | Latest reply: yg_be Nov 24, 2016
    1 reply
  • Concatenating a variable.formula and variable.value Closed

    Hello Guys, I would like to know if there is a way to concatenate a variable.formula and variable.value. I have written the following lines of...

    AdiK | Excel | Latest reply: yg_be Nov 24, 2016
    1 reply
  • Transfer data between excel sheets Closed

    Hello. I have converted pdf files into excel. So each pdf file presents sheets in a single workbook. Now the issue is I have around 100 sheets. But...

    Bridge | Excel | Latest reply: TrowaD Nov 24, 2016
    1 reply
  • Best resources to learn about PowerPivot? Solved/Closed

    Hello, I'm expected to use PowerPivot extensively - meaning with complex data models. What would you recommand for a newbie who wants to learn?

    GiantCheck | Excel | Latest reply: GiantCheck Nov 24, 2016
    0 replies
  • cond format for date column Closed

    Hello, I am trying to apply cond. format to a date colunm to change color according to todays date +30, +60, and +90...all being different color fi...

    joe | Excel | Latest reply: vinay Nov 24, 2016
    2 replies
  • in some cells dates format are changed Closed

    Hello, the prblem is that when i upgraded to office 10 then formate of dates are changed in some cells of the worksheets and whn i changed the forma...

    aditya | Excel | Latest reply: yg_be Nov 23, 2016
    1 reply
  • Excel vba to work on ALL workbooks - please help. Closed

    Dear valuable members, I have this code: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)Lastrow = ActiveSheet.Cell...

    Sam | Excel | Latest reply: yg_be Nov 23, 2016
    1 reply
  • Excel vba to work on ALL workbooks Closed

    Hello, I have this code: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)Lastrow = ActiveSheet.Cells(Rows.Cou...

    Sam | Excel | Latest reply: Sam Nov 23, 2016
    0 replies
  • Find variable and paste name of sheet in another workbook Closed

    hello, i need to search a variable in an existing workbook and then copy the name of the sheet in which it si contained and paste it against the varia...

    Ashutosh tiwari | Excel | Latest reply: Ashutosh tiwari Nov 23, 2016
    0 replies
  • transfer specific data on to a second work sheet Closed

    WORKBOOK 1 Services ALL - contains columns A-F (a- Qtr, b-Locality, c-Date, d- first name, e- surname, f- Comments) I have a WORKBOOK 2 with work...

    lydianoble | Excel | Latest reply: lydianoble Nov 23, 2016
    0 replies
  • covert the date format into text in excel Closed

    How to convert birthdate in text format in excel

    sagar@1234 | Excel | Latest reply: sagar@1234 Nov 23, 2016
    0 replies
  • Append & Copy Data Automatically from Tab A to Tab B Closed

    I'm trying to automatically append any new data from one excel tab (ReportExport) to another tab (MappingTool) if the vlookup on the MappingTool tab i...

    vasweetheart05 | Excel | Latest reply: vasweetheart05 Nov 22, 2016
    0 replies
  • Wildcards or values in a macro? Closed

    Hello, I created a macro (by recording) that looks at the names and picks them based on the full name. Is there a way to just use a wildcard? Instea...

    sworcester | Excel | Latest reply: ac3mark Nov 22, 2016
    3 replies
  • How To Make an Excel Sheet Equal to Another Solved/Closed

    Hi, I'm new in Excel, and what I'm trying to do is this: I want to make an entire sheet equal to another, except for one cell, so if I change somethi...

    AML | Excel | Latest reply: Mark Han Nov 22, 2016
    5 replies
  • Macro to copy a sheet to a new sheet after a filter and sort Closed

    Hello, I have a recorded macro that picks specific values in a list and sorts them to display only ones with those values. What I would like to do ...

    sworcester | Excel | Latest reply: sworcester Nov 22, 2016
    0 replies
  • Macro to change the find option from 'workbook' to 'sheet' Closed

    I cannot find a macro anywhere to change the find option from 'workbook' to 'sheet'? Any help greatly appreciated.

    nonono | Excel | Latest reply: TrowaD Nov 22, 2016
    1 reply
  • contain word, return value Closed

    Hello, I would like some help. cell a1 contains London - abc cell a2 contains Tokyo - abcd cell a3 contains Singapore - abcde I would like...

    james | Excel | Latest reply: TrowaD Nov 22, 2016
    3 replies
  • Entering Formulas for a Master Sheet Closed

    I want to track who has borrowed materials from a library. I have each resource on a separate sheet with information about the date borrowed, contact ...

    SWEdwards | Excel | Latest reply: vcoolio Nov 21, 2016
    3 replies
  • Macro for creating new workbooks from existing source file(excel Closed

    Please provide the macro code for the following data source - 1 siddhesh 100000 09/02/1989 2 amol 100000 08/01/1991 3 siddhesh 150000 ...

    siddhesh_sjoshi | Excel | Latest reply: vcoolio Nov 21, 2016
    1 reply
  • If/then question Closed

    Hello, If a cell contains any text except for one specific word, I want to return that exact text. If a cell is empty I want to return nothing. ...

    Lmetz0804 | Excel | Latest reply: yg_be Nov 21, 2016
    10 replies
  • How to copy and paste entire rows into another worksheet automat Closed

    Hi! I need to know the code I use to copy and paste entire rows into another worksheet automatically. The conditional value is in column A and row ...

    Lin | Excel | Latest reply: TrowaD Nov 21, 2016
    1 reply
  • Conditional formatting expert needed! Comparing 2 arrays. Closed

    Hi all, I apologize for the vague title. but I could not think of a way to properly explain the problem in a single line with so few characters... ...

    SaintNick | Excel | Latest reply: TrowaD Nov 21, 2016
    3 replies
  • Copy paste Rename based on cell value Solved/Closed

    Hello I have a worksheet named template. I need a VBA code which would copy "template" automatically into a new worksheet and rename the new wor...

    Josephnb | Excel | Latest reply: Josephnb Nov 21, 2016
    7 replies
  • Copy data from one sheet to a new workbook and save loop Closed

    Hello, I have a sheet with multiple values which I want to copy into a new workbook, in a certain format, save as a certain name and then repeat f...

    marks88 | Excel | Latest reply: marks88 Nov 21, 2016
    2 replies
  • What function do I use to pull data prior to a certain date? Closed

    Hello, I have a database that is organized quarterly. I would like to save myself from having to manually move data onto a new sheet after 3 month...

    NSamm | Excel | Latest reply: fdibbins Nov 20, 2016
    2 replies