The discussions
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...
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...
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 ...
Transfer data from one excel file to another excel file
SolvedIs 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?
Auto generate serial number in excel based on column
SolvedDear All, I would like to auto update Serial Number based on column D in excel using excel formula. like: Thanks Raj
How to copy the column value into rows
SolvedDear 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...
Rearranging data
SolvedHello, 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...
Auto generate serial number in excel based on input value
SolvedDear 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 ...
Keep the data even after the date change
SolvedHello, 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...
Multiple rows to one row
SolvedHi, 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...
If function with dates
SolvedHello, 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...
Fixing complicated error populate data in listbox based on combobox and textbox
SolvedHello, actually theses codes works very well in specific workbook i copy theses and adjusted what i need ranges names ..etc but it s...
Problem search data by selected combobox & datepicker tools
Solvedhello 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...
How can i unmerge cells, delete empty col and rows, relocate cells and combine?
SolvedHi 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...
Count cells containing text per row
SolvedHello, I am trying to figure out and if statement to add 1 if there is text in a row so that at the end of the row I will get a total for each time t...
How to hide/undie picture based on a cell a1=1/0?
SolvedHello, can anyone help me how to hide/unhide picture 1? if A1=0 then hide picture 1 if A10 then show picture1 thanks
Transpose data from vertical to horizontal
SolvedHello, this the code doesn't work i would transpose as what in existed in picture the result from e: h i hope somebody ...
Copying formula for multiple worksheets
SolvedI use ASAP utilities to insert multiple worksheets using a template. I'd like to create a formula that automatically inserts sequencial numbers. Ex:...
Adjusting code divide data of table into tables in each sheet
Solvedhi, my code really works but the problem when i add a new data it doesn't copy to the multiple sheets because the first time ...
How can i blink data in textbox on userform based on condition
Solvedhello i got this code from the internet about blinking in textbox by command button but i would do this without command button it's directly ...
Excel - how to count numbers in brackets
SolvedHello, I would like to know how to count the number of elements(digits) in the brackets after a word. exemple Bimbia(1,2,3,6,7,8). in the Brackets...
Fixing sum an subtract among sheets
Solvedhi, i search so much in the internet to fix my code to work but no answering so far i have 6 sheets it suppose copying data from a2...
Vba function code to highlight odd and even numbers
SolvedHello, I am trying to write a VBA Function code to highlight Odd and Even numbers. But not having much luck. Can anyone help me, please? I would ...
Help: need formula to find missing text comparing 2 cells
SolvedHello guys I have the same issue. A2: The price includes VAT B2: The price In the next column, I want the following value (the text difference...
Vba: color cells in table based on multiple condition
Solvedhello i do code by loop but it doesn't completely work i appreciate if somebody help me why it occurred and give me the alternative ok let'...
How to specify macro for current active sheet
SolvedHello, this is a very basic question, I am sorry to ask. I have created a macro in excel that I want to run in the current worksheet that is selecte...
Excel make cell flash red
SolvedHello, In Excel I can make cell red when formula is greater than 4 but how do I GET CELL TO FLASH Office 2003 And can you in same spreadsheet li...
Inserted row should paste in 7times in next sheet based on the date
SolvedHello, i have a template and from client a workbook will i should compare and paste the data if any new row der i should insert in template file an...
Vba to reference newest sheet
SolvedHello, Im a complete beginner in excel and the vba process. I'm trying to make a macro create a new sheet, copy the style/structure from a pre-det...
Macro to select multiple columns by columns specific headings to delete dupes
SolvedHello All, I have been struggling to find a code that allows me to select multiple columns by name to then delete duplicates in those specific colu...
Macro to compare 2 sheets and copy differences
SolvedHello, I’ve been working with this macro to compare two worksheets and copy the matches to a third sheet. Not knowing vb very well can someone show...
Combine cell text
SolvedHi, I am after an easy way to combine text in several rows into one cell. The number of rows that need combining will vary from 2- 10 (Would be...
