Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
AUTO FILTER NOT CHANGING RESULTS | Excel Discussion (Misc queries) | |||
I need to merge lots of info, w/o copy paste? | Excel Worksheet Functions | |||
Copy paste to another sheet | Excel Discussion (Misc queries) | |||
vba to sort group copy paste to another sheet | Excel Worksheet Functions |