Copy rows based on criteria in one column that matches the Tab name in workbook

M

Mldeuser

Well-known Member
Joined
Dec 27, 2008
Messages
573
Office Version
  1. 365
Platform
  1. Windows
Hello

I have a workbook with several tabs. I am looking to copying columns A-Y based on the criteria in column T which matches one of the other tab names in the workbook. This file is updated monthly and by the end of the year there can be thousands of rows to be copied to one of the other tabs,

1. Consolidated
2. Base Rent Office
3. Base Rent Retail
4. Chilled Water
5. Electric Meter
6. Real Estate Tax

Thank you
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
You must log in or register to reply here.

Similar threads

S
  • Question
Copy rows from multiple worksheets into multiple worksheets in another workbook based on criteria
Replies
1
Views
161
eiloken
E
I
  • Question
VBA - Copy Sheet from a workbook saved as a date - paste to specifically named sheet in another workbook based on the date
Replies
2
Views
472
Insurance Dave
I
I
  • Question
Find the second highest attribute based on criteria. I know its a combo of index(match(large, but I just can't get it to work correctly.
Replies
1
Views
256
StephenCrump
S
gheyman
  • Solved
Copy a table Column to another workbook if a column name match is found
Replies
1
Views
394
kevin9999
K
Kaz09
  • Question
Copy rows of data from multiple worksheets to based on column equalling YES
Replies
0
Views
173
Kaz09
Kaz09

Forum statistics

Threads
1,217,013
Messages
6,134,036
Members
449,854
Latest member
kevins1218

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top