Hi

how can i check the data in in column A when i am in another cell, for
instance if i am in cell g1 i want to check what is in A1, but this
will be variable

many thanks

On 12/03/2012 8:51 AM, wrote:
Hi

how can i check the data in in column A when i am in another cell, for
instance if i am in cell g1 i want to check what is in A1, but this
will be variable

many thanks

Hi

Can you clarify what you want to check in Column A.

Would you not be able to see the value in A1 even though you have
selected G1 as the active cell.

Will G1's value, or any other cell have some bearing on the outcome of
specific cells in Column A.

Is Column A subject to sub-totaling or grouping or any other nested
types of formula's that may effect the outcome.

Mick.

On Mar 12, 1:06*am, Vacuum Sealed wrote:
On 12/03/2012 8:51 AM, wrote:

Hi

how can i check the data in in column A when i am in another cell, for
instance if i am in cell g1 i want to check what is in A1, but this
will be variable

many thanks

Hi

Can you clarify what you want to check in Column A.

Would you not be able to see the value in A1 even though you have
selected G1 as the active cell.

Will G1's value, or any other cell have some bearing on the outcome of
specific cells in Column A.

Is Column A subject to sub-totaling or grouping or any other nested
types of formula's that may effect the outcome.

Mick.

Hi

i could be in any column or any row, i have a macro that scrolls down
a column, checking what value is in the A column on the active row i
am in, i was thinking about a simple offset check, but the next time i
run the program i will be starting in the next column so the offset
would change

many thanks

On 12/03/2012 8:03 PM, wrote:
On Mar 12, 1:06 am, Vacuum wrote:
On 12/03/2012 8:51 AM, wrote:

Hi

how can i check the data in in column A when i am in another cell, for
instance if i am in cell g1 i want to check what is in A1, but this
will be variable

many thanks

Hi

Can you clarify what you want to check in Column A.

Would you not be able to see the value in A1 even though you have
selected G1 as the active cell.

Will G1's value, or any other cell have some bearing on the outcome of
specific cells in Column A.

Is Column A subject to sub-totaling or grouping or any other nested
types of formula's that may effect the outcome.

Mick.

Hi

i could be in any column or any row, i have a macro that scrolls down
a column, checking what value is in the A column on the active row i
am in, i was thinking about a simple offset check, but the next time i
run the program i will be starting in the next column so the offset
would change

many thanks

Ok

Now we're getting somewhere.

What is is that your code is not doing, or more specifically, what is it
that you want the offset to do.


Dim c As Range, myRng As Range
Set c = Range("A1:A100") 'change range to suit
For Each c In myRng
If c.Offset(0, 6).Value = c Then
With c
'Do Something
End With
End If
Next c
End Sub


I this is not what you are looking for, post what you have and we'll
suss it out.

Mick.

On Mar 12, 9:26*am, Vacuum Sealed wrote:
On 12/03/2012 8:03 PM, wrote:





On Mar 12, 1:06 am, Vacuum *wrote:
On 12/03/2012 8:51 AM, wrote:

Hi

how can i check the data in in column A when i am in another cell, for
instance if i am in cell g1 i want to check what is in A1, but this
will be variable

many thanks

Hi

Can you clarify what you want to check in Column A.

Would you not be able to see the value in A1 even though you have
selected G1 as the active cell.

Will G1's value, or any other cell have some bearing on the outcome of
specific cells in Column A.

Is Column A subject to sub-totaling or grouping or any other nested
types of formula's that may effect the outcome.

Mick.

Hi

i could be in any column or any row, i have a macro that scrolls down
a column, checking what value is in the A column on the active row i
am in, i was thinking about a simple offset check, but the next time i
run the program i will be starting in the next column so the offset
would change

many thanks

Ok

Now we're getting somewhere.

What is is that your code is not doing, or more specifically, what is it
that you want the offset to do.

Dim c As Range, myRng As Range
Set c = Range("A1:A100") 'change range to suit
For Each c In myRng
If c.Offset(0, 6).Value = c Then
With c
* *'Do Something
End With
End If
Next c
End Sub

I this is not what you are looking for, post what you have and we'll
suss it out.

Mick.- Hide quoted text -

- Show quoted text -

Thanks for this


I have a table of data on sheet1 say for instance

COLUMN A COLUMN B
RED 12
BLUE 13
YELLOW 14


This data is pasted into A1 every week

I have another table on sheet 2 thats looks like this

COLUMN A COLUMN B COLUMN C COLUMN D
01/03/2012 01/03/2012 01/03/2012
RED 1 2 3
BLUE 1 2 3
YELLOW 1 2 3

What i do at the moment is goto sheet to and type in the current week
in the next free column

Then i want to populate that column with the data in sheet 1 into the
correct row of my new column in sheet 2

sometimes there will be blanks in the data which is why i am finding
it tricky, and also the order of the data from sheet one is never
constant and sometimes may include colours (for this demo) that i have
never had before so would not find them on sheet 2 so would need to
add another colour to the list

Hope this explains it a bit more, thanks very much for your help.

On 13/03/2012 12:12 AM, wrote:
On Mar 12, 9:26 am, Vacuum wrote:
On 12/03/2012 8:03 PM, wrote:





On Mar 12, 1:06 am, Vacuum wrote:
On 12/03/2012 8:51 AM, wrote:

Hi

how can i check the data in in column A when i am in another cell, for
instance if i am in cell g1 i want to check what is in A1, but this
will be variable

many thanks

Hi

Can you clarify what you want to check in Column A.

Would you not be able to see the value in A1 even though you have
selected G1 as the active cell.

Will G1's value, or any other cell have some bearing on the outcome of
specific cells in Column A.

Is Column A subject to sub-totaling or grouping or any other nested
types of formula's that may effect the outcome.

Mick.

Hi

i could be in any column or any row, i have a macro that scrolls down
a column, checking what value is in the A column on the active row i
am in, i was thinking about a simple offset check, but the next time i
run the program i will be starting in the next column so the offset
would change

many thanks

Ok

Now we're getting somewhere.

What is is that your code is not doing, or more specifically, what is it
that you want the offset to do.

Dim c As Range, myRng As Range
Set c = Range("A1:A100") 'change range to suit
For Each c In myRng
If c.Offset(0, 6).Value = c Then
With c
'Do Something
End With
End If
Next c
End Sub

I this is not what you are looking for, post what you have and we'll
suss it out.

Mick.- Hide quoted text -

- Show quoted text -

Thanks for this


I have a table of data on sheet1 say for instance

COLUMN A COLUMN B
RED 12
BLUE 13
YELLOW 14


This data is pasted into A1 every week

I have another table on sheet 2 thats looks like this

COLUMN A COLUMN B COLUMN C COLUMN D
01/03/2012 01/03/2012 01/03/2012
RED 1 2 3
BLUE 1 2 3
YELLOW 1 2 3

What i do at the moment is goto sheet to and type in the current week
in the next free column

Then i want to populate that column with the data in sheet 1 into the
correct row of my new column in sheet 2

sometimes there will be blanks in the data which is why i am finding
it tricky, and also the order of the data from sheet one is never
constant and sometimes may include colours (for this demo) that i have
never had before so would not find them on sheet 2 so would need to
add another colour to the list

Hope this explains it a bit more, thanks very much for your help.

John

You stated "You are Finding it tricky", and "Colors". I am flying blind
here, you need to post what code you have been working with so I can
help with what you have so I don't have re-invent the wheel.

Also, please confine your answers to the newsgroup as I will not respond
to direct email contact unless invited as someone else out in the
community may also benefit from what it is we come up with.

Post your code and we can move forward.

Mick.

explained :
Hi

how can i check the data in in column A when i am in another cell, for
instance if i am in cell g1 i want to check what is in A1, but this
will be variable

many thanks

If you're talking about a formula that gets used, AND you want it to
ref column "A" but whatever row the formula is in...

IF($A1<"",1,0)

...where the 'absolute' ref to column "A" is defined by the "$"
character prefix, and the row ref is relative to the row using the
formula. Here's how that works...

$A1: Column-absolute, row-relative
$A$1: Fully absolute to Range("$A$1")
A$1: Column-relative, row-absolute
$A:$A: Fully absolute to Columns("A")
$1:$1: Fully absolute to Rows(1)

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion