HI,
I have an excel workbook, which has 100 sheets in it, all the sheets are identical apart from A10 in every sheet.
In A10 of sheet 1 there is a value 101 which i typed in manually and A10 of all other sheets are blank.
Now what i want to do is, when i type 101 in A10 of sheet1 then i want to have 102 in A10 of sheet2 , 103 in A10 of sheet3 and so on until sheet 100; automatically.
Please can anyone help me in this matter?
This Macro is sheet specific and must be put in the sheet vba module.
Right click on the sheet name at the bottom of excel and select view code.
Paste this code there.
close the vba module and change A10 on the first sheet.
Please Login or Register to view this content.
Last edited by mehmetcik; 12-21-2014 at 09:34 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
This is how I interpret your problem.Originally Posted by LAVA2
Please Login or Register to view this content.
Hi, mehmetcik
Your solution solved my problem.
Now is the right time to Thank you.
Thank you so much!!!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks