Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
TUNGANA KURMA RAJU
 
Posts: n/a
Default copy from one sheet and paste into other sheets

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default copy from one sheet and paste into other sheets

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
  #3   Report Post  
Posted to microsoft.public.excel.misc
TUNGANA KURMA RAJU
 
Posts: n/a
Default copy from one sheet and paste into other sheets

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

  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default copy from one sheet and paste into other sheets

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 02:56 PM
AUTO FILTER NOT CHANGING RESULTS Dejan Excel Discussion (Misc queries) 25 October 6th 05 02:01 PM
I need to merge lots of info, w/o copy paste? JWS Wholesale Excel Worksheet Functions 0 July 18th 05 07:13 PM
Copy paste to another sheet HrvojeZagi Excel Discussion (Misc queries) 2 April 2nd 05 05:54 PM
vba to sort group copy paste to another sheet mango Excel Worksheet Functions 0 November 5th 04 05:27 AM


All times are GMT +1. The time now is 06:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"