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

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

T
  • Question
Create and auto-populate comments
Replies
3
Views
123
rlv01
R
A
  • 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
239
arijitirf
A
V
  • Question
Stop Excel from Auto Resize Row Heights
Replies
5
Views
622
voodoo1226
V
B
  • Solved
Populating combobox from table based on the header selected in another combobox (some data on different sheets)
Replies
7
Views
325
BWL388
B
J
  • Question
double blue line appears across bottom of sheet after using auto sum. then when you type in row below double blue line text is automatically bold?
Replies
2
Views
93
RoryA
RoryA

Forum statistics

Threads
1,216,128
Messages
6,129,036
Members
449,482
Latest member
al mugheen

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