I'm sorry, but you haven't asked a question! You've merely stated that you have a listbox populated with the column headings from another file, and the user can select multiple columns and have the data copied from the other file.
I have a question for you though: Why not simply use the listbox to select the columns to display and hide those not selected? Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- >________________________________ > From: Shivani Sachdeva <shivanisachdeva...@gmail.com> >To: excel-macros@googlegroups.com >Sent: Thursday, August 14, 2014 7:29 AM >Subject: $$Excel-Macros$$ Selection on a multi select list box copy and paste >that field from any folder. > > > >Dear All, >I am working on a macro, which asks the required field from multi select list box. >User can select required field, for example some user may be interested in Region ID, >Circle, BSC ID, Cell ID, Sector ID, City/Town. > >Some user may be interested in Circle, BSC ID, Cell ID, Sector ID, City/Town. > >Some user may be interested in BSC ID, Cell ID, Sector ID. > >In sort, Selection on a multi select list box copy and paste that field from any folder. > >That folder may have any location, and contains file which have. >Date >Vendor >Region ID >Circle >BSC ID >Cell ID >Sector ID >City/Town >Lattude/Longitude >1X BTSID >BTS Friendly Name >Total Usage >Primary Usage >SHO Factor >Access Terminal (AT) Attempts >Access Terminal (AT) Failures >Access Terminal (AT) Fail% (>2%) >Access Terminal (AT) Blocks >Access Terminal (AT) Block% (>2%) >Access Network (AN) Attempts >Access Network (AN) Failures >Access Network (AN) Fail% (>2%) >Access Network (AN) Blocks >Access Network (AN) Block% (>2%) >Total Attempts >Total Failures >Total Fail% (>2%) >Total Blocks >Total Block% (>2%) >Session Failed Calls >Session Failed Calls% (>2%) >Session Blocks >Session Block% (>2%) >Drop Calls >DCR% (>5%) >Connection Setup Time (msec) >Unicast Access Terminal Identifier (UATI) Requests >Unicast Access Terminal Identifier (UATI) Failures >Unicast Access Terminal Identifier (UATI) Failures (%) (>2%) >Session Configuration Success Rate (<95%) >Authentications Attempts >Authentications Failures >Authentications Failures (%) (>2%) >A13 Idle Transfer Attempts >A13 Idle Transfer Failure (%) (>2%) >Fwd Slot Occp (%) >FTCH Slot Occp (%) >CCH Slot Occp% >ACH Occp% >Avg DRC Request (kbps) >Fwd Sector Thrput including Buffering Delay (kbps) >Fwd Data Served Volume (MB) >Fwd Data Served Time (sec) >Fwd Sector Thrput when Served (kbps) >Effective Fwd Sector Thrput (kbps) (>1.2 Mbps) >% Utilization >Rev Data Received Volume (MB) >Rev Data Served Time (sec) >Rev Sector Thrput when received (kbps) >Effective Rev Sector Thrput (kbps) >Radio Link Protocal (RLP) Fwd Data Volume (MB) >RLP Fwd ReTrx Bytes (MB) >RLP Fwd ReTrx Rate% >Ratio of Fwd RLP to PL >RLP Rev Data Volume (MB) >RLP Rev ReTrx Req Bytes (MB) >RLP Rev ReTrx Req Rate% >Ratio of Rev RLP to PL >HO Attempts >HO Failures >HO Failures (%) (>2%) >Abis Blocks >Max Users (>20) >LongTrm Avg RSSI Rise(dB) >LongTrmPeakRSSI Rise (dB) >Total Users >Date Of Integration >No. of Carriers >Cell Call Traffic (Erl) >Cell Softer Handoff Traffic (Erl) >Cell Soft Handoff Traffic (Erl) >% Data Loading > > > -- >Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >https://www.facebook.com/discussexcel > >FORUM RULES > >1) Use concise, accurate thread titles. Poor thread titles, like Please Help, >Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get >quick attention or may not be answered. >2) Don't post a question in the thread of another member. >3) Don't post questions regarding breaking or bypassing any security measure. >4) Acknowledge the responses you receive, good or bad. >5) Jobs posting is not allowed. >6) Sharing copyrighted material and their links is not allowed. > >NOTE : Don't ever post confidential data in a workbook. Forum owners and >members are not responsible for any loss. >--- >You received this message because you are subscribed to the Google Groups "MS >EXCEL AND VBA MACROS" group. >To unsubscribe from this group and stop receiving emails from it, send an >email to excel-macros+unsubscr...@googlegroups.com. >To post to this group, send email to excel-macros@googlegroups.com. >Visit this group at http://groups.google.com/group/excel-macros. >For more options, visit https://groups.google.com/d/optout. > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
