Excel Forum

Ask a question
Results 151 - 200 of about 9,850
  • How to store cell value in a variable excel vba OR Increase Cell Value in Excel Solved/Closed

    Dear All, Excel is only able to store 32767 characters in one cell. But I retrieve the more than 50000 characters.So, I couldn't able to store i...

    Raj_1562 | Latest reply: vcoolio Apr 24, 2021
    1 reply
  • How to create a new sheet based on student Id numbers Closed

    Hello, I am trying to find a code that can make a new sheet based on my students name and ID number. I want to be able for the program to copy the...

    bookman35 | Latest reply: vcoolio Apr 23, 2021
    2 replies
  • Change colour of range of cells based upon text from a drop down menu in another Solved/Closed

    Hi, I am trying to change the colour of a range of cells within a row if I choose an option from a drop down box within the same row and cell range. ...

    Jim1409 | Latest reply: TrowaD Apr 22, 2021
    1 reply
  • Automatically Run Macro from a calculated cell value change Solved/Closed

    Hello, I am not having any luck using this code(and haver tried others). Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address...

    smiller | Latest reply: TrowaD Apr 20, 2021
    1 reply
  • Numbering increamental base on value in another colum Closed

    Hello, I have different numerical value in one column (say A column), I need to put serial number in another (B) column based in value in A colum...

    RPS | Latest reply: TrowaD Apr 20, 2021
    1 reply
  • Auto copy data from sheet1 to sheet based on criteria Solved/Closed

    Hello, I am trying to auto copy values from Sheet1, Col A to Sheet 2 only if criteria from Sheet1, Col b is met. I have tried so many different t...

    whatchatalki... | Latest reply: TrowaD Apr 20, 2021
    1 reply
  • to highlight or catagorize the data Closed

    Hi, I am willing to prepare the data under the catagory used and unused list checking the data table (data_plan) suppose C4A-R1 is placed in any ce...

    stha_naren | Latest reply: TrowaD Apr 20, 2021
    1 reply
  • VBA: Copy row ---> lookup value ---> paste in table Closed

    Hello, I need help copying a row then lookup a value and paste the row next to the value that has been looked up, constructing a table. Thanks...

    claudia | Latest reply: TrowaD Apr 20, 2021
    1 reply
  • match between two sheets and create summary Closed

    hello I'm a beginner in vba excel so I hope find assistance from the experts I have two sheets names are(sheet1,sheet2) I would compare data i...

    kalilme | Latest reply: kalilme Apr 20, 2021
    0 replies
  • transferring data Closed

    Hello, i am having trouble and hopefully someone can help me i am creating an invoice system for the company i am working for and i have created a s...

    tasha | Latest reply: vcoolio Apr 16, 2021
    1 reply
  • How to import multiple texte files to multiple Excel files using Power Query Closed

    Hello to All Need for help to import multiple csv/txt files to multiple Excel Sheets/files using Power Query Thanks

    Adama_69810 | Latest reply: Adama_69810 Apr 14, 2021
    0 replies
  • VBA New sheet and copy template Closed

    Hello, Im struggling abit. I want to make a button where I add a new sheet with a specific name. In this example, "App1". But I also want to c...

    Tinsmith | Latest reply: vcoolio Apr 10, 2021
    1 reply
  • Calendrier Closed

    Bonjour, Voici ma demande puisque je ne parviens pas à solutionner le problème ! En vue de mon prochain championnat, j'ai refait un nouveau calend...

    Caillou1360 | Latest reply: HelpiOS Apr 7, 2021
    1 reply
  • modified code copy data from userform to the empty last columns Solved/Closed

    hello this is the first post in this forum and I hope finding solution here I got this code from the internet and works wel...

    leapout | Latest reply: leapout Apr 1, 2021
    17 replies
  • Information transfer Solved/Closed

    Hello, I am trying to create a way for me to type in a part number as a list for tracking inventory and have the information (parts, description, ...

    bri_dubzz | Latest reply: TrowaD Apr 1, 2021
    1 reply
  • Rectify a specific value in specific rows from multiple sheets Closed

    Hello, I saw the answer given by Vcoolio that was very useful to me. And how to proceed with the rectification, on especific value, on rows from ...

    JDkas | Latest reply: TrowaD Mar 30, 2021
    3 replies
  • Copy Rows to multiple sheets based on drop down validation Solved/Closed

    Hello all, I have tried to find the answer to my query through other questions but can't put my finger on what to do. I would like to copy rows...

    Beckyx1 | Latest reply: vcoolio Mar 23, 2021
    5 replies
  • Macro that changes a row color at the change of each job number. Solved/Closed

    Hello, I have a spreadsheet that is say 5000 rows long and 15 columns wide and contains production job numbers in Column A. The details associate...

    Rick | Latest reply: vcoolio Mar 20, 2021
    17 replies
  • Deleting specific rows from multiple sheets Closed

    Hello, I have a question on how to do something specific in excel. I have a workbook with 3 sheets. Sheet 1 contains a master list of records. ...

    excelss | Latest reply: JDkas Mar 15, 2021
    3 replies
  • Auto-Populating Rows from Master Sheet into Other Sheets Closed

    Hello, I'm attempting to create a distribution list spreadsheet that will have all the names, emails, and agencies in one master sheet, and then h...

    lizadams1194 | Latest reply: vcoolio Mar 11, 2021
    1 reply
  • Export data from Excel to Microsoft Project Closed

    Hi Guys, Could someone help me in telling a way to export the data from excel to Microsoft Project automatically without having to use the import w...

    Anup27 | Latest reply: David Webb Mar 11, 2021
    1 reply
  • If function Closed

    Hello, I have done this function but it keeps saying false and that the formula is wrong even though I did what you suggested by using semi colo...

    Kye | Latest reply: Mazzaropi Mar 6, 2021
    4 replies
  • Lookup dropdown list value in a another sheet and copy row accordingly Solved/Closed

    Hello, I am trying to find out if I can create a drop-down list in Sheet1 that when I make my selection, it will copy part of a row from Sheet2 on...

    Torrey | Latest reply: TrowaD Mar 1, 2021
    3 replies
  • If a cell has a value, make another cell indicate the number 1. Solved/Closed

    Hello, If I have for example, any data entered into cell f9, how would I enter a formula to make the next cell, f9, indicate 1 or any specific numb...

    Raeneuf | Latest reply: Mazzaropi Feb 27, 2021
    1 reply
  • Excel Conditional formating using formula Solved/Closed

    Hi All Agian, I have a table with a list of customers and i have columns with the months and on each month i enter the visit day. I want to format...

    christossol | Latest reply: Mazzaropi Feb 26, 2021
    3 replies
  • Macro that copy/pastes rows based on a certain condition on SAME sheet. Solved/Closed

    Hello, I am trying to create a macro that will copy a row with 6 columns on the condition that the 6th column is blank. Then it should paste the r...

    jaime.mmm | Latest reply: TrowaD Feb 25, 2021
    1 reply
  • Help with Average/Lookup forumlas Closed

    I need help with a formula that will average numbers that meet a certain criteria. . I need break down the average results for each teacher and facili...

    MountainMama304 | Latest reply: TrowaD Feb 25, 2021
    1 reply
  • How to combine IF, AND, OR functions Solved/Closed

    Increment the backers count by 5 if: The launched at month is January OR September The city is Vancouver AND the country trimmed is Canada If these...

    MLC10 | Latest reply: TrowaD Feb 23, 2021
    1 reply
  • Copy row to another sheet if two (2) criterium are true Closed

    Hello, I have a worksheet with seven columns. I need to copy some information to another sheet if b2 is a certain color AND g2 contains contains c...

    terridw | Latest reply: vcoolio Feb 15, 2021
    1 reply
  • FALSE in Excel spreadsheet Closed

    Hello, I wonder if anyone can tell me why I am getting a 'FALSE' entry from the following formula: - =IF($E$3=Sheet1!$A$1,Totals!E6,IF($E$3=She...

    William | Latest reply: Mazzaropi Feb 12, 2021
    1 reply
  • How to convert an attached image to Base64 format. Solved/Closed

    Hi All, Hope you are doing good! I would like to convert the attached image into Base64 format in excel via VBA. Is it possible to change the i...

    Raj_1562 | Latest reply: Raj Jan 28, 2021
    2 replies
  • How to make a running balance column from a Credit column and a Debit column Solved/Closed

    Hello, I am trying to create a running balance column from credit column and debit column. Everything that I have found regarding running balances on...

    EerinSanchez | Latest reply: TrowaD Jan 28, 2021
    1 reply
  • Populate multiple tabs in an excel spreadsheet based on changes to main tab Solved/Closed

    We have an Inventory Issued spreadsheet with the main tab listing all of our supplies, prices for each supplies and beginning inventory, number of ite...

    djhenry66 | Latest reply: TrowaD Jan 28, 2021
    1 reply
  • Copy multiple cells info from sheet if value greater than 0 in another cell Closed

    I'm trying to go row by row for a range (c3:c177) to move information from multiple cells in that row that are not grouped together on one sheet to an...

    Tbonekiller | Latest reply: vcoolio Jan 24, 2021
    1 reply
  • Macro to insert row based on variable cell value (text) Closed

    Hello, I receive a large data file every week that needs to be formatted into an accounting journal entry. I have very basic VBA knowledge but it w...

    deadxcell | Latest reply: vcoolio Jan 20, 2021
    1 reply
  • Data entered in one sheet automatically appearing in a master sheet Solved/Closed

    I have an inventory workbook with 5 worksheets inside; One of the sheets is a master listing all inventory items. The others are dedicated to type of ...

    researcher064 | Latest reply: TrowaD Jan 18, 2021
    1 reply
  • 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 | 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 | 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 | 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 | 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 | Latest reply: TrowaD Jan 5, 2021
    1 reply
  • 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 | 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 | Latest reply: vcoolio Dec 28, 2020
    12 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 | Latest reply: abdelfatah_0230 Dec 25, 2020
    11 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 | Latest reply: TrowaD Dec 24, 2020
    1 reply
  • 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 | 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 | Latest reply: TrowaD Dec 7, 2020
    3 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 | 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 | 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... | Latest reply: ClefDeDouzeEtDemi Nov 3, 2020
    2 replies