offset example wanted

  • Thread starter Thread starter aussiemike
  • Start date Start date
A

aussiemike

I wish to click on a single cell and have a row of data show
elsewhere.
i.e I have four rows of data in a worksheet.
One is green one red one yellow and one white.
When I click on the red cell I want the data from my red collectio
entered in a selected row.
When I click on the green cell I want the green collection entere
where the red collection was.etc etc
Can this be done?
TIA
Regards from Africa
Aussiemik
 
Hi, is there more than one row red or green, etc....

one way to do it is create one new column called ID or something, to use as
a auto filter, than, a VBA project could auto filter for you.

regards
Marcelo from Brazil


"aussiemike" escreveu:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Cells by Format 2
Dynamically sized table compiled from unsorted rows with blank entries 2
Multiple Variables in Conditional Formatting with Excel 2003 1
drop down list formula 10
How to extract separated text by many commas in Excel? 0
CountIf Condition based on lookup in a list of values 5
Conditional formatting dates 3
Conditional Formatting from a group 6

Back
Top