LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default need macro to filter data from multiple sheets in a worksheet

In sheet 1 I have about 15,000 rows in the following columns
A1(Unique id)
A2 Names of persons
A3 Address
A4 Amount for the year 2005
A5 Amount for the year 2006
A6 Amount for the year 2007 (Blank / no date)

In sheet 2 i have 22,500 rows and have following columns
A1 (Unique id)
A2 Names of person
A3 Address
A4 Amount for the year 2007

Same above column in sheet 3, sheet 4 and sheet 5
I have to update the rows of column A6 of sheet 1 through column A4 of sheet
2, sheet 3, sheet 4 and sheet 5

Please help to filter the data
 
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
Hyperlink and Filter Data in Multiple Sheets Sheikh Saadi Excel Discussion (Misc queries) 0 March 13th 09 07:02 AM
macro to find data and filter it and copy to another worksheet kay Excel Programming 1 October 18th 08 09:30 PM
Creating a macro to filter data on multiple sheets catfish#hunter Excel Programming 0 May 22nd 08 09:10 PM
Macro to Filter Information in Multiple sheets and Make graph misschanda via OfficeKB.com Excel Worksheet Functions 0 August 24th 07 03:25 PM
Combine multiple sheets of data into one worksheet Jason Excel Discussion (Misc queries) 1 June 17th 07 01:07 PM


All times are GMT +1. The time now is 09:20 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"