Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
ali ali is offline
external usenet poster
 
Posts: 1
Default comparing columns from different sheets

Hi guys,

I've been trying to tidy up my excel and have made a huge mistake..
i've deleted 2 macros by mistake :-(

I can't remember where i got them from and all of my searches hav
yielded no results - can anyone help me please.

The user would select a column, eg column F, and then run the macro a
which point all of the column F's would be pulled from all of th
worksheets and combine them in a new sheet, allowing further analysis.

The second macro did exactly the same thing but with rows instead o
columns.

Does anyone know where i might have obtained these macros from,or eve
better can anyone show me the code (post a link).

Thanks in advance for saving my bacon guys!!

--
Message posted from http://www.ExcelForum.com

Reply
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
Comparing columns in sheets jpreman Excel Discussion (Misc queries) 6 July 11th 07 03:46 AM
Comparing multiple columns in two sheets [email protected] Excel Worksheet Functions 1 March 30th 07 07:12 PM
Comparing columns iin 2 sheets to generate one CCTD via OfficeKB.com Excel Worksheet Functions 0 September 26th 05 08:34 PM
comparing 2 similar columns on seperate work sheets in 1 workbook Dan Excel Discussion (Misc queries) 4 September 20th 05 11:58 PM
Comparing three columns in 2 sheets Simon Excel Programming 3 January 15th 04 04:14 AM


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

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

About Us

"It's about Microsoft Excel"