excel - macro to extract specific column from multiple worksheet in one sheet -


i copy specific column like(name, dob, dod, address, salary) form multiple sheet in one. have written below code working colums want specific column in "combined sheet" 

sub combinesheet()    dim j integer     on error resume next    sheets(1).select    sheets(comb_sheet).name = "combined"    sheets(2).activate    range("a1").entirerow.select    selection.copy destination:=sheets(1).range("a1")     j = 2 sheets.count       sheets(j).activate       range("a1").select       selection.currentregion.select       selection.offset(1, 0).resize(selection.rows.count - 1).select       selection.copy destination:=sheets(1).range("a65536").end(xlup)(2)    next     sheets(1).select    sheets(comb_sheet).name = "combined"    columns("a:z").select    selection.entirecolumn.autofit     application.screenupdating = false end sub


Comments

Post a Comment

Popular posts from this blog

html - How to custom Bootstrap grid height? -

why bootstrap grid has height 591.067 ? did height came ? .main-post { padding: 20px; background-color: #fff; border: 1px solid #d8d8d8; margin-bottom: 100px; } .main-post .post-categories { margin-bottom: 10px } .main-post h3 { margin: 0 0 10px; color: #777; letter-spacing: -1px; font-weight: bold } .main-post .post-author, .main-post .post-date, .main-post .post-comments { font-size: 12px } .main-post img { display: block; margin: 10px 0; } .main-post .post-summary { line-height: 1.7; color: #888 } .main-post { color: #999 } <div class="col-sm-6"> <div class="main-post"> <h3 class="post-title"> <a href="#"> post title </a> </...
Read more

javascript - pass values from mssql to views in node -

being new node js , javascript . have been trying find solution problem . this app.js file var express=require ('express'); var bodyparser = require('body-parser'); var path = require ('path'); var sql = require('mssql'); var app = express(); const config = { user: 'sa', password: 'password', server: 'localhost\\sqlexpress', // can use 'localhost\\instance' connect named instance database: 'pcgdb', options: { encrypt: false // use if you're on windows azure } }; const request = new sql.request() //view engine app.set('view engine', 'ejs'); app.set('views', path.join(__dirname, 'views')) app.use(bodyparser.json()); app.use(bodyparser.urlencoded({extended: false})); app.get('/',function(req,res){ res.render('index') }); app.get('/new_project', function(req, res) { function(data,err){ ...
Read more

python - Getting 405 error while trying to download nltk data -

when try below code python -c "import nltk; nltk.download('punkt'); nltk.download('averaged_perceptron_tagger'); nltk.download('maxent_treebank_pos_tagger'); nltk.download('wordnet')" the console says [nltk_data] error loading punkt: http error 405: not allowed. [nltk_data] error loading averaged_perceptron_tagger: http error 405: [nltk_data] not allowed. [nltk_data] error loading maxent_treebank_pos_tagger: http error 405: [nltk_data] not allowed. [nltk_data] error loading wordnet: http error 405: not allowed. this caused down-age of github raw file link. meanwhile stop-gap solution manually download file: path_to_nltk_data=/home/username/nltk_data/ wget https://github.com/nltk/nltk_data/archive/gh-pages.zip unzip gh-pages.zip mv nltk_data-gh-pages/ $path_to_nltk_data we're working on finding alternative data , model downloading. meanwhile, @everyone please check script(s) , make sure you're not...
Read more