+ Reply to Thread
Results 1 to 6 of 6

Need VBA Combine All Sheet Data Depends Upon Column Header

  1. 07-12-2023, 09:29 AM #1
    johnmacpro
    johnmacpro is offline
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Need VBA Combine All Sheet Data Depends Upon Column Header

    Dear Expert

    I have multiple which need to consolidated into one sheet with particular columns only.

    i have more than 20 sheet with huge data around , i want consolidated into one sheet with name of sheet where from coiped

    the data copy only depends upon column assigned ,

    find the attachment.

    regards
    Geo
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-12-2023, 09:50 AM #2
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,220

    Re: Need VBA Combine All Sheet Data Depends Upon Column Header

    Hi John,

    I think this is a Power Query problem and solution, more than VBA. Read:
    https://community.fabric.microsoft.c...ame/m-p/877507
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  3. 07-12-2023, 10:09 AM #3
    nankw83
    nankw83 is offline
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,713

    Re: Need VBA Combine All Sheet Data Depends Upon Column Header

    Hi johnmacpro,

    Try below code ... I just ignored sheet "Dashboard" since it is blank
    Please Login or Register  to view this content.
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name
    Reply With QuoteRegister To Reply
  4. 07-12-2023, 05:55 PM #4
    johnmacpro
    johnmacpro is offline
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Re: Need VBA Combine All Sheet Data Depends Upon Column Header

    Thanks alot for quick solution , its works perfectly solved
    Reply With QuoteRegister To Reply
  5. 07-12-2023, 08:57 PM #5
    johnmacpro
    johnmacpro is offline
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Re: Need VBA Combine All Sheet Data Depends Upon Column Header

    HI sir

    one question?
    is line of code assign column No if we want extent or reduce{1, 3, 4, 5, 6, 7, 14, 15, 16, 17, 18} depends upon my requirement
    Reply With QuoteRegister To Reply
  6. 07-12-2023, 11:50 PM #6
    nankw83
    nankw83 is offline
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,713

    Re: Need VBA Combine All Sheet Data Depends Upon Column Header

    Quote Originally Posted by johnmacpro View Post
    one question?
    is line of code assign column No if we want extent or reduce{1, 3, 4, 5, 6, 7, 14, 15, 16, 17, 18} depends upon my requirement
    Yes, the numbers represent the columns that you want to include & thanks for the Rep+
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How do I quickly fill in a table where the cell depends on it's row and column header?
    By BlueFalcon in forum Excel General
    Replies: 3
    Last Post: 04-13-2020, 11:23 PM
  2. [SOLVED] lookup data from origin sheet to new sheet with switch column header.
    By kimudao in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-05-2015, 09:44 AM
  3. Ms access Vba Save Data to xl depends upon 1 table pick & Depends 2 Upon fiterDate
    By breadwinner in forum Access Programming / VBA / Macros
    Replies: 14
    Last Post: 05-29-2014, 10:59 PM
  4. sum the range depends upon header value in column result in row and col wise
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-20-2014, 06:37 AM
  5. [SOLVED] VBA pull data from closed workbook depends upon header status !!! need help of experts
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-12-2013, 07:06 AM
  6. Combine multiple columns into one column with header and date in another column
    By JJadams in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-12-2012, 05:30 PM
  7. Combine by column header
    By dameon7777 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2010, 06:16 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1