One solution would be to loop through the worksheets and copy what is there
to the front sheet, appending each sheet's data below the previous sheet's,
with perhaps a blank row separating each sheet's data. Or if you don't want
everything from each sheet copied, but the range to copy is the same on all
sheets, looping will still work. If the areas to be copied are different
from sheet to sheet, can still be done, but more difficult to code.
Provide a little more detail on what ranges you want copied and how you want
it to look on the front sheet.

Mike F

"tayyab" wrote in
message ...

Hi, I have got 11 sheets in a workbook, one of them is frontend and the
rest carries weekly data for 10 team members. Data will be updated
manually on each of the sheets every week. I want to be able to click a
button on the frontend and bring the last week's data from every sheet
to frontend. I tried to copy a macro and bring the data to front but
the main problem i am facing, macro does not tell me the code for
moving a cell up or down. e.g if i move 5 columns right to A5, the
macro says "range("A5").Select". I want to find the code for moving 5
cells right.
could anyone help me with this. Please feel free to give me a different
solution for above problem.
thanks


--
tayyab
------------------------------------------------------------------------
tayyab's Profile:
http://www.excelforum.com/member.php...o&userid=26433
View this thread: http://www.excelforum.com/showthread...hreadid=397016