Formula to add lines if data is present in another sheet

Jstump

New Member
Joined
Oct 25, 2023
Messages
36
Office Version
  1. 365
Platform
  1. Windows
Is there a way to autopoulate a row in between two set rows with data in column A to match data entered in another cell on another sheet. this first one the blue line would be auto added and the employee name would be autoppoulated from the second one.

Kane 1.xlsx
ABCDEFG
3Employee Name12-Jan13-Jan14-Jan15-Jan16-Jan
4Blank
5total
Dash


Kane 1.xlsx
JK
3Employee Employee name
41Stump, James
52Daggy, Dillain
63Daggy, Dillain
74Donihoo, Dillon
85Lopez, Andrew
96
107
118
129
1310
1411
1512
1613
1714
1815
1916McCain, Austin
2017
2118
2219
2320
Input page
Cells with Data Validation
CellAllowCriteria
K4:K23List=Database!$A$2:$A$10
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Forum statistics

Threads
1,215,126
Messages
6,123,198
Members
449,090
Latest member
bes000

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