Can't get Active offset and how to move around the spreasheet

So I wrote this macro by recording part of it and reading up on some notes regarding active offset. So far so good.
Now I am at C17 and I am trying to move over to A16. I know how to go left 2, but not up 2, enter the account number like 12345678 and copy it up from A16 to A1.
Than I need to move to F and if the amount is not zero, enter "R" and if Zero enter "V" and stop at row 16. The row number can change each day.
I have not had to write macros for a long time, I find it frustrating now. Need some help.

Hi Annelie

Are you sure that the uploaded file is the correct one...What are you actually wanting to achieve...

Now I am at C17 and I am trying to move over to A16.

Please Login or Register  to view this content.

My macro actually just takes out headers and footers from a report exported to excel.

So offset(-1, -2) means: first position -1 is row up, 1 means row down, second position is the column -2 meaning go left 2?
However, there is another problem, the number of rows will vary every day. There cannot be static rows. How do you establish the last row?

I still have to fill column A, F, G. it is an issued check list for a bank.
I attached another spreadsheet with what the finish product is supposed to look like. I cannot see it right now.

After all is done, I need to copy and paste this to notepad which seems to be the only format that comes over as a clean text file.

Why don't you upload a sample file with a before | after scenario and explain exactly what this daily process entails...

I don't seem to be able to do that, I went to manage attachments and uploaded it, but I cannot get it to show.

I have been doing this but I still do not see the file.

Need to wait for file to upload and once it displays...then Close window submit reply...

last try for upload. Mya be I have to start a new post

explain exactly what this daily process entails...

The data exported into Excel is in column BCDE.
I have to add the account number in Column A, Add R or V (V for Void if the amount is zero)in col. F, and the letter A in Column G.

Than I have to combine all into text file (somebody helped me with that):
=A1&","&TEXT(B1,"0.00")&","&C1&","&TEXT(D1,"ddmmyy")&","&E1&","&F1&G1
copy down,copy and paste the result into notepad.

Tried to save in Excel as various .txt files, but all resulted errors in the file. Copy and paste into notepad was the only thing that worked.

maybe:

Please Login or Register  to view this content.

Can you change this line:
Accn = Application.InputBox("Enter account number", "Fill accounts", , , , , , Type:=2)

Input accounts =123456789 as sample. This number never changes.

In that case, just delete the inputbox line and change the one below it to
Range("A1").FormulaR1C1 = "123456789"

It is not entering the account number in col. A. Col F and G work.
I cannot us cvs file, but I already have a routine I can use to create that later.

You need to delete the lines:
Dim Accn As String
and
Range("A1").FormulaR1C1 = Accn