Macro challenge: find or create excel-sheet in separate workbooks

[Snoopy]

Hey guys
1) One of my macros pastes a list of various numbers of users -
starting from range A1 into sheet "userlist" in workbook "user.xls"
I try to make a macro to do some things:
Run through the list and create a new userfile (based on predefined
template I have made in folder c:\template) pr user - placed in folder
(c:\users) that is allready made
The folder/pathname is specified of each user in range B1:Bnn.
My challenge is to make the loop that runs through the list A1:Ann
- and ends after last position

2) My pivot-table shows one year at a time.
I wants to make a macro to copy pivot-tablecontent (thas easy)
into another specified workbook
and then do this:
a) open the specified workbook, find the possible sheet named as the
year (Range A3.value) I proceed and paste the copied data here
b) if not recognizing any suitable sheetname - I want the macro to
create a new sheet in the workbook and paste the data.

I know I have asked for help some times, but hope you guys will give
me a lead

Regards
Snoopy

 

[ShaneDevenshire]

Hi,

Try recording the macro, then send us what you get and tell us what isn't
working the way you want.

 

[Snoopy]

Hi,

Try recording the macro, then send us what you get and tell us what isn't
working the way you want.

--
Thanks,
Shane Devenshire








– Vis sitert tekst –

Thanks Shane
I realy do appreciate your respons.

Maybe the real - but simple - problem (1) is to make my macro run the
loop for each cell in the range A1:Ann.
For each value in this range I create a new file named as
Range.value.xls - and off corse after the last range.value stop the
macro or proceed anorther one.
I cant get this event recorded, neither the next problem (2).

A set of data is to be copied from one workbook to another, the
year.value is placed in Cell A3.
I want my macro to "read" this year.value and find in the receiving
workbook the sheet named year.value - if not finding it: create a new
sheet with this new year.value - then paste the data set into the new
year.value sheet.

I certainly think this is not the big ExcelVBA challenge to the
advanced VBA user, but I'm still a rookie on this.

Regards
Snoopy