software

Hello,

Immediately below is a report I need to export into another report. Sheet
1: Column A shows the date, Column B shows the time frame, you can ignore
column C, Column D shows the number of calls that came in during Column B’s
timeframe and Column E shows the number of abandoned calls.

Sheet 1
A B C D
E
DateTimeCollated TimeAnswered CallsAbandoned Calls
8/29/20047:00:00 1800 0 0
8/29/20047:30:00 1800 0 0
8/29/20048:00:00 1800 2 0
8/29/20048:30:00 1800 2 0
8/29/20049:00:00 1800 9 0
8/29/20049:30:00 1800 5 0
8/29/200410:00:00 1800 4 0
8/29/200410:30:00 1800 9 1
8/29/200411:00:00 1800 5 1
8/29/200411:30:00 1800 7 0

What I need to do is bring the data from sheet 1 into sheet 2. For example
if the Sheet 1 column B matches Sheet 2 column B then the date will be
brought over to column A, Answered calls will be brought over for column c,
etc…

Now an =if may work but keep in mind that the data from sheet 1 will not
always be in the same cell. The location of the data on sheet 1 does vary
from day to day.

Sheet 2
A B C D
E
DateTimeAnswered CallsAbandoned CallsOffered Calls
7:00:00
7:30:00
8:00:00
8:30:00
9:00:00
9:30:00
10:00:00
10:30:00
11:00:00
11:30:00

Thanks for the help!!!You can use a combination of MATCH and INDEX to get the corresponding data
from sheet1.
Ex: in Sheet2!A2: =index(Sheet1!A:A, match($B2,Sheet1!$B:$B,false)).
That effectively finds the row number in sheet1 with the matching time, then
returns the corresponding entry from column A in sheet1. You could copy this
formula into other rows/columns of your table, but in C2, D2 and E2, you'll
need to adjust the first column reference (Sheet1!A:A) to pick up the
appropriate column.

quot;Jimquot; wrote:

gt; Hello,
gt;
gt; Immediately below is a report I need to export into another report. Sheet
gt; 1: Column A shows the date, Column B shows the time frame, you can ignore
gt; column C, Column D shows the number of calls that came in during Column B’s
gt; timeframe and Column E shows the number of abandoned calls.
gt;
gt; Sheet 1
gt; A B C D
gt; E
gt; DateTimeCollated TimeAnswered CallsAbandoned Calls
gt; 8/29/20047:00:00 1800 0 0
gt; 8/29/20047:30:00 1800 0 0
gt; 8/29/20048:00:00 1800 2 0
gt; 8/29/20048:30:00 1800 2 0
gt; 8/29/20049:00:00 1800 9 0
gt; 8/29/20049:30:00 1800 5 0
gt; 8/29/200410:00:00 1800 4 0
gt; 8/29/200410:30:00 1800 9 1
gt; 8/29/200411:00:00 1800 5 1
gt; 8/29/200411:30:00 1800 7 0
gt;
gt; What I need to do is bring the data from sheet 1 into sheet 2. For example
gt; if the Sheet 1 column B matches Sheet 2 column B then the date will be
gt; brought over to column A, Answered calls will be brought over for column c,
gt; etc…
gt;
gt; Now an =if may work but keep in mind that the data from sheet 1 will not
gt; always be in the same cell. The location of the data on sheet 1 does vary
gt; from day to day.
gt;
gt; Sheet 2
gt; A B C D
gt; E
gt; DateTimeAnswered CallsAbandoned CallsOffered Calls
gt; 7:00:00
gt; 7:30:00
gt; 8:00:00
gt; 8:30:00
gt; 9:00:00
gt; 9:30:00
gt; 10:00:00
gt; 10:30:00
gt; 11:00:00
gt; 11:30:00
gt;
gt; Thanks for the help!!!
gt;