The discussions
Command button launches default browser via one line of vba code
SolvedI have a userform that allows me to use a webbrowser within it, however sometimes due to compatibility issues I need to use microsoft edge and use it ...
Macro to compare 2 columns and output list with singles and sheet reference
SolvedHello, I am trying to write a macro to compare two different columns on two different sheets. and I want to print only the values that are not on ...
How to split the amount in excel formula or excel vba code?
SolvedDear All, Hope you are doing well!. I would like to copy the value in cell based on user input value. Below is the sample screenshot. The use...
Conditionally formatting if another column contains a specific date
SolvedHello, I have a spreadsheet where I am tracking requests. I want Excel to highlight the row if the item due date (column B) is NEXT month or has P...
Moving the data into previous cell by using excel formula or vba code
Solvedhi all, I am working as Master data analyst. While working with data I got a problem, I have almost 10,000-row lines each having multiple col...
How to copy cell value from one table to another table with criteria
SolvedHi, Please help me with the below request. I would like to Copy the data from table1 (sheet1) to table2 (sheet2) based on the criteria "Yes" aut...
Grades in excel
SolvedHello, How do i do the grades in Excel for example if a learner gets 70% how do i classify that using the symbols to grade the result
Create multiple copies of excel based on a single template
SolvedHello there, I need your help. I need to create multiple excel workbooks using a single template and saving them based on a list of names which ...
How to fill value in cell if data is not available ?
SolvedDear All, Hope you are doing good! I would like to fill the product name as below in Cell if the nearby cell value is filled with some other te...
Create report balances for many customers
Solvedhi here this is the first post and I hope find what I'm looking for despite my request is not easy I have data in sheet1 contains...
How to store cell value in a variable excel vba or increase cell value in excel
SolvedDear 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...
Change colour of range of cells based upon text from a drop down menu in another
SolvedHi, 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. ...
Automatically run macro from a calculated cell value change
SolvedHello, I am not having any luck using this code(and haver tried others). Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address...
Auto copy data from sheet1 to sheet based on criteria
SolvedHello, 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...
Modified code copy data from userform to the empty last columns
Solvedhello this is the first post in this forum and I hope finding solution here I got this code from the internet and works wel...
Information transfer
SolvedHello, 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, ...
Copy rows to multiple sheets based on drop down validation
SolvedHello 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...
Macro that changes a row color at the change of each job number.
SolvedHello, 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...
Lookup dropdown list value in a another sheet and copy row accordingly
SolvedHello, 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...
If a cell has a value, make another cell indicate the number 1.
SolvedHello, 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...
Excel conditional formating using formula
SolvedHi 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...
Macro that copy/pastes rows based on a certain condition on same sheet.
SolvedHello, 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...
How to combine if, and, or functions
SolvedIncrement 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...
Computer master password needed
SolvedHello, my inspiron 1420 needs a system authentication password and ive tryed so many times to open it bt I need a master password plaese help me than...
How to convert an attached image to base64 format.
SolvedHi 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...
How to make a running balance column from a credit column and a debit column
SolvedHello, I am trying to create a running balance column from credit column and debit column. Everything that I have found regarding running balances on...
Populate multiple tabs in an excel spreadsheet based on changes to main tab
SolvedWe have an Inventory Issued spreadsheet with the main tab listing all of our supplies, prices for each supplies and beginning inventory, number of ite...
Data entered in one sheet automatically appearing in a master sheet
SolvedI 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 ...
If formula for a date range
SolvedI 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...
Conditional formatting: font color for entire column based on another column
SolvedHi! 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...
Clear cell contents based on value of another cell range using vba
SolvedI'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 ...
Splite the multiple column value copy & paste in other sheet
SolvedHello, 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 & ...
Copy data from one worksheet to another using spec criteria
SolvedHello, 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...
Where did page numbers go?
SolvedHello, 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...
Fixing populating values into textboxes based on showing data in listbox
Solvedhello I need help about showing wrong values in textbox(credit , debit & balnce) , it should show right value textbox (debit ) based o...
Matching 2 sheets
SolvedI'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...
Automatically replacing a value in an excel report
SolvedHello, 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...
Use of if
SolvedHello, 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 ...
Huge inventory assistance - duplicate a row based on a cell value or quantity
SolvedI 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...
Match partial text string in one sheet to another text string in another sheet
SolvedHi 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...
Quel bouton utilise cette sous-routine?
SolvedBonjour à 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...
Modified code sum repeat data
Solvedhello 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 ...
Changing values in one cell depending on drop down list values in another cell
SolvedHello, 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...
Loop through range to create new files with dynamic subfolders
SolvedI 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...
Restore setting password for g'five h91
SolvedHello, 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...
With picture names in column, add picture to fit cell dimensions
SolvedHello, 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...
Fill color in row if data is not available sheet 1
SolvedDear Experts, In Excel, I have maintained "NAME" and "CODE" lists in Sheet 2. When pasting (copied data from another source) the"NAME" and "CODE" ...
Grey out an cell and not allowed to enter depending on a cell
SolvedHi 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...
Modified code create subfolder and save as pdf to it based on cell
Solvedhi, all i need help to amend my code actually the code works very well but i need some adjusting i would create subfolders based ...
