Excel Forum
-
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...
-
Conditional Row Copy/Consolidate Closed
Hello, I am working with a database that deals with student scheduling in schools. I am getting repeated lines for each class a student is enrolle...
-
How to create a macro to copy and paste Closed
How do I create a macro in excel to copy and paste row 1 through 18 in column A into column C. I want to copy and paste every 18 rows in order in colu...
-
Auto create new columns Closed
Hello, I have a spreadsheet where I track attendance for my church throughout the year. We have events that happen on a daily basis. Most days I o...
-
Macro for coloring cells depending on values and presenting them Closed
Hello guys!! I have an excel file with 2 columns of percentages. The first column has theoretical values of an experiment and the second column has...
-
Index formula questions Closed
I have an index formula that will be calculating price points based on the values entered into the excel document. Is there a way to make sure that th...
-
Using VBA macro logic in Excel Closed
One static Excel workbook with a ton of raw data that has a static number of columns (A-EK) that is always the same but the lines (1-X) is not static ...
-
Macros Closed
I have a spreadsheet of 15000 lines, I need to copy the Cell ranges B:E onto the next line B:E, then go down to the next populated cell and do the sam...
-
Help creating macro Closed
Hi, I have multiple excel sheets in multiple folders. I want to copy part of excel sheets which are in multiple folders and paste it in a new excel sh...
-
What function of Excel does this? Closed
Hello, I know there must be a function in Excel that does this but I don't know what. If you know, please share or if I need a piece of code then ...
