The discussions
Auto transfer data as i marked
SolvedHello, I have a spreedsheet where there are names, enrolment No., various subjects(1st Year, 2nd year & 3rd year) of at least 10000 students related...
Populating sheet based off date criteria in another
Hello, I have a database that I would like to auto populate all of the 2015 events into a 2015 sheet. I need the data in both sheets as the main i...
Recover delete data
dear friends i have a word file in 200 pages data but now i am open the file is empty in single page if recover the data?
Pulling data from different workbooks and collating on another
Hello, I would like to be able to do the following; have a number of work books which are allocated to team members (x4) which they complete with ...
Counting action under condition of theyr value, and month when..
SolvedHello Guys, I came here for help again :) I need to solve one issue. I've created database, which contain column with Dates(column E),and column w...
Editing a date+time field converts date to text
Hello, I have formatted a (Excel 2010 spreadsheet) column as "ddd\ dd-mmm-yy\ \ hh-mm\ \h\r\s" which shows the existing data as "Sun 04-Oct-15 ...
Comparing spreadsheets
I have been given a task in Excel and i am not good at it. I have two different spreadsheets with first and last names in them. I need to compare sp...
@if formula
SolvedHello, how do i formulate the following:- if cell B12 contains the word Meals, then I want to use the formula F12/2 else take 100% in F12 Conf...
I want to plus data from two excel sheeets to the third sheet
Hello, hi Configuration: Windows XP / Firefox 38.0
Delay message
I got a postmaster email that an email sent from computer to someones personal email didn't go and delayed. I think someone sent from my computer to t...
Cell formating
Hello, I have excel sheet that contains 1000 rows of customer and i need to change color in one cell based on anther cel in same row ,this i solv...
Not able to open pdf files
Hello, Please can you advise me why just suddenly I cannot open a pdf file attachement or from my stored files. message reads : This file does not h...
Conditional formating a column
SolvedHello, I wish to conditionally format a column depending on another columns date value in excel 2010 Column A has a target date and Column B ha...
Find words within cell & put value in adjacent
Column has Organisation Name Need to Search and Create a category to the next 5 columns A Organisation can have key word in more than 1 category...
Help request - for advanced filter macro vba
Hello, I would like to have data from my master sheet to another one based on multiple criteria filter. My master sheet can be manually filled and ...
Copy cells based on conditions
SolvedHello, I want to make several versions of a questionnaire specific for each out of 11 types of a product. Therefore I made a button for each of th...
Pdf image recovery from corrupt pdf files
The pdf file in which i kept my pictures gt corrupt. i used image extractor tools but for nothing. please help me. i am clueless what to do?
Vba macro to color a range of cells based on value of other cell
Hello, I' am using a shared file and hence could not use conditional formatting. I want range C2:F2 should turn Blue is the value in cell G2 is...
Automate some of my daily activity in excel using excel macros
Hello, I am a Hyperion technology Person. Looking for Vbscript code/Excel Macro code to automate my daily job. Before Looking for help on this, I wo...
Copying data from workbook to workbook using button
SolvedHello guys nad ladies, I have a problem, i hope you can help me. I have an excel worksheet (2 columns, 7 rows) It's kind of daily statistics (email...
Stopped uploading my emails
Hello, Within the last few days my emails stopped coming into Outlook. I went to my Account Settings and redid them about 4 times. After doing i...
Change color to different cells based on another cells text.
SolvedHi, need some help, cannot figure this one out. I had attempted to use conditional formatting; however, it is not completely accomplishing what I hav...
Auto notify or mail when excel sheet updated. [solved/closed]
Hello, I have used following VBA, but still I am not getting the solution. Please help I am unable to change the following field. answer = M...
Unable to get email notifciation
Hello, I have placed below noted in my excel. but I am unable to get the email to my ID. Please help me Private Sub Workbook_BeforeSave(ByVa...
Excel workbook
Hello, I have a workbook with over 100 sheets. One of the sheets has a title of labels, I am trying to set it up ina way that if i type in sheet 10,...
Copy cell, unless another call says specific text
Hello, In my spreadsheet, currently C1 copies the number in A1. (=A1) I need this command to be overridden if B1 contains the text VISUAL Tha...
Copy row and insert n times
Solved/ClosedHello, I have an example below, I'd like to take the first row, copy it "n" number of times, then take the next row copy it the same "n" number of ti...
Compare two worksheets and remove duplicated data from one
SolvedHello everyone, I am struggling to find a solution and would value input from fellow users. The Problem: I have two separate worksheets "Customer...
Search for matches from columns on separate sheets.
SolvedHello, I've got a problem that is stumping me, and I hope you all can help. I have two sheets in my workbook and I would like to have a formula, ...
Adding days to an auto populated date in excel
Hello, I want to add 3 business days to a auto populated date in another field. So for example. B1 will have the auto date (Based on a system ent...
Macro help required
Hi, If anyone can help me to create the excel macro on- I have 12 rows data in excel with cell position A to BT. My requirement is- I want to copy ...
Help please, vba userform, msgbox!
Hello. I have a userform that I use to introduce some data on excel. Most of the data must be filled (that are textbox that the verifications d...
Excel formula using julian calendar
Hello, Can someone please help me create a formula in excel to convert A16612009 to 6/15/2015. The letter A stands for the year 2015, 166 stands ...
How to lock/unlock a workbook with multiple passwords
Hello, I would like to lock/unlock a work book with multiple passwords. I would also like to add a Log tab and have the unlock record the user, d...
How to use macro to copy data from workfile a to workfile b
Hi, COuld you please advise me how can I use macro coding to copy data from workfile A to workfile B? Example details :- Source data copy from:-...
Macro to transfer data from single to multiple columns
So I have been doing research but have been unable to find a macro that does what I need. Basically, I have multiple items on different carts, labeled...
Display a new entry in a column in a separate cell in excel
Hello, I am having a column; A B 1 ab 2 abc 3 abcd 4 abcde 5 xyz 6 I want the next entry in 6 row of A to ...
Converting number into alphabetic word
Kindly help in converting this 1,055.25 into alphabetic word... Thanks, Melvin Manila, Philippines
Whole numbers and decimals
Forgive me if I was an anonymous user who had only a single question to ask after searching the internet for hours, and didn't know there were courtes...
Create automatic tabs by sales rep
I have this information on one single tab (50 sales reps) Colum A - Sales Reps Colum B Revenue sold I need to create a single worksheet for each ...
Date formatting
Hi, When I fetch raw data from a portal, the date comes in this text format Oct-02-2015. I make it in proper format 02-Oct-2015 through delimited a...
If blank cell value of 1 + add 9 cells together
Hello, I need a formula where if the cell is blank it gets a value of 1, then I need it to add 9 cells together (in the same row). If something (te...
Finding customers names
Hi i am struggling to find my customers names on Excel Spreadsheets i have tried the format box and used the find box i also tried the name box can so...
Greater than and less than
Hello, i need help. A4 is the input i need to make it so that if A4 is greater than 1 and less than 100 it will display "centimeters" . Any sug...
How to copy data between several sheets on vba
SolvedHi, I'm still a newbie on VBA, so I could use a little help on getting some code working. I have several client used for factoring. As such, each i...
Microsoft office unreadable documents
HELLO my laptop has a problem after i write a document i can't change in different styles that means it will results in unreadable and can't read b...
Values from one workbook to another
SolvedHello, I need help - I have two worksheets one with costs and formulas I want to pull the answer from the formula block from the one worksheet to t...
I am unable to send out hotmail from ms outlook
SolvedHello, I have configured two email address in outlook 2007. one gmail another one is hotmail. I can send email by my first one gmail account but I...
Giving false with certain answers
SolvedHello, I am having an issue with my formula. Certain values will give me the correct answer (A, B, C, D, F) but other values will give me a FALSE...
I want to add 9 if conditions is it possible
Hello, I want to add 9 if conditions is it possible in Excel?
