mcrmg
asked on
Excel copy column to new sheet
Hi,
I have an excel file that contains about 10 columns.
I need to create three new columns on a new sheet based on the date range.
ID col1 col2 col3
1 9/1/2011 9/1/2011 9/1/2011
2 9/2/2011
3 9/3/2011 9/6/2011
4 9/4/2011 9/3/2011
5 9/5/2011
let's say, date range is 9/1-9/5
new sheet
col1 col2 col3
1 1 1
2 4
3
4
5
I have an excel file that contains about 10 columns.
I need to create three new columns on a new sheet based on the date range.
ID col1 col2 col3
1 9/1/2011 9/1/2011 9/1/2011
2 9/2/2011
3 9/3/2011 9/6/2011
4 9/4/2011 9/3/2011
5 9/5/2011
let's say, date range is 9/1-9/5
new sheet
col1 col2 col3
1 1 1
2 4
3
4
5
ASKER
please have a look..thx
Book1.xls
Book1.xls
Hi,
What is the expected output, which logic has applied to get the results,
col1 col2 col3
1 1 1
2 4
3
4
5
Where these above values will get filled, is it a count? or sum? etc.,
KK,
What is the expected output, which logic has applied to get the results,
col1 col2 col3
1 1 1
2 4
3
4
5
Where these above values will get filled, is it a count? or sum? etc.,
KK,
ASKER
hi,
The logic is to get any row that within 9/1-9/5
and place the ID column into the new sheet..thx
The logic is to get any row that within 9/1-9/5
and place the ID column into the new sheet..thx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
could you please attach the sample excel workbook what you are expecting
KK.