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