Question on what I think is IF function!!

[rallynut]

I am trying to get 2 spreadsheets to link together but I only want certain information from the first to be transferred to the second - my biggest problem is that I am using text.

for example, In the first spreadsheet I would like to copy the whole of row 1 only if cell C1 contains the letters HFL. If these letters are anything else then I don't want that row copied...

Can anyone help?!! ray:

 

[staticbob]

Hi Rallynut, Welcome to the board !

Are you using formula to copy this data or VBA Code ?

With a formula, you can use a simple if statement.

In cell A1 of the NEW spreadsheet type . .

=IF('[filename.xls]Sheet1'!$A$3="HFL",'[filename.xls]Sheet1'!A1,0)

. . then drag this accross the row with the fill handle.

NOTE - Replace "filename" and sheet1 with the relevant info from your source file.

HTH
Bob

 

[rallynut]

Hi Bob,

Thanks for your reply, I have been using formula as I wouldn't recognise VBA code if it hit me over the head!!

I'll try your solution and get back...

 

[rallynut]

Hi Bob,

I'm not sure if I'm doing something wrong here but I have tried it and no joy...

I just get #name?

Do you have a VBA solution - I'm willing to try anything!

 

[Aladin Akyurek]

Care to post a small sample?

 

[rallynut]

How do I post a sample?

I thought I had it cracked thanks to Bob, but when I copy the cells across, if I take out the dollar signs it only recognises cell A3 for example instead of checking column 3 on each row for the letters and if I leave them in I can't copy across!!!! Help!!

 

[staticbob]

RN,

You need to keep the dollar signs in mate, but like this A$3 rather than the absolute reference ($A$3) I gave you initially.

Try that.

To post a sample, look at the pinned topics at the top of the forum. In particular . .

HTML Maker FAQ (How to show your sheet on the board)


Bob

 

[rallynut]

OK, I've managed it!! Here is a sample of my spreadsheet... The only problem I can think of is that because it is linked to another, do you need that one as well?? Also it doesn't look quite right somehow!! I will happily email a copy of the spreadsheet to anyone who wants it though!

Book6
	C	D	E	F	G
10	Ahmed	0	HFL	0	0
11	Ashwell	0	0	39MillHillLane	Completionhasbeendelayed-newdate7/12
12	Aubrey	0	0	0	Nocontactfromclient
13	Baldwin	BAL127	0	0	Chasedclientsforquestionnaire-29/11
Sheet1

 

[rallynut]

Trying again manually this time!

Book6
	C	D	E	F	G
10	Ahmed	0	HFL	0	0
11	Ashwell	0	0	39 Mill Hill Lane	Completion has been delayed - new date 7/12
12	Aubrey	0	0	0	No contact from client
13	Baldwin	BAL127	0	0	Chased clients for questionnaire - 29/11
Sheet1

 

[Aladin Akyurek]

You need to post a sample of source data that, based on a condition, must be transferred to a different area.