+ Reply to Thread
Results 1 to 2 of 2

Import csv file data in their respective sheets

  1. #1
    Registered User
    Join Date
    10-16-2018
    Location
    Latvia
    MS-Off Ver
    2016
    Posts
    6

    Import csv file data in their respective sheets

    so i have a import system that i use to import 2 csv files. the first csv file containts 17 rows of (User data) and the other csv file contains 3896 rows of (Book data).i have 2 sheets where the data from those csv files had to be stored (USERS) and (BOOKS) currently you can import the user data or book data in any of those sheets, the thing im trying to achieve is that when you import let's say the book csv file you can only import the data into the BOOKS sheet not in the user sheet or any other sheet, the same applies for the User csv file. (Here is the import code im using it's a cutdown version from the full program, because the program is bigger then the limit)
    Please Login or Register  to view this content.
    i have tried to find something similar on the internet but i didn't find any info . any help is appreciated, Thank you in advance!

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Import csv file data in their respective sheets

    You could look at the headers then decide and restrict the copying to the specific file..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Import .xls file in .xlsm file using macro and vlookup the sheets in new sheets
    By pacificepoc in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2018, 04:06 AM
  2. Pull Data From Rows into Respective Sheets
    By mike_302 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-06-2017, 05:57 PM
  3. Import text file and split data into specific sheets with Applet names
    By swethachepur in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2014, 09:07 AM
  4. Import text file into excel and split data in specific sheets
    By chirilaionut in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 06-03-2013, 07:04 AM
  5. I want Macros to delete exisitng sheets and import new data from a .csv file.
    By parinita_kothari in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-16-2012, 06:26 AM
  6. copy data from main sheet to respective sub sheets
    By sshanku1985 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-14-2011, 12:26 PM
  7. Data distribution among respective sheets
    By itsmark in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-26-2010, 07:27 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1