Excel Forum
-
need to create a macro to insert row from sheet1 into sheet2 Closed
Hello, I need to create a macro that will insert data from sheet1 into sheet2 based on the value in column D. The number of rows of data will var...
-
copy rows to new sheets if condition is met Closed
I'm trying to copy rows from master table sheet to different sheets based on the value of the cell in the column: The column "AL" contains several ...
-
copy rows to new sheet if condition is met (using macro) Closed
I'm trying to copy rows from master table sheet to different sheets based on the value of the cell in the column: The column "AL" contains several ...
-
Excel VBA that act like Template wizard? Closed
Hello, im kinda new to excel and vba itself. Recently i've been using Template Wizard to create a template and storing it into the database. But i fi...
-
Have to repeat list Closed
Dear all Please help out have to repeat two list in one list. Query: List A List B A 1 B 2 C 3 D Results List C A 1 A 2 A 3 B ...
-
Excel formula for percentage Solved/Closed
Hello, I am trying to get a formula to calculate the percentage of cell O3 from cell N2. The format is what percentage is my expense (O3) from my ...
-
Copy filtered data to sheet 2 Closed
Hello, i have a main sheet with say column Item name and BATest. i need to filter data of BATest and if Data is Analog input (for eg) then correspo...
-
Drag formula down depending on number in particular cell Closed
Hello, System Configuration: Windows / Chrome 57.0.2987.133 I don't know if it is possible but here we go :) I have data from columns A ...
-
If Statement Excel Closed
Hello! Im a complete green at excell, maybe i just dont understand how the if statement work or im not that smart as i think :P The thing i want...
-
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...
