Auto increment Rows Number in a column using VB

I like to auto increment numbers in ascending order on the rows in Column A until it reaches the end of the data row in Column B, using VB codes and NOT by dragging the cells method. Column A has been created beforehand already.

Example:

Column A has been created beforehand already, and does not contain any numbers. Column B consists of existing data with unknown number of rows. By pressing a button, Column A is filled with auto generated row numbers, starting with 1 for the 1st row of data, and ends with the last number corresponding to the last data entry in Column B.

I like to auto increment numbers in ascending order on the rows in Column A until it reaches the end of the data row in
Column B, using VB codes and NOT by dragging the cells method.

Example:

Column A has been created
beforehand already, and does not contain any numbers. Column B consists of existing data with unknown number of rows (i.e.
450, 569,230,...). By pressing a button, Column A is filled with auto generated row numbers, starting with 1 for the 1st row
of data, and ends with the last number corresponding to the last data entry in Column B.

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

The script is supposed to check column D (Lift truck # column) and find any values that match and then subtract the log
times of the left adjacent C column cells next to the matching numbers in D column and print the diffennce in column G beside
the right bottom most matching number in D.

As you can see the script is seeing "1450" as "50" and displaying the
difference when the two numbers don't actually match. The script is seing the "50" that is in the "1450".

I am
sure there is a quick and easy solution, but I an not experienced enough to know what it is..

i'm currently trying to count the number of unique numbers in a Column
using this formula:
=SUMPRODUCT((A3:A3002"")/COUNTIF(A3:A4002;A3:A3002&""))
So far so good.....But I want to add some conditions like only count
the numbers that meet the condition say N1:N3000="SE*"

I tried a couple of things but nothing seem to work can you
please help
out.....Don't laugh and I will paste my own failed solutions:
=SUMPRODUCT((A1:A3000"");(AND(OR(N1:N3000="SE*"; N1:N3000="INC*")/COUNTIF(A1:A3000;A1:A3000&""))))
On this one I get #VALUE! and i can't figure out why.
I have also tried to put the AND/OR condition before the actual
starting of the array of the SUMPRODUCT but nothing.

i'm currently trying to count the number of unique numbers in a Column using this formula:
=SUMPRODUCT((A3:A3002<>"")/COUNTIF(A3:A4002;A3:A3002&""))
So far so good.....But I want to add some conditions like only count the numbers that meet the condition say
N1:N3000="SE*"

I tried a couple of things but nothing seem to work can you please help out.....Don't
laugh and I will paste my own failed solutions:
=SUMPRODUCT((A1:A3000<>"");(AND(OR(N1:N3000="SE*";N1:N3000="INC*")/COUNTIF(A1:A3000;A1:A3000&""))))
On this one I get #VALUE! and i can't figure out why.
I have also tried to put the AND/OR condition before the actual starting of the array of the SUMPRODUCT but nothing.

Is there a way to use the last number in a column (in a formula) when you
won't know what the exact cell is where that number will be located? The
last number will not be in a constant cell, this column is a running balance
column so additonal rows will be added daily.

How do I select the first occurance of a certain number in a column and then,
as in the "Lookup" function, return a same numbered cell (different column).
I have "0's" and "1's" in my column (intermixed) and I am looking for the
first occurance of a "1". I then want to look up another value in the same
row (different column). "Lookup" function doesn't work if you have multiple
values not sorted. I'm using Excel 2003.

I have Sheet with 40 employees who each proposes their work schedule, so I have to give each Employee access to the same
sheet and want highlight and unlock only those cells that specific employee can use.

Each employee has to login
from a drop-down (sourced from Sheet.Employee Master), so their unique Employee Number is in "A13" of
Sheet.LOGIN

Can I identify the ROW number and then use that ROW number in a macro to highlight and unlock specific
Range of Cells in Sheet.PROPOSED SCHEDULE?
---where "Sheet.LOGIN("A13") = (the value in the cell Col A:"row" of Sheet.PROPOSED SCHEDULE)

I have attached a scaled down version of the Workbook.

Following code is scaled down-- this is for
Employee 02 who appears on ROW 16 of the sheet. (macro is same for each employee, just uses a different row)

I am trying to figure out are the numbers in a column same. In MS Excel 2007.

The column that I need to look at
has a five digit number in each cell and there are several hundred rows.

So I am trying to figure out if the five
digit numbers in each cell within this particular column the same. Instead of using the scroll bar to move the page and
look at each five digit number in each cell in that column.

Is there a formula that will tell if all of the five
digit numbers in each cell within that particular column the same instead of visually trying to look at it??

I trying to create a macro where I have a specific amount of rows in a column copied and I want to
paste it. But every time I paste it I want to increase the row number say A32 to the next one up. I have to go all the way to
A2000 so it would be a lot of copying and pasting. Here's the macro I got going on now.

I have workbook with 3 different sheets that are I'm using as check registers. I want to create a sheet that will tally the
running balances across of each of those sheets. So the question is: How do I reference the last number in a column?

I would like to be able to find all the possible combinations of numbers in a column that sum to a particular
number.

for example I would like to know what combination of the numbers below add up to 606

253
263
851
90
521
85

in this case there are two possible answers 253 +263 +90, or 521+85

If anyone has any suggestions
that would be great.
(also help with just finding the 1st possible answer would also be useful if finding both is too complicated, as there may
only be one useful combination in my set of number anyway.

I have data rows 1-31 in 12 different columns. I want
a to be able to pick
up a the last number entered in each of the columns. So for instance and
have data in rows 1-23 in column A, the data in rows 1-31 ni col B. Is
there a formula to put in row 45 that will pick up the last # entered in a
column.

I'm having trouble getting a formula to work that will average numbers in a column while excluding some data based on the
data in another column.

I think I'm having trouble because I'm seeing some formulas startout with =AVERAGEIF and
others starting out with =AVERAGE(IF ...

[Well, to be honest, since I can't get either approach to work, maybe
that isn't the problem.]

Anyway, here's the situation:
I want to average some of the numbers that appear in column AC (data in cells AC2:AC148) I want to exclude any numbers that
correspond to rows that have an "y" in F2:F148.

How can I locate two adjacent numbers in a column that meets certain criteria?

I have attached a portion of my
excel sheet wherein column A consist of dates and columns B to E comprise the sales figure. You will notice that datas in
column B to E consist of blanks. What I would like to do is to locate automatically two adjacent numbers in a column that
meets a criteria.

I have highlighted 2 numbers in each column which i want to locate. These 2 numbers in each
column have a considerable decrease in amount. For example in column B: 70000/1825 = 38.36; column C: 1825/425 = 4.29
(Criteria: Number1/Number2 >=2).