How to make a row auto populate

M

MeganLanpolsaen

New Member
Joined
Nov 15, 2019
Messages
3
Hello,

Thank you in advance for your help!

So I would like to have a separate sheet for certain data that is entered in another sheet, but all located in the same book. Is there a way to do this?

For instance, if the text in cell D2 matches a certain criteria, then excel will auto-populate (copy) the rest of the information in that row in the separate sheet?

Thank you!!
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

T
  • Question Question
Create and auto-populate comments
Replies
3
Views
338
rlv01
R
B
  • Question Question
How to auto populate a table on another sheet/tab based off of a drop down.
Replies
1
Views
331
severynm
severynm
A
  • Question Question
VBA Userform List Box to Populate upon entering a specific text in Column B, copy data upon selection and paste data in the same Row in another Column
Replies
3
Views
478
arijitirf
A
V
  • Question Question
Stop Excel from Auto Resize Row Heights
Replies
5
Views
1K
voodoo1226
V
L
  • Solved
copy cell and cell above onto different sheet, under the next available line.
Replies
5
Views
182
Alex Blakenburg
A

Forum statistics

Threads
1,223,885
Messages
6,175,180
Members
452,615
Latest member
bogeys2birdies

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