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

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

thanks Mike F
Actually i am trying to make a league table for my team of 10. Thi
will calculate the weekly score of each employee on a seperate sheet
so there are 10 sheet one for each employee and all of them have go
same format and fields names and numbers. Even if an employee is absen
one week he will have a field for that date. For me it was easy to mak
a small change in cell's coding and get them to read data to frontEn
but it's my manager who is going to use it and she wants to do it wit
a click of button. Unfortunately, I am novel to VBA. I shall b
grateful if you could suggest a way out in detail. All i need is t
copy the last filled row on each of those 10 sheets and paste it on th
frontEnd against the correct employee's name. Obviously we can get th
macro or VBA code to delete the unwanted column once they are all ther
in the frontEnd.
cheer

--
tayya
-----------------------------------------------------------------------
tayyab's Profile: http://www.excelforum.com/member.php...fo&userid=2643
View this thread: http://www.excelforum.com/showthread.php?threadid=39701