Macro Needed plase

[BeerBeer101]

I have a formula in a sheet - need a macro to copy it down and advance the file name by one number...

in N3 is the following formula:
='B:\Completed\[#1.xlsx]Input Sheet'!$C$44

needing the macro formula to change the 1, 2, 3, 4, 5 etc after the # hash.
I had this once - lost it - now I'm back!

thanks team!

 

[BeerBeer101]

I have a formula in a sheet - need a macro to copy it down and advance the file name by one number...

in N3 is the following formula:
='B:\Completed\[#1.xlsx]Input Sheet'!$C$44

needing the macro formula to change the 1, 2, 3, 4, 5 etc after the # hash.
I had this once - lost it - now I'm back!

thanks team!

hold on - i found it... close thread... thanks

 

[Peter_SSs]

Good to hear you got the solution.

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.

 

[BeerBeer101]

Good to hear you got the solution.

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.

it can be found in this string - I could not find the string from last summer when I came to look again - but then I did - was not able to delete my question.

Change Sheet Name when copying cell

Hi again, copying from cell to cell (down) and changing the filename: B3 - links to a sheet called #1.xlsx B4 - links to a sheet called #2.xlsx and on down the line it goes. is there a copy function that will ad 1 number to the sheet name (i have about 1200 sheets total) as opposed to having...

www.mrexcel.com