excel - Export data in multiple columns into multiple sheets -

-

i export column data separate sheets export individual ascii text files. specific data shown whereby copy first 2 columns (x, y coordinates) , each individual column thereafter own sheet. 

 x     y    comp1   comp2   comp3   comp4    …  comp23 -40  -20    55.29   0       0       73       …  105.67 -40  -19.9  56.79   0       33      72       …  112.5 -40  -19.8  69.29   0       31      89       …  114 -40  -19.7  70.29   0       58.14   108      …  125  …    …     …       …       …       …        …  …  40   55    72.29   0       49      117      …  132

i'm still getting grips writing macros right trying adapt recorded macro 1 of iterations work entire sheet looks follows:

sub copycoldata()     activecell.range("a1:b1").select     range(selection, selection.end(xldown)).select     selection.copy     sheets.add after:=activesheet     activesheet.paste     sheets("sheet1").select     sheets("sheet1").name = "comp1"     sheets("sum").select     application.cutcopymode = false     activecell.offset(0, 2).range("a1").select     range(selection, selection.end(xldown)).select     selection.copy     sheets("comp1").select     activecell.offset(0, 2).range("a1").select     activesheet.paste end sub

ideally create new worksheet each column coordinate data in first 2 columns, label worksheet according column title , copy column data onto third column. afterwards i'll export multiple sheets individual ascii files using different macro. thanks!

all jerry beaucaire (again!) added counter sheet naming: 

option explicit  sub columnstosheets() 'author:    jerry beaucaire 'date:      8/7/2011 'summary:   create separate sheets columns of data sheet  dim wsdata   worksheet   'sheet data parse dim firstcol long        'this first column transfer dim colcnt   long        'this how many columns in group transfer dim lastcol  long        'check row1 see how many columns of data there dim newsht   long        'how many new sheets created dim inti integer         'counter sheet naming  firstcol = application.inputbox("which column first 'data column' transfer?" _     & vblf & "(a=1, b=2, c=3, etc...)" _     & vblf & "(all columns left appear on every sheet)", _     "first data column", 2, type:=1) if firstcol = 0 exit sub  colcnt = application.inputbox("how many data columns in each group?", _     "groups of columns", 1, type:=1) if colcnt = 0 exit sub inti = 1 set wsdata = activeworkbook.sheets("sheet1") application.screenupdating = false    wsdata     lastcol = .cells(1, .columns.count).end(xltoleft).column     newsht = firstcol lastcol step colcnt         sheets.add , after:=sheets(sheets.count)         .columns(1).resize(, firstcol - 1).copy range("a1")         .columns(newsht).resize(, colcnt).copy cells(1, firstcol)         activesheet.name = "comp" & inti         inti = inti + 1     next newsht   end application.screenupdating = true end sub

Comments

Post a Comment

Popular posts from this blog

ios - UICollectionView Self Sizing Cells with Auto Layout -

-
Image
i'm trying self sizing uicollectionviewcells working auto layout, can't seem cells size content. i'm having trouble understanding how cell's size updated contents of what's inside cell's contentview. here's setup i've tried: custom uicollectionviewcell uitextview in contentview. scrolling uitextview disabled. the contentview's horizontal constraint is: "h:|[_textview(320)]", i.e. uitextview pinned left of cell explicit width of 320. the contentview's vertical constraint is: "v:|-0-[_textview]", i.e. uitextview pinned top of cell. the uitextview has height constraint set constant uitextview reports fit text. here's looks cell background set red, , uitextview background set blue: i put project i've been playing on github here . updated ios 9 after seeing github solution break under ios 9 got time investigate issue fully. have updated repo include several examples of different configurations s
Read more

node.js - ldapjs - write after end error -

-
i have created authentication service using following code in node.js , ldapjs. var when = require ('when'); var authenticationerror = require('../errors/authenticationerror'); var sessionmanagerservice = require('./sessionmanagerservice'); var ldap = require('ldapjs'); var client = ldap.createclient({ url: 'ldaps://ad.mycompany.com:636', tlsoptions: {'rejectunauthorized': false} }); module.exports = { signin: function (email, password) { return this.ldapbind(email, password).then( function () { return sessionmanagerservice.createsessionhash({email: email}); } ); }, ldapbind: function (email, password) { var deferred = when.defer(); client.bind(email, password, function(err) { if (err) { deferred.reject (new authenticationerror('invalid username and/or password!', 'authentication.signin.error')
Read more

DOM Manipulation in Wordpress (and elsewhere) using php -

-
DOM Manipulation in Wordpress (and elsewhere) using php - i'm quite new dom manipulation world , head start in order avoid mutual errors. i looking efficient way manipulate content generated wordpress using php. @ moment using simple html dom seems work fine. found domdocument , few others , helpfull if cleared out 1 faster, improve or @ to the lowest degree generate less errors in case of bad markup. also on side can explain syntax (instead of $html @$html) thank much php wordpress domdocument simple-html-dom
Read more