0
votes
1answer
39 views

VBA Lookup by Multiple Criteria - Then Copy & Paste

Currently I have a 2 way database with 10+ fields and 1,000+ rows. Some fields are customer name, car model, year of model, price, date of purchase. I would like to lookup rows of data by multiple ...
1
vote
0answers
45 views

Extracting and collating data from multiple columns in Excel 2003

First of all I have tried a lot but failed to get a solution for the following problem and I hence request all the superusers to help me with their best if possible.... I tried unpivoting but it did ...
2
votes
2answers
93 views

Why is this simple Excel calculation not netting Zero?

It's supposed to be zero but for some reason the result produces a peculiar series of digits at the end. Also, here's the .xlsx of it: http://83.212.111.36/Book1.xlsx
-1
votes
0answers
463 views

Embed the EXE file in the excel file itself

I use retVal = Shell("program.EXE " & filename, vbNormalFocus) to execute a program I need for my excel spreadsheet. Is it possible to embed the EXE file in the excel file itself? And how would ...
1
vote
1answer
148 views

Real time Export of excel 2003 fields to MS word 2003 fields

I am a practicing radiologist. We enter patient information such as Name, date of birth, number (patient ID), referring physician's name, and date of the study at the front desk in MS Excel 2003. Is ...
1
vote
2answers
2k views

Microsoft Excel Undo Only Works Twice

I am using Microsoft Excel 2003. A major irritant is that I am unable to use "undo" more than twice. Can you not use Undo more than 2 or 3 times or am I missing something? Are there any solutions to ...
5
votes
4answers
10k views

Make Excel 2003 Open Spreadsheets in new instances

In Excel 2003, It seems to be putting each spreadsheet I open into the existing Excel application as a new window. this makes it very difficult in a dual monitor set up to put one spreadsheet on each ...