Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOw can I use Copy and Paste Function
Hello, I have a workbook which has 30 worksheets. the card No# in every sheet is not completely same. such as , Sheet1: Card NO# Summary A001 20 A002 30 sheet2: Card NO# Summary A001 10 B001 20 .... sheet30: Card No# Summary A001 10 A002 20 A003 30 B001 10 ..... Now I need add a new sheet in this workbook, convert ervery sheet as column , c opy and paste all the sheet together. the structure like the following: Card NO# Sheet1 Sheet2 sheet3.... A001 20 10 ... A002 30 ..... B001 20 .... ... I use the two loops to implement it. it run so slowly. Do you guys know how to write a formula for this function? Thanks -- whygh ------------------------------------------------------------------------ whygh's Profile: http://www.excelforum.com/member.php...o&userid=29679 View this thread: http://www.excelforum.com/showthread...hreadid=493977 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy/paste Function | Excel Discussion (Misc queries) | |||
copy and paste function | Excel Worksheet Functions | |||
Copy and Paste function | Excel Worksheet Functions | |||
cut,copy paste function | Excel Discussion (Misc queries) | |||
Copy and Paste Function | Excel Programming |