The discussions
Macros, button that copies data from certain cells into table
Hello, I am trying to create a "database" table on one sheet to record data that was calculated on another sheet. The issue is the data calculated...
Conditional formatting: 3 range of numbers
SolvedHello, would like to seek advice from some of the experts here. I want to do conditional formatting from column O6-O21. If percentage is a...
Reformatting a date in excel
SolvedHello, I could really use your help with Excel. How can I change a date formatted like this...03/12/2004...to just reflect the month and year...0...
Struggling with dependent text or list display in cell
Hi - thanks for reading I'm not sure if this is possible but I'd like to get the following to work: - Cell A1 contains a small pick from list -...
Expiration date search, copy to sheet2
Hi! I have a spreadsheet with dates in column C starting at C7, and other info to do with the dates in columns A through L Im wanting to have a c...
Copy data from one sheet in a workbook to another sheet
Hi, I'm trying to copy one sheet automatically in one workbook to multiple workbooks. For example the workbook is May 2015 Sales Numbers and the S...
Get a percentage in microsoft excel
Solved/ClosedHello, I am trying to get 10% of a number in another cell. rather than doing it in my head, I was hoping someone would know the formula. If you do,...
How to use name range..please help to solve this issue..
SolvedHello, i have a excel work book which has few name ranges eg namerange1, namerange2, namerange3.. how i can display the resultant like if column e...
Automatically syncing data from my master sheet to individual sh
Hi, What would be the procedure for automatically Syncing Data from my master sheet to Individual Artist sheet. I basically would be enteri...
How to change date in order of dd/mm/yy in excel 10
Hello, I want a solution for this!?! pls Configuration: iPhone / Safari 4.0
What it mean rs = 7: sheets(f1).select
Hello, im stater excel vba i see this code and im not clear what it mean please any one explain me.
Pop3 and smtp for yahoo.ca
Hello, What is Yahoo.ca not Yahoo.com mail's incoming mail server (POP3 or IMAP)? And what is the Outgoing email server's (SMTP)name?
Excel master list
Hello, I will be creating a spreadsheet with lots of text data, addresses, phone numbers, names, ect. I have all the data set up in rows so I will j...
Excel vba input data to next empty range
HI everyone, I am excel vba stater I have crazy problem to solve. I want to input data into range j6 by use inputbox and if j6 had value next input wi...
Exam layout help
SolvedHello, I want to display a classroom layout on sheet 2 using a list of names from sheet 1 I'm sure it's possible, I just don't know where to sta...
Conditional formatting cell if every cell contains "yes"
SolvedHello, I want to A2 (surname) and B2 (forename) to turn green if every cell in range C1:F1 equals "yes". At the moment it is highlighting A2 & B2 i...
I need my reset password
Hello, i dont no my gmail password plz help me Configuration: iPhone / Chrome 30.0.0.0
Replacing any alphabet with c, and number with 0 in an alphanume
Hello, I have huge list of alphanumeric string in each row. And I want to replace any alphabet with C, and number with 0 in an alphanumeric. e.g I...
Excel help
I think I need to use multiple formula to find this. I think an If function is used for sure. I need to find a formula that gives me the difference be...
Compare 2 sheets -> summary differences
SolvedFor an ongoing school project values of test subjects are changing over time. I would like to create a quick overview of these changes. Examples ...
Conditional formatting for a particular column
SolvedHello, I need to perform conditional formatting on a particular column, which should display the numbers entered into it, in 3 decimal format. ...
Copy & paste based on specific condition
SolvedPlease provide me the macro coding for the below scenario. I have four columns in my sheet 1 say Date,Name,Reference and Rate. When I am entering the...
How to search for a value in a range if found run a procedure.
SolvedHello, I am trying to get my spread sheet to run a Macro I have that is working nicely (that copies the row and pastes it to another sheet in the ...
Change the date format in excel 2007 worksheet
Hello, i want to know that howcan i change the date format in excel 2007 worksheet if i want it like :- yyyy/mm/dd regards, Amol. ...
Finding a date (n30) in a date range b5:b30 and returning a3text
SolvedHello, Thank you in advance for helping me... I really appreciate it. I believe I need an =IF formula.... I have a column with different dates ...
Removing false word in excel
Hello! How to remove the false word in this formula and retain only the amount instead? =IF(O50,VALUE(M5)) Thanks!
After pushing command button on sheet1, sheet 2 auto. opens up.
Hello, I have created a workbook with several pages of Information. One of the pages sheet2 ("Order Form") will figure information. There is a ...
Counting the number of times a cell changes colors and archive
Hello, Hello, I would like to count the number of times a cell goes green and archive it. How can I do this? Thank you for any help you can give. ...
Auto. copy a row of data onto another sheet using conditions
SolvedHello, I am new to VBA and I have two spreadsheets both in the same workbook. One sheet is full off information the other is a printable form t...
Auto populating multiple sheets
Hello, I have read some of the Qs and As and they are scary if you don;t know Excel. ! Is there not a simple formula for entering data into a sp...
Macros to copy conditional data
Hello, I am beginner in macros and am trying a macro code which does the following. I have 2 sheets by name sheet1 and sheet2, sheet1 consists of...
Amexxx1
Hello, I don't seem to be able to run this simple code; I copy and paste but when trying to run in my General tab by pressing alt+F8, no macro is ...
Macro to search for a word and put a code on the cell next to it
SolvedHello, I'd like to scan a column for a certain word ("TOTAL LINE") and put a code (e.g "a") on the cell next to it each time it finds it.In case tha...
Macro which can be calculated every month rent
I have 400+ agreements and the agreements start date and end dates are different. Also the rent incremental days and incremental percentage are differ...
Can't open scanned document when broken up into 2 pdf's
SolvedWhen I scan a large color document on the color printer, the PDFs that are sent to me via Email can not be opened. The error message indicates it is n...
Search functionality,copy and paste
Hello, I am new to VBA and looking for a search functionality macro.I am looking for three steps;- There are three sheets,in sheet one i just cre...
Repair outlook express dbx file
Solved/Closedhas a sent items.dbx file which is about 400 over MB.. when open it, there is only a few emails with the file size quite small. any recommended free s...
All my office apps are not showing its icon.
Hello, I am using Office 2013. Now I can only see the windows generic icon instead of the Office icon. I am using the Professional Plus 2013 full ve...
Send data from raw data sheet to numerous specific sheets
Hello, Trying to make a document in whcih my laboratory can track the reagents coming in. I have a source sheet, where all the recieved reagent...
Copying data directly to a specific sheet
Hi there! I am trying to create a spreadsheet in which I can enter information on one sheet and it automatically carries across that info to the c...
Date format
Hello, i have date format like 20131203 (year month day) i want to change it as 03.12.2013. please suggest Configuration: Windows 7 / Chrome 2...
It can not find the files
Hi i installed your program to fix the corupted files the system can not find the files it dont show in the list how to do that???
A macro to name worksheets based on a list
Hello, btw how to name worksheet without creating new worksheets, i've already have data in each worksheet so i dont need to create a new one.. I ...
Macro for blanks
SolvedHello, Would appreciate help! I have a spreadsheet which I run daily. The number of rows can change each time I run it (ie one day I have 5 rows; t...
Space bar problem
Hello, my space bar shows dots instead of space in word 2007 Configuration: Windows 7 / Mozilla 11.0
Generate id for cells containing same values
Hello, I am trying to generate the same IDs for cells containing same values and different IDs for cells containing different values I have for e...
How do i not get the sum of a column when it contains text?
Hello All, I have an excel file in which I am adding the numbers of a column, but sometimes the column I am summing may have text in one of the cells ...
Help with formula to find/remove if same data in another cell
Hello, I am having some trouble determining a formula that would help me with my problem below. I have a large Excel sheet and am hoping you can ...
Converting macro into function
Hello, How to change the below macro into a function, so that, we could invoke this macro as =image() Sub Picture() Range("A6").Select 'This...
