VBA - Copy range # of times value is in Colum
Closed
becca
-
Sep 13, 2011 at 10:15 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 13, 2011 at 06:03 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 13, 2011 at 06:03 PM
Hello,
I am looking for VBA code to copy/paste a range the same # of times a value (Department Code) appears in Column A. So, if Department 1234 appears 10 times, the Range named COOL will paste 10 times. Oh, also, the Department Code is also a named range on the COOL spreadsheet. So, I want the code to look at this named range to determine what to search for.
I hope someone can assist. Many thanks.
I am looking for VBA code to copy/paste a range the same # of times a value (Department Code) appears in Column A. So, if Department 1234 appears 10 times, the Range named COOL will paste 10 times. Oh, also, the Department Code is also a named range on the COOL spreadsheet. So, I want the code to look at this named range to determine what to search for.
I hope someone can assist. Many thanks.
Related:
- Vba to copy and paste a range multiple times based on cell value
- Based on the cell values in cells b77 ✓ - Excel Forum
- Discord invisible name copy and paste ✓ - Internet & Social Networks Forum
- How to insert rows in excel automatically based on cell value without vba ✓ - Excel Forum
- Why cant i copy and paste on instagram ✓ - Instagram Forum
- Vba case like - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Sep 13, 2011 at 11:31 AM
Sep 13, 2011 at 11:31 AM
Could you post a sample workbook at some file sharing site and post back the link to the file here. In that that sample book, have some sample data and use that workbook as reference to re-explain you issue
Sep 13, 2011 at 02:07 PM
Sep 13, 2011 at 06:03 PM