Question about Microsoft Office Excel 2003 for PC

1 Answer

Reminder in excel

Hi,I need this help and it is very urgent..Your help will be much appriciated.I need an Excel sheet which can remind me on the current date if i have any task to be completed.Its ok if it has a macro.For eg..I could have spoken to a customer 7 days back and i should be responding to him today. when i open my excel and run the macro i should have the list of customer's names, Invoice number, the last comments and the actions that needs to be taken..

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 407 Answers

There are a couple of types of spreadsheet - Depending on the size of the data you are working with - filter may the quickest option or Query report.

Your worksheet will contain all your data i.e. Customer, contact no, outstaning actions and due date - You can create a filter aon this set criteria on the due data - as less than or equal to todays date - which will only display your outstanding actions required by today or earlier.

Another option if you have installed MS Query, is to create a seperate report - again using the criteria of due date being less than or equal to today.

Producing this from your existing data is much easier than trying to re-create your data - But I can send you how I would create this sheet if the above explanation is not easy to follow - If you let me have your email address.

Posted on Jun 01, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Dear Sir, In case there are atleast 80 files or more having same format containing datas in columns in each file with different figures, I want to merge all file in a single sheet in one shot. Kindly...


Hi,

If the column names and orders are same across files, then you can directly use the MS Excel's import data function, this will do your job.

Alternatively, if you want to do it manually, import each file in separate excel worksheet using data import wizard or simple copy paste of data (in latter case you have to use Text-to-Col feature of excel), and then manually append all figures (copy-paste in one go) to any external excel sheet.

Then finally, export/save as that external sheet to any filename of your choice.

Hope this helps.

Thanks.

Mar 24, 2009 | Microsoft Excel for PC

2 Answers

Delete blank rows in excel using visual basic


have you tried to read in one file and write back in excel format only the non-blank rows?

Mar 11, 2009 | Sony Playstation 3 (PS3) Console

1 Answer

FORGOT THE PASSWORD


Hi SAKHIE

You need to run a utility, link below
http://www.straxx.com/excel/password.html

May 07, 2008 | Excel (SS8SATAS5128400R)

2 Answers

How to hide sheet tabs in MS Excel


Do you mean by Visual Basic / Macro?

if so this is what you need:

ActiveWindow.DisplayWorkbookTabs = False

Mar 07, 2008 | Computers & Internet

3 Answers

Excel password removing


could you please supply us with the version of Excel you are using? it's under Help About Excel

Mar 04, 2008 | Excel (SS8SATAS5128400R)

2 Answers

How to Crack Excell sheet's Password


http://www.straxx.com/excel/password.html

Mar 03, 2008 | Computers & Internet

1 Answer

Excel sheet downloadin softwar


Hi,

Sorry but there is no application for the K550 that can open excel documents.

Dec 25, 2007 | Sony Ericsson K550i Cellular Phone

4 Answers

Forgot password


Try this link http://www.download.com/Free-Word-Excel-Password-Wizard/3000-2092_4-10249516.html?tag=lst-0-1 It should help you unlock the Excel file and break the password. Good luck

Sep 02, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Excel 2003 for PC Logo

238 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2658 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18387 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...