Data auto populate

**Martin Chamberlin** · 10-02-2011, 07:36 AM

Have re written question and file attached in hope it simplifies what I am looking for. Its driving me nuts so would appreciate any help.

I need to populate row 6 from task duration in row 2 (manual input) at each start point shown in Row 5. This is probably really easy but am just too green to solve the puzzle.

Any help appreciated Thanks

Chambo

**Turbo Dog** · 10-03-2011, 05:30 PM

I see you haven't had any replies...maybe I'm not the only one afraid of opening that file. Try copying the formulas and putting them in the forum as text.

**Martin Chamberlin** · 10-03-2011, 06:08 PM

Originally Posted by Turbo Dog

I see you haven't had any replies...maybe I'm not the only one afraid of opening that file. Try copying the formulas and putting them in the forum as text.

Was wondeing why no one was responding. There are no formulas in the file but I have pdf'd the attachment.

Thanks for the reply

Chambo

**Martin Chamberlin** · 10-03-2011, 06:18 PM

Originally Posted by Martin Chamberlin

Was wondeing why no one was responding. There are no formulas in the file but I have pdf'd the attachment.

Thanks for the reply

Chambo

ps. Is there anything suspicious about the original attachment?? The last post I placed got zero response also. Feedback appreciated.

**Simon Lloyd** · 10-04-2011, 03:46 AM

Martin, you are correct with the way you posted your workbook, this IS how its accepted here and required, no-one like workbooks that have to be downloaded from elsewhere but a standard xls, xlsx or xlm is fine

@ Turbo Dog as you can see i have shown some Excel file extensions above if you're not familiar with them i can help you out
.xls = standard 97 - 2003 format could contain macros
.xlsx = 2007 - 2010 standard workbook WITHOUT macros
.xlm = 2007 - 2010 stndard workbook WITH macros

So you need not fear opening that workbook!

**Martin Chamberlin** · 10-05-2011, 03:11 AM

Originally Posted by Simon Lloyd

Martin, you are correct with the way you posted your workbook, this IS how its accepted here and required, no-one like workbooks that have to be downloaded from elsewhere but a standard xls, xlsx or xlm is fine

@ Turbo Dog as you can see i have shown some Excel file extensions above if you're not familiar with them i can help you out
.xls = standard 97 - 2003 format could contain macros
.xlsx = 2007 - 2010 standard workbook WITHOUT macros
.xlm = 2007 - 2010 stndard workbook WITH macros

So you need not fear opening that workbook!

Thanks Simon, where do I find the file extensions you mention? Regards

**Simon Lloyd** · 10-05-2011, 11:47 AM

At the end of the attached file!, his file is called "hlookup or andif help.xlsx" so looking at the end of the name of any attached file will let you know which format it's in

**Martin Chamberlin** · 10-05-2011, 12:54 PM

Originally Posted by Simon Lloyd

At the end of the attached file!, his file is called "hlookup or andif help.xlsx" so looking at the end of the name of any attached file will let you know which format it's in

Thats the file I originally attached. I was confused when Turbo Dog said viewers may not want to open it.

I still dont have a solution. Help!