Excel Forum
-
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...
-
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 04/01...
-
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 don't ...
-
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 always ...
-
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 colu...
-
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 then...
-
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, Start, End, ...
-
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 columns, Name...
-
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 workshe...
-
Copying An Entire List of Formulas into another Work Sheet [Closed]
Hello, I have a list of sumif statements that I would like to copy from one excelsheet to another. Can this be done all at once, without changing ...
-
Caculating the number of months between a set of dates [Closed]
Hi, I am trying to calculate the number of months between two dates that relates to a specific time frame (financial year). Is anyone able to su...
-
Auto Generate Dates [Closed]
Hi All, I am currently working a excel formula to input a Revision_Date in column A then it will auto generate the number of days per month(only we...
-
Summery Sheets [Closed]
Dear All, I am maintaining a File in Excel for Employee's Vacation and every year has a different file. In this file I am adding a new Sheet by the...
-
Auto generation of code [Solved/Closed]
Hello, we facing issue in the auto generatation of vcode. it asking CUSTOMIZE HERE TO SUIT YOUR NEEDS . what code to be fill for this? kar...
-
what is the Numbe shoud be instead of ?? [Closed]
what is the Numbe shoud be instead of ?? My Values fixed No Results 70064 ?? -11 1721118038 ?? ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover Your Yahoo Account
- How to Upload High Quality Photos to Instagram
- Computer Boots to Black Screen
- How to Fix a Blurry Snapchat Video
- How to Recover a Disabled Facebook Account
- How to Install a VPN
- How to Get More Followers on Instagram
- How to Create a Gmail Account
- Facebook Code Not Received
- How to Disabled Write Protection on a USB
- How to Get Free Diamonds in Free Fire