Move row of data from one sheet to another based on drop down choice

N

nparsons75

Well-known Member
Joined
Sep 23, 2013
Messages
1,254
Office Version
  1. 2016
I have multiple sheets within a workbook, I will call them T1, T2, T3.

Within sheet one I have a table, when I select a criteria in one of my columns, Column Z for example, based on the selection I would like to copy the row of data.

So, in T1 I will have multiple rows of data, if I select in Column Z, criteria 2, I would like that row of data to copy to the bottom row in T2. Should I select 3, then copy to T3.
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
You must log in or register to reply here.

Similar threads

W
  • Solved
Moving/transferring data between tables with matching column names, not by column order - vba
Replies
5
Views
232
Alex Blakenburg
A
C
  • Question
Changing the Rowsource of a userform Listbox with each change in the Listbox selection
Replies
0
Views
250
chazrab
C
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
228
Insurance Dave
I
Kaz09
  • Question
Copy rows from multiple sheets based on data
Replies
1
Views
154
Fluff
Fluff
D
  • Question
VBA Helpo
Replies
1
Views
62
debneedshelp
D

Forum statistics

Threads
1,214,954
Messages
6,122,461
Members
449,085
Latest member
ExcelError

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