(Excel-VBA) Specific data import (on the background) in the active sheet -


would please me (total beginner) prepare vba macro open sheet on background , import specific selection shown below:

let's have downloaded wordcount analysis (xlsx) this downloaded cat tool testing.

now need add macro main sheet read lines starting (column a) "all". if "all" i'd need record columns of line (specficilly columns - o) in array / hashtable?.

please take @ this image summs (better explaining me :-)

let me know in case need know more details.

all tips / suggestions appreciated.

many thanks!

my suggestion (i'm beginner too) use macro recorder. great tool learn (example).

  1. start recording
  2. filter 'all'
  3. copy/past cells
  4. stop recording

then have @ recorded code , adjust :)


Comments

Popular posts from this blog

java - nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet Hibernate+SpringMVC -

sql - Postgresql tables exists, but getting "relation does not exist" when querying -

asp.net mvc - breakpoint on javascript in CSHTML? -