Excel Forum
-
Search for input criteria, return designated cells. Solved/Closed
Hey all, I am trying to write a VBA command/macro that essentially takes a criteria input from the destination worksheet, searches and matches the ...
-
Inserting and formating date with userform Closed
Hello, I am trying to Insert a date with a Textbox in a Userform. It should have this format: Friday, 18.08.2017. This entered Date is used...
-
Copying dates to another worksheet. Solved/Closed
Hello, I found this script from vcoolio, thanks for that! Sub Advise() Dim x As Integer Dim lRow As LonglRow = Range("E" & Rows.Count...
-
How to convert numeric into words in Excel Closed
What is the formula to convert numeric in words?
-
Excel formula - Add days to date based on drop down selection Solved/Closed
I want to add days to a date based on options selected from a drop down list. For example, if cell C5 reflects "New Hire" or "Post New Hire", I want ...
-
Comparing Two Excel Sheets and copying like data to third sheet Closed
Hi, In your below coding, I can copy paste the alike data from sheet 1 only, I need to copy paste both from sheet 1 and sheet 2 line by line matchi...
-
VBA: Cell Range Closed
Hello, I am a beginner with VBA and I have a question that might sounds stupid to some. I have created a function of IfElseIf and I want to run it...
-
Search for text , cut and paste into new work sheet Closed
Hi , can anyone help me with the below vba code : Logic Find text If next row starts with number Then - cut 1 row above text and 3 rows below ...
-
Dropdown menu disappears quickly before you can even choose Closed
My excel has been acting weird lately. All dropdown menu disappears quickly before you can even choose your choices. This happens in Data Filter fun...
-
Transfer data from one sheet to another Closed
Hello, i have started an inventory sheet on excel what I want to do is take the list of inventory and when it is sold, have it transfer to the second ...
-
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...
