Trying to create Macro that will continuously copy and paste data from a drop down list

psywagon

New Member
Joined
Jan 9, 2024
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
I have this current Macro that does works for a single object in my list.

Sub pasteprojectdataProjectDataPublishMacro()
'
' pasteprojectdataProjectDataPublishMacro Macro
'

'
Sheets("Dash").Select
Range("C1:H2").Select
ActiveCell.FormulaR1C1 = _
"='ProjectDataPublishMacro'!R3C5"
Sheets("ProjectData").Select
Rows("4:4").Select
Selection.Copy
Range("A341").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False



End Sub

My Issue is that I want it to continuously do this for a larger range of data without having to copy and paste the code repeatedly for each new cell. I have a dashboard where the data is published. The first two rows of the macro are the selection of that cell. From there I am struggling to understand how to make this a loop where it will take the data set and do this for the next 62 lines of data I have. Can anyone help?
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Forum statistics

Threads
1,223,896
Messages
6,175,265
Members
452,627
Latest member
KitkatToby

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top