Mirror row in another sheet depending of value in column

Hi,

I have searched this forum alot now and really not found any solution to my problem.
My workbook contains 2 sheets, 1 master sheet where all info goes and second where i want rows from master sheet to show depending of value in column A.

In master sheet there is also Contitional Formating to change color of the row depending of what value i put in column A.
The value in column A i set by dropdown list.

So, i want the row from master sheet to show in second sheet when i choose value "Swap" in column A.
It is important that this row does NOT being copied to sheet 2, but mirrored. This because i want the row show or not depending of what value i set in the master sheet.

Good if solution works in both 2003 and 2007.


Really need help here.
Thanks.

With a macro or with formulas?

Post up a sample workbook so we can assist directly, especially if you want formulas only. Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook.

No, it doesn't have to be a macro. I've added a key column in AA of both sheets to provide an index of the rows that need to appear on the second sheet. That makes it easy for a simple index/match formula to grab the sequential key rows from the first sheet and display them.

No macro needed. A bit more complete sample data would have been more helpful, but this should work.

I've put the formulas in the ForUpload sheet down to about row 40, enough for you to see it in action as you do your work on the Bravida sheet.

On the Bravida sheet cell AA2, put this formula then copy down:

=IF(OR(ISNUMBER(SEARCH({"Swappad","På service","Åter i pool","Utdömd"},A2))),N(AA1)+1,N(AA1))

No, it's correct as posted.

The sample you uploaded was devoid of any real test data, just the word Swappad down column A for a ways. When I type random info into the other cells on those same rows, that text shows on the ForUpload sheet.

I can see nothing wrong with the sample workbook.

Originally Posted by JBeaucaire

The sample you uploaded was devoid of any real test data, just the word Swappad down column A for a ways. When I type random info into the other cells on those same rows, that text shows on the ForUpload sheet.

I can see nothing wrong with the sample workbook.

Hi again,

Think i figured it out....

I added text down to row 39 in sheet Bravida-SWAP and it is mirror the text in ForUpLoad perfectly.
If i add text in row 40 and beyond it wont mirror in ForUpLoad??

I cant figure it out whats wrong, do you?

(Not possible to attach since there is a dabase issue on the site)

Thanks.

EDIT:
Found out whats was wrong. Id miss formulas in all cells, thought that i only needed formulas in cell A and AA in ForUpload.
I have expanded the range now to 2500 rows and the sheet is already about 6mb without any information added to it.
Is there any other way to manage the very same thing? VBA?

Sure.

1) Clear the KEY column from the Bravida sheet.
2) Right-click on the ForUpload sheet and select VIEW CODE
3) Paste this code into the sheet module that appears:

Please Login or Register  to view this content.

4) Close the editor and save as a macro-enabled workbook
5) Now each time you bring the FORUPLOAD sheet onscreen, it will reassert

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.