Grrr.... MS Excel doing my head in again

rossored

Senior member
2,103 56
hi peeps - another non-trading question but what the hell...

i dont know if this is possible but if someone knows how I'd be eternally grateful as it would save me a lot of copying and pasting.

Is it possible to set something up in Excel which works like this:

If I put some data into a row on "Worksheet 1" which contains, for example on column 2, the phrase "abc", can I create a formula or a rule that will automatically copy that entire row to a worksheet called "abc".

Does this make sense? It does to me because I'm typing it but that doesnt mean a lot.

How about a picture showing what I mean?
 

Attachments

  • notaclue.JPG
    notaclue.JPG
    48.2 KB · Views: 321

Glenn

Experienced member
1,040 118
go into worksheet abc
Into cell A1 type the following =IF(sheet!worksheet!="abc",sheet!worksheet1A1,"")
Copy and paste it into the rest of the row in sheet abc.
That should do it.
Glenn
 

FetteredChinos

Veteren member
3,897 40
ok buddy, try this on for size. at the moment the best i can think of is an IF statement located on the second sheet. only problem is that the 2nd sheet will have loads of gaps in it, where the data of the first sheet isnt "abc" etc.

ive highlighted the cells with formulae in yellow on the 2nd sheet.

let me know it this is what you were after, if not, then i'll have another think.

FC
 

Attachments

  • arse over tit.xls
    18.5 KB · Views: 364

FetteredChinos

Veteren member
3,897 40
balls, you all beat me to it.

i'll go back in me box now...
 

Glenn

Experienced member
1,040 118
No FC you got it right.
I was too quick and missed something vital out
=IF(sheet!worksheet!$B$2="abc",sheet!worksheet1A1,"")
That's what I meant. Only had 2 hrs sleep last night 8~/
Glenn
 

rossored

Senior member
2,103 56
Hmm.

Either I've gone completely wrong or I havent explained myself right, but thanks for your offers so far.

Basically, if Column B = "abc" then I want to copy the entire contents of the row which has "abc" in it to another worksheet.

Does that make more sense? I'm completely baffled now!!! A cool Caffreys is sitting somewhere calling my name, and its getting louder by the minute.
 

rossored

Senior member
2,103 56
ah sheet (lol) probably.

I've probably messed it up - bit like everything else today. Tsk.

I'll have another go!

Thanks FC!
 
 
AdBlock Detected

We get it, advertisements are annoying!

But it's thanks to our sponsors that access to Trade2Win remains free for all. By viewing our ads you help us pay our bills, so please support the site and disable your AdBlocker.

I've Disabled AdBlock