The discussions
Remove or clear data
SolvedHello, I am grateful if this query be solved. If user Enter any value in C2 and also user enter "Best" or "Worst" in Cell D2, how it may clear th...
Enter data to run command button
Hello, How can I prevent a command button from running before data is entered into a cell? I have a workbook that refreshes data based on when a...
Multiple if in data validation
SolvedHello, Its being requested please help in the below multiple IF function used in Data Validation =IF(ISNUMBER(E2),AND(E2>0,E2
Formula - if (text), "text"
If a column has a number entered into it, the second column needs to auto populate with corresponding text. eg column I: User enters "22" co...
Using command button to post on another sheet!
Hi, So to brief you..I created a database that has a searchable drop down combo box that gives you suggestions as you type. I have my combo box se...
Lookup functions
I have a spreadsheet with various tabs including data which has been dumped in from various sources. Data includes: worked hours by department, and pr...
Conditional formatting of one based on the other cell.
Hello, I was wondering if there is a way I can say to excel without coding: 1)IF cell A1 is equal or greater [equal or less] than cell B1, then...
Conditional copy of cells with corresponding values
SolvedI have a list of variables in column A. I also have their values in column B. I then have column C, which has variables from the list in column A but ...
Conditional formatting of one cell based on the other cell.
Hello, I was wondering if there is a way I can say to excel without coding: I have three cells A1, B1 and C1. If A1 value (which constatly chan...
Count formula (need help)
SolvedHello, everyone I want to thank you in advance because I know that excel can be frustrating. I hope this is an easy one I have the following data list...
Using if function with dates
SolvedHello, I want to thank everyone for their time in advance. My problem is that I have a two cells/rows (78 & 87) in a column on this worksheet ...
Windows 7 excel 2013 jump lists
I'm using Windows 7. My Excel 2013 Jump List only lists the latest CSV files. How can I also get my excel files to show in the jump lists? (This...
Compare three columns in three sheets
Hello, I have two excel sheets. Sheet 1 has A,B,C,D columns and sheet 2 has A,B,C columns.Now I want to compare A,B,C columns in both the sheets. ...
Insert a row below a given cell of a table
Hello, I have a table on Excel 2013. I would like a macro to do the following: 1) insert a row bellow a given cell 2) copy the format of the origi...
Finding the last used column
Hello, Can anyone help. I want to find the last column used so that I can compare it with the first column Configuration: Windows XP / Firefox ...
Macros editing
SolvedHi Guys, I have created a macro that splits a master worksheet into separate tabs based on specific criteria then saves each tab as a separate wor...
How to create a macro to find the value in specified cell
Hello, i need to create a macro to find a cell based on the value of other cell. for e.g. i want find the cell by copying cell "DH1" (in which t...
Formullas
Helo i need some formulas .e,g.TA,DA,HR,INTEREST% in like insurance. And Grade,%,fail,pass. Please help me undefinedHelo i need some formulas ....
Adobe photoshop software
After downloading , how do you open the zip file
Vba to protect cell in excel
Hello, Hello, I need a help if some one can help me. i a fresh in excel vba code writing. please provide a code to protect a cell with passwor...
Search and extract up to 10 lots of 46 sequential cells
Hi, I need to search and extract up to 10 lots of 46 sequential cells from column A containing 1400 cells. These 9 or 10 lots of 46 cells need to be c...
Refer only one column from named range
SolvedHello everyone and thanks in advance! I have a report in excel 2010. In that i created a named range as "nmerng" which refers two columns s...
I need a program that will automatically make invoices weekly.
I own a small window washing business and I need invoices for every job printed weekly. What I am looking for is a program that I can enter the invoic...
I need to copy 3 cells into one cell
Hello, I am having a problem in excel I can't figure out. I have an example of what I am working with below. There are 3 columns A (SKU), B (Numer...
Conditional formatting in a vlookup
Hello, Not sure if what I am wanting is possible but thought I would ask... I have a database in which I will always update and add to. And ea...
Trying to copy from sheet all values to another sheet
Hello, I am trying to Copy from sheet's all values to another sheet. But its not coping with their cells formate.
Compare two columns with another two columns and return
Hello, I need to compare two columns with another two columns and return date from a third colum. Example I have a zip code with 90004 with 3 dif...
Find a word based on # and copy word to another cell
Hi all, I have a lot of social media messages in row 1 below eachother, and my goal is to find all the hashtages from the messages. For example: ...
Data transferred from macro
Hey guys can you please help a desperate girl out lol I have a report I do every 2 hours at work through excel. I have two reports that go into a m...
Macro to repeat a row n times
Hello, I want a macro to repeat a row n times. Example A B C if n=2 A B C A B C Thanks in advance
Lookup relevant value from table
SolvedHello Team, I have a doubt, Consider the table : Event A B C 1 3020 3420 1324 2 3005 3405 5462 3 2990...
Macro for insert picture
Hello, Please help i have to insert item pictures in column A i have item code in column B. All pictures saved in D drive folder name pictures. fi...
Recovering deleted mails from trash
ClosedHello, i just deleted my mails from trash. how can I recover that mails deleted from trash.please suggest me
Copying dates in excel
SolvedHello, I created a workbook in Excel and frequently need to copy the same date down a single column. I've always been able to simply grab the + in...
Combine text from multiple cells if other cell has a value of 1
As per the picture I have a spreadsheet that tracks what courses an individual has completed and if that course has a Certification attached to it. If...
Moving data in sheet depending on contents of a cell
Hello, I have a sheet, where at the top, I have a table of all orders in production. In column "I" you can set the status of the order using data ...
How can i restore corrupt .edb?
Solved/ClosedHello, I have an exchange server with a .edb that is in a dirty shutdown state. I have 2 storage groups. The second storage group will not mount d...
Formula for convert number into word
dear sir, i want to formula for numeric value (Ex. 12,350/-) into word (twelve thousand three hundred fifty rupees only) please rep...
Change color of one cell based on another cell
Hi, I am trying to create a speadsheet based on customer sales. In one cell it has "yes" or "no" to inform me on whether or not the customer is commi...
Restrict user from printing empty pages in excel vba
Hello, I have three print areas in a single sheet. If I print that sheet, it prints 3 pages(print areas). Is there any way to print only the p...
If statement
SolvedHi, Could you please tell me what I'm doing wrong in this statement? I can't find the issue :( =IF(AND(C2="Passed",D2="Passed",E2="Passed"), "Pass...
Copy data from 1 workbook to another based on sheet tabs
SolvedGood day to all, I'm looking for a macro that can copy data from source workbook and paste it to master workbook based on specified sheet tabs. ...
Match requests sent to bank with requests processed by bank
Hello, I am trying to match the requests processed by the bank with the requests sent to the bank for processing. The bank could process part of ...
How do i recover a corrupt p-point ?
I have a presentation of the problem, and I read the other thread about it and tried to download the presentation up through Open Office and it failed...
How to return a cell value from a sheet that is not created yet?
Hello, I am creating a job summary sheet to collect data from sheets that will be created based on each day worked on a project. I've created a...
Creating sheet with list having duplicate values.
Hello, I have a list in a column need to create sheets with each value in the list. The list will have duplicate values. but excel cannot have two s...
Hide page breaks in excel 2010
Hello, Is it possible to hide page breaks in excel while shifting from print preview to normal view using vba? I know to remove pages breaks ...
Link data from one cell to another
SolvedHello, ok now what I am trying to do is make a simple formula that will let me take some data out of work book a and have it appear in work book B. ...
Excel:print one enlarged page to multiple pages
SolvedHello, Is it possible to print a enlarged page to multiple pages in excel? Configuration: Windows / Chrome 45.0.2454.101