Excel Forum
-
How to compare two excel sheets and combine matching data [Closed]
Hello, I'm looking for a macro that will match data in column A from sheet 1 to the data in column A from sheet 2 and copy the corresponding rows f...
-
Generate new workbooks based on column value from multiple works [Closed]
I am a beginner in VBA. Basically I need a code that generates a new workbook for each specific column value in multiple sheets. The key in each sheet...
-
How to auto-populate values from certain cells into a new sheet [Solved/Closed]
Hello guys, Hope everyones doing okay. I've been working on a billing sheet for a company with multiple product codes and rates etc to be pulled f...
-
Copy and Paste entire row if a specific cell agrees with if cond [Closed]
Hello guys! I have been writing a vba code for a while and I cant find the mistake that I am making... I have a big table and I am comparing the va...
-
Date entered wrongly [Closed]
Hello, I entered dates as 'Apr 24' wherein I meant 24th of April..Excel has taken it to be '01 April 2024'..how do I correct all such entries, if ...
-
How to highlight a row when I enter a date in column I [Closed]
Hello, I am trying to highlight a row when I enter a date in column I. How is this achieved?
-
Copy Specific number of rows and insert n time after 3 rows [Closed]
Hello, Please help I want to Select & copy 35 rows data and after 3 rows I want to insert the copied rows n number of times. I need the Row widt...
-
Transfer data [Closed]
I have an excel spread sheet that has columns for last name, first name, office locations, and date. I may have 10 items listed in the column locatio...
-
Highlight only one column which has greater value [Solved/Closed]
Hello, i am inputting numbers in column A , B , C and D so i wanna highlight only one column which has greater value from others. is there any pos...
-
Using macro beta [Closed]
Hello All, Looking for a help here. Below is the data I am putting for understanding-- Column- A B C D E F G Row 1 - ...
-
Spellling error in Excel [Closed]
Hi Friends 1st, i want to say sorry for my broken english 2nd Did any one noticed what is resulf if you have only 00.50 Cent and your Spell num co...
-
Multiple data types in Excel [Closed]
Hello, I had a group of members contains in 4 fields and all these are enter into one simple format (example certificates) which is seperate works...
-
Date conversion in Excel [Closed]
Hello, how to convert birth date in word in MIcrosoft excel
-
Consolidate data from multiple sheets to one sheet. [Closed]
Hello, I have a workbook containing customer data (name, contact #s, addresses, etc.). The workbook is broken down into sheets according to which ...
-
Unprotect VBA project with a macro [Closed]
How can I unprotect a Excel Book VbaProject with code VBA (I know the protection password)
-
Auto update hyperlink on the other sheet [Closed]
Hello guys =) Please help... I have a sheet with names and IDs which are in hyperlink and the same data i have also in the other sheet. If the I...
-
Automate transfer data from masterfile to another sheet [Closed]
Dear All, Hope you guys are doing well. I am not an expect in excel, I really hope you guys can provide me some sort helps/advise/how to automat...
-
Transfer rows to another sheet via color or letters of row [Closed]
the Excel sheet has information pertaining to record numbers. I check numeric record from a database and see if they are correct. if the information i...
-
Formula cell value change [Closed]
Hello, I have 2 columns..... say A & B If I type "Approved" in Column B1, then A1 should automatically change to "COMPLETED" If I type any ...
-
Reminder by cell flashing /blinking [Closed]
Hello, Hi! I have a trouble call log. This is what I want to do.... Have a cell (or row of cells) flash or blink at a specific time from when...
-
Excel if statement with multiple text values in a column [Closed]
Hello, I am using excel 2017. I am trying to use this if statement to give me a value of 1 or 0. =IF((CQ2="Computer");1;0) The problem i...
-
Changing format of date in Excel [Closed]
Hello, Good morning, please I have a question. Question: Want to make use of a function such that with a date ( e.g 2/1/2017 formatted to b...
-
Excel 2016 filters do not work [Closed]
Hello, My filter stopped working in 2016. It is completely inactive - doesn't show any other option only the one it froze on. In the menu the filt...
-
VBA code to range of days [Closed]
Hello, Please help guys... I have a code below: Sub Auto_Open() Dim r As Long For r = 2 To 53 If Range("I" & r).Value = Range("I...
-
Copy full row in Excel [Closed]
Hello, I want ti copy full row for example B2:H2 if cell L1 is having text "unlisted". Please help
-
Conditional formatting [Closed]
Hello, If I have a value on one cell "D3"of let's say "2" and in cell F3 a value of let's say "1" then I want cell G3 to say a text, let's say "Good"...
-
VBA Worksheet data transfer [Closed]
hello, I haven't done anything with code for years and I am so lost in this, I have a table on sheet 1 which goes from A-J and 1-8221 and conta...
-
Run all vba at once after opening excel file [Closed]
Hello, Please help me. I want to run the macros at once after opening the excel file. I have different codes in each sheet. Please i need yo...
-
Looking up 2 columns and displaying 3rd column on new sheet [Closed]
I am trying to figure out how to display the color onto a second worksheet. If column a=1 AND column b=1, then I want the value of C2 displayed on...
-
VBA for birthday message box alert [Closed]
Hello, Please help me. I am very new in vba. i have no idea how to create codes. I have names in in column b and birth dates in column c. I need...
-
Run a Macro only for specific cells [Closed]
Hello, can you please help me with one problem I am currently having with Excel Macro? I want to be able to run a macro only for specific cells .....
-
How to repair xlsx Excel 2010 Microsoft file? [Closed]
Hello, How to repair xlsx Excel 2010 Microsoft file? I see a file with non-zero size but cannot open it. System Configuration: Windows / Chrome...
-
Enter data into a master sheet to update subsequent sheets. [Closed]
I'd like to be able to enter data into a master spreadsheet which will update other spreadsheets to prevent me from having to enter the same data seve...
-
lookup unique text values with criteria [Closed]
Hello, Data as follows cheque date tr code amount realised on 1/Jan/2011 164845 1000 1/Jan/2011 1/Jan/2011 154375 2000 1/Jan/2011 1/...
-
Search and code [Closed]
Hello, so I have this problem in excel where I need to compare the words that are in a certain cell and compare them to the separated word if it finds...
-
Macro Code Help - Copy Row Based on Criteria Paste on One Sheet [Closed]
Hello, I have a spreadsheet that is tracking sales number from multiple sales people. Each person has their own tab & all the columns are the same...
-
Auto populating data [Closed]
Hello, i have to daily update supplier name, part name , part number to my daily list . i want it to auto populate this to all my master-sheet , i ...
-
Formulas [Closed]
I know the basic but I am trying to formulate cells that will automatically that when you enter a figure in the cell it will multiply that said number...
-
Automatically insert rows in associated spread sheets [Closed]
Hello, I have created an accounting workbook of 15 sheets to produce accounts and associated information for a group of around 85 people. The names...
-
Formatting a cell containing text [Closed]
I have a task tracker where once the task is completed and the 'hasten' cell is 'yes' then I want the entire row to be formatted so the text within th...
-
Copying data to a separate sheet but only when text is present [Closed]
Hello, I have a long list of data and want to transfer the data which only has a launch date allocated to a separate sheet as a summary. And whe...
-
IF formula needed [Closed]
Hello, I need a formula that goes like If cell 1 > cell 2 then write "winner is column A header " if cell 2 > cell 1 then write "winner is col...
-
Microsoft Excel training [Closed]
I want to complete knowledge about excel what's doing work properly
-
Pop up alerts even if Excel worksheet is not open [Closed]
Hello, I only have basic knowledge in advanced excel and zero knowledge of vba and macro. In one sheet of the workbook i have a list of employees...
-
Data auto population [Closed]
Hello, I have to maintain record of calculate PPM for day, weekly, monthly, year, and supplier-wise contribution to that PPM by just feeding it onc...
-
How to average a time field format 00:00:00 (hrsminutes/secs)? [Closed]
have a document that won't average a six digit time field. need to convert to ?
-
True or False Value based on 3 difference cells' criteria [Solved/Closed]
Hello, I need a True or False (or Y/N) return if for example: A1>=30 AND B1>=80 AND C1>=80 but I have been unable to get IFS to work with t...
-
Copying rows with data from multiple sheets to one master sheet [Closed]
Hi guys, I'm trying to figure out how to copy rows from multiple sheets with values in column Q to a master sheet. I have seen a set of codes a...
-
Saving input into 2nd worksheet while keeping the 1st empty [Closed]
Hi there, Spoiler alert: Excel dummy I hope you can help me with this. I need to have a worksheet that would be used on daily basis and can be ...
-
Compare and separate data [Closed]
Hi, I am obviously new to the forum here, but I came across a question kind of inline with my own on here and wanted to see if I could get some hel...
Subscribe To Our Newsletter!
DON'T MISS
- Computer Boots to Black Screen
- How to Get Free Diamonds in Free Fire
- How to Recover a Disabled Facebook Account
- How to Upload High Quality Photos to Instagram
- How to Install a VPN
- How to Fix a Blurry Snapchat Video
- How to Disabled Write Protection on a USB
- How to Get More Followers on Instagram
- Facebook Code Not Received
- How to Recover Your Yahoo Account
- How to Create a Gmail Account