Excel Forum
-
how to convert ounces (oz) to milliliter Closed
Good morning to all, can someone please tell me how to convert ounces (oz) to milliliter s (ml). Thanks JPortillo
-
Font Change with another cell entry Closed
Hello, I have "text" in cell G18. However, I want the font color to change based on any currency amount entered in cell J18 System Configuratio...
-
create macro on one sheet to update on another sheet Closed
Hello, Trying to create a macro that will update data onto another sheet. Further this other sheet will be spending on the file path that the user ...
-
Finding sort based on gene name Closed
Hello, I have 2 gene lists with corresponding expression from 2 different cell lines, I am trying to compare the expression of each gene in the tw...
-
The date does not show up as entered. Date format. Closed
I am working with excel 2007 and the dates I enter show up completely different than the data I input. For example: I enter 050116 (no separators) ...
-
Future date based on text result and previu Closed
Hello, I'm not very good at this and am struggling to find the correct formula to calculate future dates but with multiple variables and cells as ...
-
A macro to create new, copy and name worksheets based on a list Solved/Closed
Greetings, I need a macro that can automatically create new, copy (existing worksheet say '100') and rename the new worksheets, based on a list that ...
-
Need Help creating an IF THEN scenario Solved/Closed
Hello, I am looking for some help with a problem. I have a big list of items within Excel and I am wanting to consolidate the big list of items do...
-
Comparing and merging excel files Closed
Good afternoon, Each month, my client sends me an Excel file of their updated widget list. The client's file is 26 columns in total. My file is cl...
-
date format for excel 2016 Closed
Hello, I need to change the date format to dd/mm/yyyy in excel 2016... so that when I save as a .txt file and the date should appear in the follo...
-
Introduce color gradient of col A based on the value in col B Closed
Hello, I am looking for a small help. I have 2 columns A and B, I have text written in A and numbers in % in B. Based on value in B, i want to add...
-
trying to populate columns F, G, H, I and J Closed
I've attached a photo for some clarity. I am trying to populate columns F, G, H, I and J based on the info from columns L, M and D. I've tried P...
-
comparing two files, exclude header from selection Closed
Hello, please help with the comparison of two excel sheets using macro. The one I used is - Sub All_Diffs_Highlighted() Dim wb1 As Workbook...
-
A macro to copy/paste a cell and other cells in the same row Solved/Closed
I have two wooksheets in a workbook. I need that a value of each cell in a range C3:C52 in sheet 2002 is being searched for in the range B2:B101 of th...
-
Excel Formula Parent/Child Heirarchy assistance required please Closed
Hello and good morning, I respectfully would like to ask for assistance please with an issue I'm having to find an Excel formula to compare data f...
-
Weekly Data Imports to track status changes and new line items Closed
Hello, What method would I use to import data into excel that contains line item numbers that increase each week? Additionally each week the numb...
-
Populate a worksheet from an imported template. Closed
Good Afternoon Currently in my spread sheet There is a Main page, on that there is a button called 'CREATE NEW CLIENT'. When clicked it runs this m...
-
Excel Macro help, copy rows and paste rows X times below Closed
Hello, I need an macro to simply the below operation. I want to copy below text x times A B C D E F G If I want to output it 3x, t...
-
Trying to simplify data in Excel through VBScript Solved/Closed
Please help desperate novice: In Excel, I have 5 columns: Bob Dad 12 13 blank Sue Mum 34 56 22 Gill Daughter 23 67 34 Jock Son 24 55 blank ...
-
Lookup formula to find names. Closed
Hi All, Thanks for your time. column C is from 1 to 12 column D is an amount I have a table of numbers which categorized the numbers with...
-
picture browsing using excel data Closed
Hello, please proving coding for above requirement thanks
-
any one can help. Closed
Hi All, column C is from 1 to 12 column D is an amount I have a table of numbers which categorized the numbers with specified amount and catego...
-
Data draw issues Closed
Hello, We're trying to create a document that displays the amount of homework hours for students based on the totals found in separate excel docum...
-
Conditional Formatting Closed
Hello, I am trying to change a text color of one column based on another columns value. For example in Column A if it shows a W then the Dollar amou...
-
How do I use conditional formatting in Excel Solved/Closed
Hello, i am new on this excel things but, i need it for work.. so, here it goes. is it possible if it like this ? example : A B C if A conta...
-
Parent/Child flat heirarchy formula needed Closed
Hello, I need to compare data from one column to a another column in a hierarchy level, so if the level is 1, there is information in different co...
-
Move named data from rows to same named columns Closed
I have a spreadsheet that has different test results for the same patient listed n multiple rows. I need to have all the results for the same patient ...
-
How to simplify data entry Closed
Hi All ok I have a daily sheet that i fill in every day it contains 5 fields I have another worksheet that i then copy the information from the...
-
(Excel Vba) Copy paste of multiple columns Closed
Hi All, I am stacked with a simple VBA macro. I have an excel sheet containing a number of columns and i have created a Montecarlo simulation where c...
-
onclick the button view the time in activecell Closed
Hi, I am using this code it's run successfully but each time click the button then overall change the cells. I want each cell view the current time...
-
Clear the previous Image Closed
Hello, I have inserted the image in excel sheet by entering the code in VB. On reload it overwrites the new image on the old image rather than firs...
-
Transferring Data Closed
I have monthly payment sheet for each student. I need to take the full roster of payments made to transfer to the individual monthly payment sheet fo...
-
Date drop down on front sheet that will create new dated tabs Closed
Hello, I am trying to create a workbook for recording daily pressure readings from different systems and I am trying to create a front page with a...
-
Excel VBA - Find and Expand matching cell entries Solved/Closed
Hello I have a list of 10 digit numbers in each row of a column range. Some of the numbers start with 3 zeros (000) which results in Excel ignoring...
-
How to populate information on multiple sheets at once Solved/Closed
Hi all, I hope someone can help me figure this out. I have been imputing information on multiple sheets in an excel workbook for quite a while now ...
-
Unable to download complex tables data on webpage using Query Closed
Hello, I am trying to figure out a way to download the data from this webpage, which has 4 collapsible sections but no luck whatsoever yet. htt...
-
Comparing Excel Sheets and copying changed data into a new sheet Closed
I'm trying to compare a master excel sheet to updated excel sheets and create a new sheet with the new data. For example: Master Data Sheet has Name...
-
Creating 1 master sheet from data from multiple sheets Closed
Hello, So I am at a complete loss on how to solve my problem. I'm brand new to excel and any help would be much appreciated. What I'm wanting t...
-
Copy and insert rows n number of times in Excel Solved/Closed
I am trying to create a macro under Excel. My data is as follows: Col1 Col2 Col3 Col4 Col5 Col6 Col7 A1 1080 90 M 40 45 50 A2 999 90 M 25 ...
-
Populating a Summary Report Closed
I've been tasked with taking a large worksheet (>20K rows and 25 columns) and populating a summary report in a (pre-labeled) different worksheet. The...
-
Autopop Info on Sheet based on Criteria from Master Sheet. Closed
Hi All, I am creating a Master spreadsheet that has information across rows. I want this information to auto-populate on a different spreadsheet dep...
-
Date format not valid Closed
Hello, Sir i would like you to help me on the following problem, i am filling an application form and i have done everything but on the date side ...
-
Splitting data from worksheet to workbooks based on column Closed
Hello, The code gives prompts me to enter the column on which the split needs to be done, but soon after that thrown an error:Run-time error '1--4...
-
If/and function Closed
i need to update a spreadsheet on the progress of documents being approved. i want to create a function that states if the document is "approved" (...
-
Automatic when excel open reminder mail go through outlook Closed
Hello, I wan to know how to send reminder mail from excel when it open and when before due dates of 3, 7, 30 days before multiple reminders I wan...
-
Shortcut to edit a cell without using F2 key Solved/Closed
Hello, I'm working in excel (excel 2010) and using a Logitech Bluetooth keyboard. Normally to edit a cell, I would select the cell and hit F2, bu...
-
Selecting a block of cells depending on the values of two others Closed
Hi all I'm pretty new to macros and I have been unable to find the answer to this question anywhere. I'm trying to write a macro that will selec...
-
Conditional formatting based on column of values Closed
Hello, I would like to do conditional formatting column B if its part of text matches with values in any cell of column C. Could you please help m...
-
Macro to create worksheets and copy data from a summary page Closed
I have a workbook called Sales Commission and sheet 1 is my summary page. I want to write a macro that will look at the summary page and from column ...
-
Conditional format if hyperlink Solved/Closed
Hello, In my workbook I have conditional format background color is green if there are a certain value in the cell. The text in the cell has font co...