In the file attached, I have tabs, Banks, CNRB and Others. This is sample data not actual data of bank records
I need help in
1. Where IFSC Code is CNRB*.* and SYN *.* whole data to be replicated in tab CNRB Tab
2. Where IFSC Code is <> CNRB*.* and <> SYN *.* whole data to be replicated in tab others Tab
How can do this please
Here is a VBA solution
How to install your new code
Please Login or Register to view this content.
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
To run the Excel VBA code:
- Press Alt-F8 to open the macro list
- Select a macro in the list
- Click the Run button
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Appreciate the solution by VBA
Any possibility of Non VBA solution
Not from me. Will have to wait for one of our Formula Experts Chime in. Are you still using Excel 2007 as noted in your profile or have you updated to a later version? If updated, please amend your profile as newer features may be available to you.
I am using Excel 2010
If you can download and install the free PowerQuery add-in, then it's really easy.
Just load the data and filter it first to items starting with CNRB (for the first table), then duplicate the query and filter to items not starting with CNRB. Load back to the relevant tabs.
When the source data is updated, just refresh the queries.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank You so much
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks