View Single Post
 
Old 04-03-2023, 08:58 AM
clcummings's Avatar
clcummings clcummings is offline Mac OS X Office 2016 for Mac
Novice
 
Join Date: Apr 2023
Posts: 1
clcummings is on a distinguished road
Question Using a macro with if statement to populate a list from one worksheet to another

I have an Excel workbook with multiple tabs. On one tab ("Roster"), I have a list of nursing homes where I work and a list of residents that I work with at those homes.
I want a macro that copies names from the Roster tab and pastes them into the corresponding nursing home tab ("AL," "Bri," etc).

I assume this will require some kind of If statement within the macro. I.e. If a cell in column A on Roster tab = "AL", then select the cell in column B, and paste it into the "AL" tab. How can I pull this off? TIA!
Attached Images
File Type: jpg Screenshot 2023-04-03 at 10.41.32 AM.jpg (148.5 KB, 16 views)
File Type: jpg Screenshot 2023-04-03 at 10.41.53 AM.jpg (117.2 KB, 16 views)
Reply With Quote