The discussions
How to populate information on multiple sheets at once
SolvedHi 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
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...
Creating 1 master sheet from data from multiple sheets
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...
Populating a summary report
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.
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
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
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
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" (...
Shortcut to edit a cell without using f2 key
SolvedHello, 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
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
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
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
SolvedHello, 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
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
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
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
SolvedI 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
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
SolvedGood 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
SolvedHello, 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
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
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 ...
Auto generate dates
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
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/ClosedHello, 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 ??
what is the Numbe shoud be instead of ?? My Values fixed No Results 70064 ?? -11 1721118038 ?? ...
Need macro to copy certain data from a form on one tab to a log
Hello, Trying to copy data from a form on one tab to a log/data list on another tab and advance to the next line on the log for the next user ...
Vba coding to copy data from one worksheet to another worksheet
Hello, I would like to know how to use vba coding to automatically copy data from one worksheet to another worksheet based on a specific criteria an...
Filter between 2 dates
Hello, please i want to filter data between 2 dates (start date and end date) with textbox and button command, i am new to programming in vba; plea...
Excel - a macro to create new workbook and copy data
Solved/ClosedIn the example below, I want to copy Column A starting from row 2 ie: "Age" till the value available ie: "Code and column B starting from row 2 ie: "2...
Excel - macro to create multiple sheets
SolvedHello, I have 16 sheets in excel. each of those represent a location (office) and they need to pull information from sheet1. This is for credit ...
Comparing columns and returning value
Solved/ClosedHello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: Column: A...
How do i calculate vat inclusive
Hello, how do i calculate VAT inclusiev? for example, TZS 849235 is vat inclusive, how do I take out the VAT? Taking VAT as 18% System Configur...
Change of date
Hello, I Want to change date format mm/dd/yyyy to dd-mm-yyyy in MS Excel 2003 Please solve my problem urgently System Configuration: Windows ...
Import .pdf ...?
SolvedHello everybody, Thanks so much for this thread, it has been extremely helpful! I have used the basic code suggested by Trowa, and it works for...
Highlight date range if cell containing date falls within that range
Good day! I have a list of static date ranges and would like to highlight a range if a date occuring in that range populates in a different cell....
Freezing column and row
Hello, how do you freeze first column and top row in excel?
Change a cell content according with the color of another cell
Hello, I´m using Excel and need to change the VALUE of a cell (need to appear "-") if the COLOR of another cell is PURPLE. After digging around wit...
Pasting and deleting macro
Hello, I need to create a macro that paste macro buttons from one spread sheet to another spread sheet, but when I try to do this and assign the mac...
Nestle fomula nightmare!!
Sorry - fixing mini typo Hello - any help!! Going bald ripping hair out trying to resolve! I want to return a value "Q1" if a date falls between...
Need help on excel macro
I need help to create a macro which helps me to get data from 'Sheet1' and paste that number of counts in 'Sheet2' for example, i have a table in s...
Edate in excel help
Hello... I have a training for log for a large number of staff for various different courses which have all been completed at various different dates ...
Excel for mac date formatting
Hello, I have two columns one for the month/day and one for the year. When I formatted the month/day column it automatically adds the year in whi...
Format excel data
Hello, i need to modify the data in my excel. Right now the data looks something like this: case A start 51 stop 55 ...
Copy rows from one tab to another - if specific criteria in col
Hello, In a file, I am trying to copy data from one row of a worksheet if specific criteria are met in one column to another worksheet. Ex: ...
Formula
SolvedI need some help with a formula, everything I try just doesn't work. I usually don't have this problem with Excel today is my day. I have a colum...
Help for time reminder in excel
Hello, I entered some date in excel and I need to be reminded one day before that expected date !! How do I code it so that I will get a reminder ...
Graduate number in a cell
Hello, I have this database on Excel that I want to create. One of the columns will have the date of birth (DOB) and another column will have the...
Software for finanicial
how can i get a software for account system tally ,quickbook
Countif coloring of cells that were used.
Hello, I would like to color cells (or a row) that were used for "countif" values. for example, at my work, i have to indicate private calls f...
