Office Software Forum

Ask a question
Results 201 - 250 of about 16,600
  • IF formula for a date range Solved/Closed

    I have two columns, booked date and las rev date for 2021 If the dates in these two columns are between Jan 1 - 24 then it would be a jan report date...

    luxe | Excel | Latest reply: TrowaD Jan 18, 2021
    3 replies
  • problem code copy invoice data to archive Closed

    hi, experts I've found this code from the internet , and I amended some ranges & sheets name , it works but not completely ,there i...

    abdelfatah_0230 | Excel | Latest reply: abdelfatah_0230 Jan 15, 2021
    1 reply
  • Conditional Formatting: Font color for entire column based on another column Solved/Closed

    Hi! I would like to format an entire column so that if there is any entry in column B (in the same row) the font in column A will be blue, if there...

    Kitkatpdx | Excel | Latest reply: Mazzaropi Jan 13, 2021
    5 replies
  • Clear cell contents based on value of another cell range using VBA Solved/Closed

    I'm new to all of this and I'm stumbling through as best as I can so forgive me if I don't explain this very well. I have a workbook that has over ...

    Tbonekiller | Excel | Latest reply: Tbonekiller Jan 12, 2021
    6 replies
  • Splite the multiple column value copy & paste in other sheet Solved/Closed

    Hello, I want to copy & paste the value of my data sheet, value are save in column & row, i want to splite the spacific rage of column value copy & ...

    Nitesh2020 | Excel | Latest reply: TrowaD Jan 5, 2021
    1 reply
  • Teacher Closed

    Hello, when I used rank function with count-if function the results of these two function if data has two same number like 292,292 it give the 1,...

  • Copy data from one worksheet to another using spec criteria Solved/Closed

    Hello, I have tried to "customize" other answers similar to this question to fit what I need but I am new to the whole macro thing. I have only use...

    Siobahn | Excel | Latest reply: vcoolio Jan 4, 2021
    14 replies
  • Change fill color depending upon the yes or no dropdown options. Closed

    Hi, My question I want to create a vba code for yes or no If yes- If my columns C-N are blank, I want it to be highlighted by some color and afte...

    ajo_5895 | Excel | Latest reply: vcoolio Dec 28, 2020
    12 replies
  • Where did page numbers go? Solved/Closed

    Hello, I am trying to set page numbers and from youtube videos, there should be a list of different designs showing here but it is not? How do I...

    BlackCastle | Word | Latest reply: HelpiOS Dec 25, 2020
    7 replies
  • fixing populating values into textboxes based on showing data in listbox Solved/Closed

    hello I need help about showing wrong values in textbox(credit , debit & balnce) , it should show right value textbox (debit ) based o...

    abdelfatah_0230 | Excel | Latest reply: abdelfatah_0230 Dec 25, 2020
    11 replies
  • How to convert the data from PST to EML? Solved/Closed

    I'm not getting exact solution for this

    ankit213506 | Office Software | Latest reply: somtochukwu Dec 25, 2020
    4 replies
  • Matching 2 sheets Solved/Closed

    I'm driving myself mad trying to figure this out. I have 2 sheets. I need to match First & Last name on both sheets. If the name matches, then I need...

    ToEKnee213 | Excel | Latest reply: TrowaD Dec 24, 2020
    1 reply
  • more font with a few characters inside each Closed

    Hello, I hope I am not OT with my question ... Why when I go to extract the fonts embedded in a pdf file I have several fonts with the same name (...

    cloud | PDF | Latest reply: cloud Dec 22, 2020
    0 replies
  • Automatically replacing a value in an excel report Solved/Closed

    Hello, I have a CAB Report template with a column called "Change Type" When I extract information the data in this column comes in as either Normal...

    NazCarr | Excel | Latest reply: NazCarr Dec 14, 2020
    4 replies
  • Use of IF Solved/Closed

    Hello, Guys I am new to excel but I got a complex situation at work. Hope someone can help. I want a formula where if I change the date in one ...

    Anup27 | Excel | Latest reply: TrowaD Dec 7, 2020
    3 replies
  • Formatting Date Closed

    My bank has organised my dates as dd/mm/yyyy which is about as useful as a hip pocket in your singlet. The logical way to organise dates is yyyy/mm...

    Moselley | Open Office | Latest reply: GeekPeek Nov 30, 2020
    1 reply
  • keyboard shortcut for Smart Lookup Closed

    In Microsoft Word, I cannot create a keyboard shortcut for Smart Lookup (búsqueda inteligente in Spanish). How can I do it? I cannot find it in the me...

    informatique... | Word | Latest reply: informatiquetique123 Nov 23, 2020
    4 replies
  • People Folder in Outlook no longer contains any Contacts Closed

    Hello. I hope someone can help me. I have Windows 10 and Microsoft Office Professional Plus 2016. When I open the "People" folder in Outlook, it is em...

    muddywater | Outlook | Latest reply: muddywater Nov 13, 2020
    0 replies
  • Use Outlook for my Yahoo email Closed

    ive been trying for 2 days to use outlook for my yahoo go

    budgraystone... | Outlook | Latest reply: Nov 12, 2020
    0 replies
  • HUGE Inventory Assistance - duplicate a row based on a cell value or quantity Solved/Closed

    I have an inventory list that will end up being ~60k rows of data based on the sum of Col1. tab name - "inventory" Col1 - original quantity Col...

    klewis24 | Excel | Latest reply: klewis24 Nov 9, 2020
    2 replies
  • Match partial text string in one sheet to another text string in another sheet Solved/Closed

    Hi All, I have two different sheets. In one sheet, I have last names. In the other sheet, I have a column that has cells that contain the person's la...

    Santos | Excel | Latest reply: Santos Nov 5, 2020
    2 replies
  • Quel bouton utilise cette sous-routine? Solved/Closed

    Bonjour à tous, et merci de lire ma question. Voilà, je dois maintenir un vieux classeur excel qui présente des dizaines de boutons (je suis sous Exc...

    ClefDeDouzeE... | Excel | Latest reply: ClefDeDouzeEtDemi Nov 3, 2020
    2 replies
  • modified code sum repeat data Solved/Closed

    hello actually i search code to sum repeat values and i have about 2000 rows so that's why i do that by code instead of ...

    abdelfatah_0230 | Excel | Latest reply: abdelfatah_0230 Oct 27, 2020
    6 replies
  • Changing values in one cell depending on drop down list values in another cell Solved/Closed

    Hello, I have created a drop down(pick list) in cell A1. In cell B1 I want it to show a specific number value based on which selection has been chos...

    Paul | Excel | Latest reply: TrowaD Oct 26, 2020
    4 replies
  • Problèmes de barres d'erreurs sur Excel 2010 Closed

    Bonjour, Je vous présente mon problème. J'ai calculé mes écarts moyens avec la fonction de Excel. J'ai ensuite fais "autres options de barres d'err...

    bloodykiwis | Excel | Latest reply: David Webb Oct 26, 2020
    1 reply
  • Loop through range to create new files with dynamic subfolders Solved/Closed

    I would like to have suggestions for a VBA code that does this: Generate an Excel file for each contract number. When copying the contract number t...

    Mo_1001 | Excel | Latest reply: TrowaD Oct 22, 2020
    3 replies
  • Restore setting password for G'Five H91 Solved/Closed

    Hello, I want to run restore setting on my G'Five H91 hendset, but I dont know what is the password use for it, Please Help Configuration: Wind...

    Gajendra Singh | Word | Latest reply: Chohan Oct 14, 2020
    3 replies
  • Add an asterisk to specific words Closed

    How do you formulate multiple cells in a calendar to place an asterisk at the end of the specific words: Eg: Homework due * (everyday Saturday) ...

    Laurence | Excel | Latest reply: TrowaD Oct 13, 2020
    1 reply
  • With picture names in column, add picture to fit cell dimensions Solved/Closed

    Hello, Im trying to create a macro to bring in images to fit the cell in the column next to the image name This is the code im using and its not wo...

    elenimac | Excel | Latest reply: TrowaD Oct 13, 2020
    1 reply
  • Document Convert to Base64 in excel Closed

    Hello All, I have a query is this possible in excel? I would like to add a document (pdf/image/word file) in excel. Can that document data be c...

    Raj_1562 | Excel | Latest reply: Raj_1562 Oct 13, 2020
    0 replies
  • Fill color in row if data is not available sheet 1 Solved/Closed

    Dear Experts, In Excel, I have maintained "NAME" and "CODE" lists in Sheet 2. When pasting (copied data from another source) the"NAME" and "CODE" ...

    Raj_1562 | Excel | Latest reply: Raj_1562 Oct 12, 2020
    4 replies
  • Grey out an cell and not allowed to enter depending on a cell Solved/Closed

    Hi All, Can you please help me on below request? In column B the name is entered the Column D partner name cell will be grey out and don't allow...

    Raj_1562 | Excel | Latest reply: Raj_1562 Oct 1, 2020
    6 replies
  • modified code create subfolder and save as pdf to it based on cell Solved/Closed

    hi, all i need help to amend my code actually the code works very well but i need some adjusting i would create subfolders based ...

    abdelfatah_0230 | Excel | Latest reply: TrowaD Sep 29, 2020
    5 replies
  • Encoding? Closed

    One of my documents is in text form. How do I read it? It is mostly squares.

    Gigglewitz | PDF | Latest reply: Gigglewitz Sep 26, 2020
    0 replies
  • Transfer data from one excel file to another excel file Solved/Closed

    Is it possible to transfer specific data using a formula from a single worksheet in an excel file to another worksheet in a second excel file?

    llewallen | Excel | Latest reply: saurabh2033 Sep 18, 2020
    2 replies
  • Auto generate serial number in excel based on Column Solved/Closed

    Dear All, I would like to auto update Serial Number based on column D in excel using excel formula. like: Thanks Raj

    Raj_1562 | Excel | Latest reply: TrowaD Sep 15, 2020
    4 replies
  • How to copy the Column value into Rows Solved/Closed

    Dear Experts, I would like to copy the team name according to the image shown below. For your reference i differentiate 3 combination but I wou...

    Raj_1562 | Excel | Latest reply: TrowaD Sep 14, 2020
    9 replies
  • Rearranging data Solved/Closed

    Hello, We work on a lot of data which is not structured the way we are supposed to use it. Am looking for a script in excel to search for a word in...

    liwate | Excel | Latest reply: TrowaD Sep 10, 2020
    1 reply
  • Auto generate serial number in excel based on input value Solved/Closed

    Dear Expert, I want to auto generate the S.No in column A5 based on input value. I have to enter the No. of record in column C3(Ex: 3).The serial ...

    Raj | Excel | Latest reply: Raj Sep 7, 2020
    14 replies
  • keep the data even after the date change Solved/Closed

    Hello, i have 2 sheets one is for the data called employee cost which is having a calculation of employees EOS and the other sheet is a report she...

    kal7667 | Excel | Latest reply: TrowaD Sep 1, 2020
    1 reply
  • Multiple Rows to one Row Solved/Closed

    Hi, I have data supplied as - And require it to be copied to this format- How can i do this without multiple copy and pasting. Than...

    ad1959 | Excel | Latest reply: TrowaD Aug 27, 2020
    2 replies
  • IF function with dates Solved/Closed

    Hello, I am trying to get a function to see if a pt needs to have an appointment made. I have been trying the 'if and function' to see if ther...

    ayudameexcel | Excel | Latest reply: TrowaD Aug 20, 2020
    1 reply
  • fixing complicated error populate data in listbox based on combobox and textbox Solved/Closed

    Hello, actually theses codes works very well in specific workbook i copy theses and adjusted what i need ranges names ..etc but it s...

    abdelfatah_0230 | Excel | Latest reply: abdelfatah_0230 Aug 7, 2020
    10 replies
  • Vlookup with condidion Closed

    HI Team Pls help to make a vlookup with condition as explained below. Data reference as below Column A Column B Colum C X1 ...

    Karthikeyan1207 | Excel | Latest reply: Karthikeyan1207 Aug 3, 2020
    2 replies
  • problem search data by selected combobox & datepicker tools Solved/Closed

    hello i no know why this doesn't work this code and there is no error it should when i select from combo box it should show d...

    abdelfatah_0230 | Excel | Latest reply: TrowaD Jul 23, 2020
    5 replies
  • problems with videos in powerpoint Closed

    Hello, When I use a powerpoint when teaching a class VIA Zoom the videos embedded in it are choppy and studder even when I reduce the size of the...

    redman | PowerPoint | Latest reply: HelpiOS Jul 21, 2020
    5 replies
  • Using VBA Code to extract data from a website Closed

    Hello, I have little to no programming knowledge or how to work with VBA. I was wondering if there was a way to write a VBA code to extract data...

    varun_1234 | Excel | Latest reply: Concensure Jul 20, 2020
    1 reply
  • how can I unmerge cells, delete empty col and rows, relocate cells and combine? Solved/Closed

    Hi dears, first of all, I have to thank every one who read this message and he try to help me. its a complicated matter to me. Actually, I re...

    alhaddadi | Excel | Latest reply: TrowaD Jul 16, 2020
    10 replies
  • Is it pointless? Solved/Closed

    When I am writing an important document, I always upload a copy to Google Drive every half an hour because I am afraid of loosing it, although everyth...

    informatique... | Word | Latest reply: informatiquetique123 Jul 14, 2020
    3 replies
  • How to Unlock A Password Protected Word Document Solved/Closed

    How to Unlock A Password Protected Word Document

    ankit213506 | Word | Latest reply: David Webb Jul 7, 2020
    1 reply