A little help needed

[Pretty Vacant]

Morning all,

I have a spreadsheet with a list of tasks and their costs. I would like to be able to manually put in a quantity against some of the tasks and populate a summary sheet on a separate worksheet.
So,
I have a list of tasks as belowup to about 650 rows)

code	Task	Amount	Cost
1B.001.01	Task A	1	150
1B.001.02	Task B	2	200
1B.001.03	Task C	1	100
1B.001.04	Task D		50
1B.001.05	Task E	1	25
1B.001.06	Task F	1	35

<tbody>
</tbody><colgroup><col><col><col span="2"></colgroup>

and I'd like to end up with something like below on a separate worksheet:

code	Task	Amount	Cost	Amount
1B.001.01	Task A	1	150	150
1B.001.02	Task B	2	200	400
1B.001.03	Task C	1	100	100
1B.001.05	Task E	1	25	25
1B.001.06	Task F	1	35	35

<tbody>
</tbody><colgroup><col><col><col span="3"></colgroup>

Can anybody assist me with this? Any help is gratefully received.

P

 

[Fluff]

Is this what you're after

Sub Copysht()
' Pretty Vacant

    ActiveSheet.Copy Before:=Sheets(1)
    ActiveSheet.Name = "New"
    Columns(3).SpecialCells(xlBlanks).EntireRow.Delete
    Range("E1").Value = "Amount2"
    Range("E2").Formula = "=C2*D2"
    Range("E2", Range("D" & Rows.Count).End(xlUp).Offset(, 1)).FillDown
    
End Sub

 

[Pretty Vacant]

Thank you for your post.

It doesn't quite do what I'm after which is probably down to me not explaining it properly.

The second sheet will be a summary of the first. So there is a table formatted exactly the same as Sheet 1 but unpopulated. I want to be able to manually enter a quantity against tasks in sheet 1 and the task name (B1:B650) and those tasks pop up in the table in sheet 2. so there could be 30 or 40 tasks out of the original 650 that have a quantity assigned to them that would need to be replicated in Sheet 2.

not sure if this is explaining it right but I'm grateful for any help

P

 

[FormR]

Hi, is the "code" a unique identifier for each row?

Excel 2013/2016
	A	B	C	D	E	F	G
1	code	Task	Amount	Cost		Helper:	5
2	1B.001.01	Task A	1	150
3	1B.001.02	Task B	2	200
4	1B.001.03	Task C	1	100
5	1B.001.05	Task E	1	25
6	1B.001.06	Task F	1	35
7
8
9
Sheet1

Cell Formulas
Range	Formula
A2	=IF(ROWS($A$2:A2)>$G$1,"",INDEX(Sheet2!$A$2:$A$1000,AGGREGATE(15,6,(ROW(Sheet2!$A$2:$A$1000)-ROW(Sheet2!$A$2)+1)/(Sheet2!$C$2:$C$1000<>""),ROWS(A$2:A2))))
B2	=IF(A2="","",VLOOKUP($A2,Sheet2!$A$2:$D$1000,2,0))
C2	=IF(B2="","",VLOOKUP($A2,Sheet2!$A$2:$D$1000,3,0))
D2	=IF(C2="","",VLOOKUP($A2,Sheet2!$A$2:$D$1000,4,0))
G1	=COUNTIF(Sheet2!$C$2:$C$1000,"<>")

 

[Pretty Vacant]

Thank you so very much for this

P