VBA - Copy range # of times value is in Colum [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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.


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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
Thanks for your reply, but I don't kow of any file sharing sites?
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Do a google search on free file sharing sites You will find many

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!