Macro to create new row in separate worksheet when condition is met? in Excel Questions

[Artist701]

I ran into a problem i couldn't fix using formulas. I appreciate any help on this.

The problem: I have two excel sheets... (Representing a Horse Race with point system situation)

• sheet 1 shows manual data. Includes:
Names, ID of the person, their horse name, date they raced and Points they received for that race.

• sheet 2 will need to generate a new row of a person that participated as well as points they received that date and the total points. (BUT only if they participated, or else row should Not generate at all)

Sheet 2 should display all the racers and their respective dates they raced that continue to populate if they race and points received those race days.. These should be stacked on top of each other, racer after racer displaying their results as shown in the example url below:

~ http://www.westcoastbarrelracing.com/Points_8-30.pdf

i hope this makes sense.

Thanx a mil.

 

[hiker95]

Artist701,

You have posted a link to a PDF file. This means that if this was a problem where one needed to use your data, anyone trying to help you would have to enter the data manually. That makes no sense.

What version of Excel and Windows are you using?

Can you post a screenshot of the raw data worksheet, and, post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post your data, you can download and install one of the following two programs:
Excel Jeanie
MrExcel HTML Maker

Or, when using Internet Explorer, just put borders around your data in Excel and copy those cells into your post.
See reply #2 the BLUE text in the following link:
http://www.mrexcel.com/forum/about-board/444901-how-create-table-like-aladin.html#post2198045


If you are not able to give us screenshots:
You can upload your workbook to Box Net,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.

 

[Artist701]

I apologize I'm new at this.

The excel file is attached.. and the PDF file is what it "should" output.
This can possibly be generated by a secondary sheet in my case "output" receiving a macro that can calculate and add the new row and add the total points?

I'm attaching a sample excel screenshot that i just created that is how we use to punch in the information. I've frozen the first 3 columns to keep those always showing. I hope I make better sense.

http://www.thebusinessjournal.com/images/test.png

 

[Artist701]

The second sheet "Output" is currently blank but should look like the PDF sample as shown in first message. I can customize the look and feel but the
calculations need a macro to generate rows. I may be wrong but I hear formulas do not populate new rows of data.

 

[hiker95]

Artist701,

You have posted another link to a graphic/png file.

In order to continue:

You can upload your workbook to Box Net,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.


If you are not able to use BOX, then:

Click on the Reply to Thread button, and just put the word BUMP in the post. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[Artist701]

Wow I sincerely apologize again. I am Learning though. Thanx for having a look at it. It's a very simple sheet.

https://app.box.com/s/h9ff7doidx6ghadjpxg6

 

[hiker95]

Artist701,

Thanks for the workbook.

Here is what we have so far:

Excel 2007
	A	B	C	D	E	F	G	H
1					12/1/13	9/5/13	9/6/13
2	ID	RIDER (Last, First Name)		HORSE	Rafter Bar M	SJVR	RR Product
3	2026R	Allison	Jolie	Katies Merada	80		10
4	1068R	Anderson	Eve	GSP Golden Money Bar
5	1056R	Baily	Breanna	Smokem Dry		80
6
Data

Excel 2007
	A	B	C	D
1
2
3
4	Alysson
5	#N/A
6
7
8
Output

• sheet 1 shows manual data. Includes:
Names, ID of the person, their horse name, date they raced and Points they received for that race.

• sheet 2 will need to generate a new row of a person that participated as well as points they received that date and the total points. (BUT only if they participated, or else row should Not generate at all)

1. Please complete Sheet2 by manually copying the data from Sheet1 (no formulae).

2. Then post the workbook again.

 

[Artist701]

I have managed to drop the manual version on the BOX account..
This shows both sheets..

https://app.box.com/s/50irov2cwfab6tftoen2

Thank You.

 

[hiker95]

Artist701,

Thanks for the latest workbook, and, a very interesting/complex project. Let me think about this.

Here are some screenshots of the two worksheets, just in case anyone else wants to jump in.

Excel 2007
	A	B	C	D	E	F	G	H
1					12/1/13	9/5/13	9/6/13
2	ID	RIDER (Last, First Name)		HORSE	Rafter Bar M	SJVR	RR Product
3	2026R	Allison	Jolie	Katies Merada	80		10
4	1068R	Anderson	Eve	GSP Golden Money Bar
5	1056R	Baily	Breanna	Smokem Dry		80
6	1000S	Jones	Tom	Gem	88	44	44
7	3199S	Scott	Jeff	Fast Her	66
8	3198S	Scott	Jeff	Fast Him			80
9
Data

Excel 2007
	A	B	C	D	E	F
1		Shows Attended and Points
2
3		Alysson, Jolie
4		2026R
5		Katies Merada
6
7			12/1/2013	Rafter Bar M		80
8			9/6/2013	RR Product		10
9
10			# of shows attended - 2		Total Points	90
11
12
13		Anderson, Eve
14		1068R
15		GSP Golden Money Bar
16
17			# of shows attended - 0		Total Points	0
18
19
20		Baily, Breanna
21		1056R
22		Smokem Dry
23
24			9/5/2013	SJVR		80
25
26			# of shows attended - 1		Total Points	80
27
28
29		Jones, Tom
30		1000S
31		Gem
32
33			12/1/2013	Rafter Bar M		88
34			9/5/2013	SJVR		44
35			9/6/2013	RR Product		44
36
37			# of shows attended - 3		Total Points	220
38
39
40		Scott, Jeff
41		3199S
42		Fast Her
43
44			12/1/2013	Rafter Bar M		80
45			9/6/2013	RR Product		10
46
47			# of shows attended - 2		Total Points	90
48
49		Fast Him
50			9/6/2013	RR Product		80
51
52			# of shows attended - 1		Total Points	80
53
54
Output

 

[Artist701]

Thanx for looking into it. I can manage to get all the calculations I need via formulas but the problem lies in generating new rows for new event dates added and than getting a new calculation based on the new information.

Artist701,

Thanks for the latest workbook, and, a very interesting/complex project. Let me think about this.

Here are some screenshots of the two worksheets, just in case anyone else wants to jump in.

Excel 2007

	A	B	C	D	E	F	G	H
1					12/1/13	9/5/13	9/6/13
2	ID	RIDER (Last, First Name)		HORSE	Rafter Bar M	SJVR	RR Product
3	2026R	Allison	Jolie	Katies Merada	80		10
4	1068R	Anderson	Eve	GSP Golden Money Bar
5	1056R	Baily	Breanna	Smokem Dry		80
6	1000S	Jones	Tom	Gem	88	44	44
7	3199S	Scott	Jeff	Fast Her	66
8	3198S	Scott	Jeff	Fast Him			80
9

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Data​

Excel 2007

	A	B	C	D	E	F
1		Shows Attended and Points
2
3		Alysson, Jolie
4		2026R
5		Katies Merada
6
7			12/1/2013	Rafter Bar M		80
8			9/6/2013	RR Product		10
9
10			# of shows attended - 2		Total Points	90
11
12
13		Anderson, Eve
14		1068R
15		GSP Golden Money Bar
16
17			# of shows attended - 0		Total Points	0
18
19
20		Baily, Breanna
21		1056R
22		Smokem Dry
23
24			9/5/2013	SJVR		80
25
26			# of shows attended - 1		Total Points	80
27
28
29		Jones, Tom
30		1000S
31		Gem
32
33			12/1/2013	Rafter Bar M		88
34			9/5/2013	SJVR		44
35			9/6/2013	RR Product		44
36
37			# of shows attended - 3		Total Points	220
38
39
40		Scott, Jeff
41		3199S
42		Fast Her
43
44			12/1/2013	Rafter Bar M		80
45			9/6/2013	RR Product		10
46
47			# of shows attended - 2		Total Points	90
48
49		Fast Him
50			9/6/2013	RR Product		80
51
52			# of shows attended - 1		Total Points	80
53
54

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Output​