hello, i'am new here
i have workbook with 6 sheet
s0
A
47
6
16
59
18
s1 a1 a
s2 a1 a
s3 a1 a
s4 a1 a
s5 a1 a
can it caange in batch pocess?
s1 a1 a47
s2 a1 a6
s3 a1 a16
s4 a1 a59
s5 a1 a18
thanks for your help
regard
sino
Last edited by sino; 10-25-2010 at 02:45 PM. Reason: Solved
Click GO ADVANCED and use the paperclip icon to post up a demonstrative workbook. Show us.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
thx JBeaucaire, sorry for my bad, i just upload itOriginally Posted by JBeaucaire
Something like this then:
Option Explicit Sub UpdateA1() Dim ws As Long For ws = 2 To Sheets.Count With Sheets(ws).Range("A1") .Value = .Value & Sheets("Sheet").Range("A" & ws - 1) End With Next ws End Sub
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Thx alot JBeaucaire, your code is perfect
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks