How to transfer results from one sheet to another!

[brianxd01]

Would someone please help me out? I need to auto transfer data results from one worksheet to a summary page of another worksheet. For example, I have on sheet 1(called June 1), column A,B,C are salesman A,B,C and rows 1,2,3... are the sales throughout the day, then row 10 is the Total for each salesman. Each new day I would delete all previous datas, change the date then input datas for that day. I want to be able to every time I keyed in a data in sheet1 (June1), the result will automatically transfer to a pre designed table on sheet2 (Monthly Total). I've searched everywhere but couldn't find anything. Thank you so so much..

 

[timumich]

Assuming I am visualizing your data correctly, a simple answer would be to use an "HLookup" function.
Say you just put new data into Sheet1 (with the different sales people as columns, and the actual sales as rows), then you would go to Sheet2 (which I envision will contain each day in June as columns and the sales people as rows). If you type in something like "=hlookup($A2,Sheet1!$A$1:$S$100,<*>,false)" then it should successfully fill in the totals for each sales person.
**NOTE** - the "<*>" must be replaced with the row number that contains the totals for each salesperson.
And after you compile one day, make sure you "Paste Values" on Sheet2 so the formulas disappear, then you can use the formula again when you get fresh data.

This can also be automated into a Macro if you want to save another minute or two every day.

 

[brianxd01]

Hi Timumich, really appreciate your help on this issue.

Brianxd01,

 

[DavidB70]

I apologize if I have posted in the wrong area, but I as well am looking for what I believe is a similar result. My example would be:
Sheet 1
cell A1 has a value of 1
cell A2 has a value of 1
cell A3 would have the sum (using formula =sum(A1:A2))of both being 2

How would I transfer the value or total in A3 to sheet 3? I tried using the formula "=HLOOKUP($A2,Sheet1!$A$1:$S$100,<*>,FALSE)", changing the <*> to sheet1!A3 and I received a message/error "#N/A".

I thought I was an above average user of Excel, but reading through the various threads it appears that I am very novice. I thought it might be a simple command to perform this function.

Is there a simple function or command that may be used for a novice user?

Thank you in advance!

Dave

 

[RoryA]

I assume you want something more than =Sheet1!A3 but I can't really see what. Could you elaborate what you think you should be looking up?

 

[pedro-egoli]

Here is a bit of a stab at first problem posed

This is Sheet named Jun1

Excel Workbook
	A	B	C
1	15	30	10
2	*	*	*
3	*	*	*
4	*	*	*
5	*	*	*
6	*	*	*
7	*	*	*
8	*	*	*
9	*	*	*
10	15	30	10
Jun1

and this is the Monthly total sheet

Excel Workbook
	A	B	C
2	Salesman A	Salesman B	SalesmanC
3	Jun1	Jun1	Jun1
4	a10	B10	C10
5	15	30	10
Monthly total

As totals are entered in cells A1:A9 the total in A10 will transfer to Monthly total sheet

Pedro

 

[DavidB70]

rorya,

I am looking to be able to add cell A1 with cell A2 with the formula in cell A3 (=sum(A1:A2)). Then I would like the total in A3 to be transfered to worksheet 2 to cell A3.

Thank you,

Dave

 

[pedro-egoli]

As rorya said

 =Sheet1!A3 to go in cell A3 of Sheet 2

Does that do the job for you?
Pedro