Previous Topic Next Topic

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
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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
0
becca
Sep 13, 2011 at 02:07 PM
Thanks for your reply, but I don't kow of any file sharing sites?
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 13, 2011 at 06:03 PM
Do a google search on free file sharing sites You will find many
0

Similar discussions

Excel VBA copy and paste loop with logic condition
Yogibearv -
Yogibearv -

6 responses
VBA code to copy and paste data multiple times
lakshminair -
ac3mark -

1 response
VBA Copy/Paste fixed range a number of times
srinivas_kala -
TrowaD -

6 responses
Auto Filter depending on Cell Value
Issa -
rizvisa1 -

10 responses
Insert picture in Excel macro which takes the file name refrence
V Kanagu -
TrowaD -

23 responses
Copy and insert rows and number of times
Pabs -
Duck -

22 responses