|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
04-03-2023, 08:58 AM
|
||||
|
||||
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! 
|
| Tags |
| copy and paste, if then statement, macro |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to populate a dropdown list with a spcific column in a specific worksheet | ericliu24 | Word VBA | 2 | 03-17-2022 05:24 AM |
 How to populate a userform combobox from an excel worksheet
|
jrooney7 | Word VBA | 14 | 09-16-2018 08:52 PM |
| How do I populate Worksheets using information entirely from another Worksheet in the same Workbook? | BrieDanielle | Excel | 1 | 06-18-2016 10:50 AM |
|
Populate Pulldown list with Macro
|
Samedy | Word VBA | 1 | 02-25-2014 06:59 PM |
|
DRop down list within text of If statement
|
sbarron76 | Mail Merge | 2 | 05-03-2013 05:00 AM |
Mac OS X 
Office 2016 for Mac
Threaded Mode