atuljadhavnetafim
Active Member
- Joined
- Apr 7, 2012
- Messages
- 341
- Office Version
- 365
- Platform
- Windows
Dear Expert,
i am looking for VBA code which search value from all sheet from particular column and paste all data in last sheet.
e.g. i have one file which have 5 sheets and name of the sheets as below
1) Search
2) Bank1
3) Bank2
4) Bank3
5) Bank4
in search sheet, B3 cell contain search value for e.g it is 100000
and rest all sheet having same format and the amount store in E column in all sheet
now when i search 100000 (Exact match) then VBA give search this value from all Bank sheet and past entire row in search sheet after row 8 with sheet name
please provide code
i am looking for VBA code which search value from all sheet from particular column and paste all data in last sheet.
e.g. i have one file which have 5 sheets and name of the sheets as below
1) Search
2) Bank1
3) Bank2
4) Bank3
5) Bank4
in search sheet, B3 cell contain search value for e.g it is 100000
and rest all sheet having same format and the amount store in E column in all sheet
now when i search 100000 (Exact match) then VBA give search this value from all Bank sheet and past entire row in search sheet after row 8 with sheet name
please provide code