The discussions
Data validation formula changes to vba code
Hi The Below formula =IF(OR(D2="Best",D2="Worst"),FALSE,TRUE) used in Data Validation for Column E I would like to request that it could changes t...
Fix the code
SolvedHello, Its being requested please fix the code given below the problem in this code is that any one of the given condition execute and once ...
Date format changes when editing it
SolvedHi, I'm using Excel 2007. I've changed the date format to dd/mm/yyyy with no problems. However, as soon as I begin to edit a date, it changes to...
Copying entries from multiple sheets to new sheet, then summing
SolvedI run a weekly pub trivia and I use a spreadsheet to keep track of cumulative scores. There are 6 sheets in the file... Week 1 Week 2 Week 3 W...
Cutepdf writer for windows 10
When will the free version of CutePDF Writer become available for Microsoft Windows 10? Thank you for your time and assistance.
Merge two macros of 2 diffrent workbooks
SolvedHello, I have 2 macros in 2 different workbook Currently i have to run 1 st macro(!st work book),then open 2nd macro workbook then have to run...
Can't open powerpoint files. pptx
I've got a user on a Windows 8 laptop with Microsoft Office 2013 installed. Whenever he tries opening PPTX files, no actual content is displayed but i...
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. ...
