Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Joao Silva   on Mar 26 In MS Office Category.

  
Question Answered By: Taylor Evans   on Mar 26

: Combine means first file  data is first then at end of the first
: file data second file data will be append but only one header  in
: the new file (either from first file or the second one doesn't
: matter because they both have same headers).

Okay. Let's describe the data. Does the script have to locate
the data or is it in a named or fixed range?
Both files  have same column name and same values accept one has less data

If the script has to locate the data in each sheet, does the
range of cells ever contain empty cells?
No. Also there is only one sheet  in both file which contains data

Will it ever contain empty cells in the future?
No

How do we find the header in the second file? Is it always in
a certain row? At the top of the data? Is it in just one row or
many? Is it a named range?
At the top of the data, first row in both file and just one row

Share: 

 

This Question has 7 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Copy two excel files into third with one header Or get search suggestion and latest updates.


Tagged: