Excel Forum
-
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...
-
Inventory Master List Help Closed
Hello, So I have a workbook with an inventory master list that i would like to pull inventory numbers from all of the other sheets in my workbook....
-
Record Scenario Iteration Results macro Closed
Hello, I have a financial projection spreadsheet that will result in a residual value in a certain cell. I want to run 1000 iterations using a macro a...
-
Record Iteration Results Closed
Hello, I have a financial projection spreadsheet that will result in a residual value in a certain cell. I want to run 1000 iterations and record the ...
-
Creating an auto updating sheet based on copy paste information Closed
Greetings and salutations. I've been trying to figure out how to create a score card sheet for our field technicians based on some automatically ge...
-
Copy data from workbook to another work book using date range Closed
Hello, i am new to this form and need some assistance in solving my problem i have below code which copy data into same workbook between 2 date ranges...
-
Reading text file containing data and output data in excel Closed
Hi, ...
-
Send reminder email 3 days before the date Closed
Hello, I'm new at this, any help will be appreciated. I need excel to send automatic email 3 days before expiration date. On my sheet theres...
-
Converting data in one column spanning three to four rows Closed
dear sir i have an address book over 500 addresses in column A. i am not able to index the book alphabetically i need to shift the data in a2 of ...
-
Macro for coloring cells according to the value of the cell Closed
Hello, I have 10 experiments. Every experiment has some info (for example temperature, pressure etc) like it is on the picture. So each experiment...
-
Macro for coloring cells according to the value of the cell! Closed
Hello, I have 10 experiments. Every experiment has some info (for example temperature, pressure etc) like it is on the picture. So each experiment...
-
Repeating a simple macro loop up to 1,500 times Solved/Closed
Hi All, Office 2013 user here with a first time macro question... I have a large XLSM file with simple text labels in Column A. There are 1,500 ...
-
Excel external data connection not working properly Solved/Closed
Hello, I made a connection between two workbooks where there is a master workbook and non-master workbook that uses the master as an external sourc...
-
Highlighting Multiple Cells When Using Complete or Partial Text Closed
I currently work at a distribution center, and each day we perform lane assignments for outbound products. Attached is an image of our lane assign...
-
Value look up Closed
Hello, On excel I have a master Sheet that I enter Names of people which is used to transfer the names to other sheets making it simple to print. H...
