Excel Macro: Matching and calculating 2 worksheets

Posted to microsoft.public.excel.programming

mayanair[_4_] mayanair[_4_] is offline

external usenet poster

Posts: 1

Excel Macro: Matching and calculating 2 worksheets

Hi there,

I have not touched VB for a looooong time and hope someone could
refresh me on the codings.

I have 2 worksheets in Excel that looks like below:

Sheet 1
A.............B.............C
Name.......ID............Number of Status=Yes
John........1111
Julie........2222
Mary.......3333

Sheet 2
ID.............Status
1111..........Yes
2222..........No
1111..........Yes
3333..........No
1111..........No
2222..........Yes

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculating daily totals from multiple worksheets (Excel 2003)	Dhardy	Excel Worksheet Functions	4	April 20th 10 10:46 PM
Matching and calculating 2 worksheets	mayanair	Excel Worksheet Functions	5	April 26th 06 07:09 PM
Matching and calculating 2 worksheets	mayanair	Excel Programming	3	April 26th 06 09:46 AM
CALCULATING WORKSHEETS (INCLUDING AGE CALCULATING SHEETS) FOR DOWNLOADING, GREAT FOR PENSIONS/LIFE INSURANCE CALCULATIONS!	RICHARD	Excel Programming	0	March 15th 05 01:41 PM
Calculating values with macro between worksheets	spolk[_3_]	Excel Programming	2	May 12th 04 04:59 PM

All times are GMT +1. The time now is 11:27 AM.

Menu

About Us