About Us

Vacuum Sealed

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.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Checking Column Entries	gtb	Excel Worksheet Functions	9	November 3rd 08 06:10 AM
Checking entries against a column of data	TonyR	Excel Discussion (Misc queries)	1	May 31st 07 07:21 PM
Checking a cell's (Row,Column)	Craig[_21_]	Excel Programming	3	December 25th 05 01:47 PM
checking celll in column	withblue	New Users to Excel	3	May 26th 05 08:39 PM
checking value in column	sals	Excel Programming	1	December 18th 03 08:01 PM

Menu

About Us