Excel Forum
-
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...
-
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...
-
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. ...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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
-
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...
-
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...
-
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...
-
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, ...
-
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 ...
-
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...
-
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...
-
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. ...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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 ...
-
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...
-
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...
-
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...
-
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 ...
-
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 & ...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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 ...
-
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...
-
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...
-
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...