LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Minuette
 
Posts: n/a
Default Compare worksheets and generate list of missing data?

It worked!! Brilliant - thanks Bruno

"Bruno Campanini" wrote:

"Minuette" wrote in message
...
Hi Bruno,

Thanks for the info. I have never used Visual basic before so have copied
and pasted your work and then changed the data ranges.

Unable to run it - keep getting 'Syntax error' on Sub ComparingData ()
line.

It's obviously beyond me but thanks so much for trying.


How did you try to run the procedure?
You should run it by clicking the Button you've previously
assigned the macro to, or execute ComparingData from
the immediate window.

Ciao
Bruno





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How To: Link worksheet data to pre-existing chart tables Fitz Excel Discussion (Misc queries) 4 October 24th 05 11:05 PM
How To: Link worksheet data to pre-existing chart tables Fitz Excel Worksheet Functions 4 October 24th 05 11:05 PM
How To: Link worksheet data to pre-existing chart tables Fitz Charts and Charting in Excel 4 October 24th 05 11:05 PM
Compare Text in 2 worksheets where verbiage is slightly different annem Excel Worksheet Functions 2 August 15th 05 11:19 PM
Unique and duplicate data between 2 Excel worksheets Greg Excel Worksheet Functions 0 August 9th 05 12:03 AM


All times are GMT +1. The time now is 04:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"