creating a loop in a macro

[bobfoley91]

Hi I'm new to this

I have an output file form database which is seperated into 26 differnt tabs relating to different parts of data base.

From this output file I have created different workbooks analysisng certain sheets from the output file seperataly( there is alot of analysis involed in the sheets)

changes are being to the data on a weekly bases so i have to copy & paste the data from the output file into the workbbooks were i analysise the data

I have created a macro
I have a generic coverhsheet in each of the workbooks were i do the analysis. One of the cells has a drop down menu givng me the option to select which i sheet i want update, The macros reads this cell and looks for this sheetname file in the latest output file (the file name is specified on the coversheet), then copies the updated data into the workbook were the analysis is done
This the code i have created
I want put a named range on the cover sheet with sheetnames that are being used from the output file, I want the macro to loop and update data in them specified file names.

I havent created a loop before and I'm finding it hard to understand how to start

Please Login or Register  to view this content.

Thanks

[Richard Buttrey]

Hi, and welcome to the forum. Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[bobfoley91]

Hi Richard

Sorry for not complying with the rules, I have edited the text.