Macro in Excel 2003

Cmill, on Friday September 5, 2008 03:25:12 PM

Hello,
I have 2 tabs that contain a lot of data and I need to compare them both. One contains data that needs to be completed, and the other contains the data that was completed. I need to match them up to see if the "projects" that needed to be completed were actually completed. Does anyone have the Macro code they can give me to do this? OR an opinion on any other way it can be done?
Any input would be greatly appreciated!
Here is the Macro I recorded from the 2 sheets of data;
Sub Macro1()
'
' Macro1 Macro
' Sears Project
'

'
ActiveWindow.SmallScroll Down:=-12
Sheets("Beamteam 1").Select
Range("A1:AW573").Select
Range("A2").Activate
Sheets("Sears 708 RTA").Select
Range("A2:BK517").Select
Range("A3").Activate
End Sub

Configuration: Windows XP
Internet Explorer 6.0

Reply to Cmill Report this message to moderators Go to last message

This message seems useful, vote!
Report this message to moderators

pbnj22, on Friday November 28, 2008 01:48:12 AM

I would import the two list into access as separate tables and run either "inner join" query (only matched items appear) or "outer join" were all items of one table appear and only matched items of the other appear. If set up properly, all the projects would appear in one table (whether completed or not) and the completed would appear in the other table. you could then do a filter to determine what has not been completed. My guess, based on your question, about 15-30 minutes tops.

Reply to pbnj22

Ask your question Reply

Results for

Ms excel 2003 problemb Hello, This is giri i have excel 2003 problemb when i open 1 excel document its opening 17 excle different documents these all are saved documents not a new ones i reinstalled but its the same problemb wht could be the reason plzgive me solution... en.kioskea.net/forum/affich-25950-ms-excel-2003-problemb

Excel 2003 assistance Hello, i am currently using excel 2003 to try and set up a client feedback form, at the bottom i want to make a button that has the display letters send then opens an there email program with an email that i can input is this possible, if not is there... en.kioskea.net/forum/affich-29785-excel-2003-assistance

Excel Macro Help Hello, I am trying to create a macro within Excel 2003, which will extract data from a Text document into an Excel spreadsheet and sort the data as required. This is made slightly more difficult by the inconsistency in the data which is explained... en.kioskea.net/forum/affich-30377-excel-macro-help

1 2 3 Next

Results for

Excel tips : How to insert date In an Excel cellExcel tips : How to insert date In an Excel cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press “CTRL”+ “;” in the chosen cell. To insert current... en.kioskea.net/faq/sujet-313-excel-tips-how-to-insert-date-in-an-excel-cell

How to convert Excel into PDF?How to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. PDF995 is software that gets installed on your computer which enables you to print any sources of document to PDF.... en.kioskea.net/faq/sujet-552-how-to-convert-excel-into-pdf

What are Word XP/2003 Task Panes?The Word XP/2003 task panes appear on the right side of the screen, along with the document you are working on. The options on the task pane may change, depending on commands you have chosen. For example, some Word 2000 commands that displayed in... en.kioskea.net/faq/sujet-21-what-are-word-xp-2003-task-panes

1 2 3 Next

Results for

MACRO to copy rows based on criteraHello, I need to create a Macro in Excel 2003 that will search four worksheets (within the same workbook) for the word "Failed" and then copy the entire row that word exists in to another worksheet (within the same workbook). I need the formatting in... en.kioskea.net/forum/affich-30369-macro-to-copy-rows-based-on-critera

Excel autofilter stops filtering (Solved)Hello, I am working with Excel 2003 professional and just yesterday after entering a bunch of records to my file which has about 19,000 rows I discovered that my autofilter just stoped filtering completely. When I clicked the arrow there is no value... en.kioskea.net/forum/affich-5838-excel-autofilter-stops-filtering

From sheet 2 cell find sheet1 name then valueHello, I am using Excel 2003, Windowx XP Professional, and Internet Explorer 7 In one Excel 3003 example workbook sheet1 contains data copied in from Internet Explorer 7 that keeps changing position on the sheet. From a cell, EG C5, in sheet2 I want... en.kioskea.net/forum/affich-27953-from-sheet-2-cell-find-sheet1-name-then-value

1 2 3 Next

Results for

Download Excel ViewerWith Excel Viewer, you can open, view, and print Excel workbooks, even if you don't have Excel installed. You can also copy data from Excel Viewer to another program. en.kioskea.net/telecharger/telecharger-52-excel-viewer

1 2 3 Next

Results for

Spreadsheets - The Excel Interface Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel document is called a file... en.kioskea.net/tableur/tabinterface.php3

Email - Rules for proper email use Netiquette (a contraction of the words "Net" and "etiquette") refers to the set of rules governing correct behaviour on the Internet, in order to respect others and be respected in turn. They serve as guidelines for civility and proper conduct, so... en.kioskea.net/courrier-electronique/regles-bon-usage-messagerie.php3

HTML - Hyperlinks Hypertext links or hyperlinks (anchors) are HTML elements that, when clicked on, enable readers to visit a new address. Hyperlinked text is underlined by default. Hyperlinks are what connect web pages to one another. They are used to travel: to... en.kioskea.net/html/htmlhypertxt.php3

1 2 3 Next