how can I select a specified range in macro. For example if I have
data in sheet (see below)

ROW A B C F G H---col
1 XX XX XX XX XX XX----data
2 XX XX XX XX XX XX
3 XX XX XX XX XX
4 XX XX XX XX XX
5 XX XX XX XX XX XX
6 XX XX XX XX XX

I want to select range (A1: last value cell in col A & col C) and then
(F1 : col F cell of same row of last value cell in col A & col H)

basically i have data in row 1 from col B to C and then in F to H and
i want to copy the row 1 data down in columns B to C and F to H till
that row in which col A have last value cell