Excel Forum
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
(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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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 ...
-
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. ...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
convert a sentence in a cell with the American date [Closed]
Hello, I am trying to convert a sentence in a cell with the American date last to the sentence with Canadian date last. ex. CASH OVER/SHORT...
-
copy and paste values automatically to empty cells below [Closed]
Hi - for background, I created a "slot Machine" in excel that combines three random number generators and generates either a -$1 or +$10 if you...
-
VBA Help Needed [Closed]
Hello, I have written code to prompt the user to state how many new sheets they want to add. But I need for the data on the "Main" sheet to...
-
Compare the words in 2 columns in Excel [Solved/Closed]
I gt two different excel file . So now my task is to compare the words in the entire columns in excel file 1 and excel file 2 , then output a new...
-
Drop down menu, copy/transfer 2 new sheets only if cell has data [Closed]
Hello, I am trying to create a sheet that references items if they are selected from another sheet from a drop down menu. IF they are selected...
-
Excel forum within a range [Solved/Closed]
Good day I am looking for a formula PLEASE. Example Column A, Column B, Column C, Column D, Column E, Column F No, ...
-
Need to delete columns based on Column header [Solved/Closed]
Hello, I need to have an macro which will delete the columns from my excel based on the Column header. Exsample: I have the...
-
Compare 2 columns on different sheets and move data when match [Closed]
Hello, I need to match 2 columns of data from 2 different worksheets and when they match, I need to move data from another column from one...
