A little help grabbing the last cells
A little help grabbing the last cells
(OP)
Hi guys. I am not the best at writing code. I typically just record simple macros. However, I have a sheet that gets updated daily and I want to be able to take the last 7 rows (a weeks worth) of data and export into a separate table on another sheet. Any help would be greatly appreciated. Thanks.





RE: A little help grabbing the last cells
--MechEng2005
RE: A little help grabbing the last cells
RE: A little help grabbing the last cells
gets you to the last cell
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: A little help grabbing the last cells
Selection.End(xlDown).Select
ActiveCell.Offset(0, 1).Range("A1").Select
Selection.End(xlUp).Select
-->ActiveCell.Offset(-8, 0).Range("A1:L9").Select
ActiveCell.Activate
Selection.Copy
Sheets("All").Select
ActiveCell.Offset(0, 1).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
RE: A little help grabbing the last cells
RE: A little help grabbing the last cells
» A "dynamic range";
» The INDEX function;
» Entering this INDEX function as an array formula.
See the example that (I hope) I have uploaded.
htt
RE: A little help grabbing the last cells
-- MechEng2005
RE: A little help grabbing the last cells