How can these things be done in Excel VBA?

[quantum231]

I have created a spreadsheet that must be processed and these steps require use of VBA. If I can find out, how to do these basic things, then my task will become a lot easier.

1) A list exists in Column A, find its length starting from cell A2. If cell A2 is empty then list does not exist. The first empty cell is end of list. Store address of last item in list. List could also be 1 item long.
2) Where list ends, also store the address of cell at offset (1,1) from this i.e one row down and one column to the right
3) Column E contains two possible values in each cell like a drop down list basically, either "-" or "Yes". All rows where it says "Yes", the row number must be stored in some variable. For these rows, print the value of column C.
4) Validate data between two spreadsheets called "sheet1" and "sheet2". Both of them create a list as described in A. The is that, the list may or may not be the same size. But, there must be no duplicate values between these two sheets in column D. If this is so then an error message must be generated.
5) Also, the value in (4) must not exceed 255.

6) I intend to use the stored coordinates of cells for (1), (2) and (3) to generate text into output file.

Now I understand that for anyone here, this description may not make complete sense. I am not looking for a complete solution, just need some guidance. Obviously I have to complete this work on my own, even if someone did it for me and I decided to have more functionality, it would be inconvinient.

[armando12345]

I think this code accomplishes the first two. idk about the rest

Please Login or Register  to view this content.

[alansidman]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)