Copy contents of a cell dependent on contents of another

**emerges** · 03-14-2011, 05:31 PM

I haven't done anything advanced in Excel and I found that I have no idea to do what I'm looking for. Basically, I am importing a .txt file that is a listing of directories in Sharepoint. Column A of the first row starts with Directory blah blah (and a bunch of stuff spread over 5 columns), but all I really care about is what is in column E for each row that starts with Directory. There are then a bunch of rows that start with dates (numbers) in Column A listing all of the files in the directory listed in the row above it. Then there is another row starting with Directory, then subsequent rows starting with dates again.

What I would like to do is have Excel go down Column A and if it see "Directory" I would like it to copy the contents of cell E of that same row. When it sees a date (number) I'd like it to paste the contents it copied into column F of that row. Repeating the copy and paste. So it will paste the same thing each time until it comes to a row that begins with "Directory". I should point out that there are empty rows between the rows that begin with "Directory" and thoses that begins with dates, so I'm guessing the function will just skip over these rows.

Thanks for your help!

**MarvinP** · 03-14-2011, 05:48 PM

Hi emerges and welcome to the forum,

We need a short example of your file to deal with this question. Click on the "Go Advanced" below the message area and then on the Paper Clip Icon to upload an attached sample file. This will be your best chance of getting a good answer.

**emerges** · 03-14-2011, 06:13 PM

Here is an example files (attached).

I have been messing around with nesting IF and CELL functions, but haven't yet figured out how to have it keep pasting the sames contents until it sees Directory again. Thanks!

**MarvinP** · 03-14-2011, 07:12 PM

Hi emerges,
I have your sample but am a little confused on what dates you want to copy and where.
Could you do the first one by hand and background it so I can see your method?
Do you want the dates or numbers or filenames in column F? Repeat column E?

One more sample with expected and we can do it.

**emerges** · 03-15-2011, 10:56 AM

I highlighted the cells that I would like to copy into Column F. Every time a row appears with Directory, the contents of cell E in that row are copied and then pasted in the rows below that start with a date. Does that make sense?