sheet1
col A ---- col B ---- col C
1 name date salevalue
2 John 7DEC05 175$
3 Lara 7DEC05 524$
Find if "John" sheet exists in this workbook then copy b2:c2 and paste them
in "John" sheet last empty row,next find if "Lara" sheet exists in this
workbook then
copy b3:c3 and paste them in "Lara" sheet last empty row,like that loop this
task
end of last row of sheet1.Any body pl.give me complete code.

I'd steal some code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

If you keep all the data in that first sheet, then you could use the create new
sheets version--it tosses the old sheets and starts again.

If you don't, then maybe you want the second version.

TUNGANA KURMA RAJU wrote:

sheet1
col A ---- col B ---- col C
1 name date salevalue
2 John 7DEC05 175$
3 Lara 7DEC05 524$
Find if "John" sheet exists in this workbook then copy b2:c2 and paste them
in "John" sheet last empty row,next find if "Lara" sheet exists in this
workbook then
copy b3:c3 and paste them in "Lara" sheet last empty row,like that loop this
task
end of last row of sheet1.Any body pl.give me complete code.

--

Dave Peterson

Thanks,Mr.Dave.I need second version because ,I don't want to replace old
data as my master sheet data(sheet1) changes daily as it gives me only
current date data only.My sheet 1 data is downloaded file of current date
data.This post is raplica of my previous posts"macro to automise the task"
,"copy,paste and loop through workbook".As desired by you I rewritted them.

"Dave Peterson" wrote:

I'd steal some code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

If you keep all the data in that first sheet, then you could use the create new
sheets version--it tosses the old sheets and starts again.

If you don't, then maybe you want the second version.

TUNGANA KURMA RAJU wrote:

sheet1
col A ---- col B ---- col C
1 name date salevalue
2 John 7DEC05 175$
3 Lara 7DEC05 524$
Find if "John" sheet exists in this workbook then copy b2:c2 and paste them
in "John" sheet last empty row,next find if "Lara" sheet exists in this
workbook then
copy b3:c3 and paste them in "Lara" sheet last empty row,like that loop this
task
end of last row of sheet1.Any body pl.give me complete code.

--

Dave Peterson

Post back with any specific questions you have after you've tried modifying the
second version.

TUNGANA KURMA RAJU wrote:

Thanks,Mr.Dave.I need second version because ,I don't want to replace old
data as my master sheet data(sheet1) changes daily as it gives me only
current date data only.My sheet 1 data is downloaded file of current date
data.This post is raplica of my previous posts"macro to automise the task"
,"copy,paste and loop through workbook".As desired by you I rewritted them.

"Dave Peterson" wrote:

I'd steal some code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

If you keep all the data in that first sheet, then you could use the create new
sheets version--it tosses the old sheets and starts again.

If you don't, then maybe you want the second version.

TUNGANA KURMA RAJU wrote:

sheet1
col A ---- col B ---- col C
1 name date salevalue
2 John 7DEC05 175$
3 Lara 7DEC05 524$
Find if "John" sheet exists in this workbook then copy b2:c2 and paste them
in "John" sheet last empty row,next find if "Lara" sheet exists in this
workbook then
copy b3:c3 and paste them in "Lara" sheet last empty row,like that loop this
task
end of last row of sheet1.Any body pl.give me complete code.

--

Dave Peterson


--

Dave Peterson