+ Reply to Thread
Results 1 to 6 of 6

Automatically copy only filled rows from certain sheets to one data sheet

  1. #1
    Registered User
    Join Date
    01-25-2021
    Location
    Vilnius, Lithuania
    MS-Off Ver
    MS Office 2010
    Posts
    6

    Automatically copy only filled rows from certain sheets to one data sheet

    Greetings everyone,

    Hope you can share your opinions on this specific matter (I have looked for couple hours and haven't found this specific topic in the discussions).

    I have created a task tracker for my team of 10 people. There are 10 sheets for everyone of us to fill they weekly tasks and one sheet with main data table where all rows with filled tasks should appear (also there are more sheets with other information). I tried power query, and it worked perfectly, but then I realised I had to make this file shared for everyone to edit it and It's not allowed when workbook contains tables (Office 2010)... So now I am trying to come up with vba code that would (automatically or not) copy*only filled rows*from everyones sheet (for example, everyone would have 10 blank rows to fill, From*B4-K4 to B13-K13*(without headers)) and copy them (when they are filled) to the main table which starts from*F14-O14.*

    I can even pay for the solution, because I feel hopeless at the moment.

    Thank you very much in advance.
    Have a good evening!
    Attached Images Attached Images

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,078

    Re: Automatically copy only filled rows from certain sheets to one data sheet

    Administrative Note:

    You have had the cross-posting explained to you before recently.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    01-25-2021
    Location
    Vilnius, Lithuania
    MS-Off Ver
    MS Office 2010
    Posts
    6

    Re: Automatically copy only filled rows from certain sheets to one data sheet

    I apologize for cross-posting in two forums. The aim was just to find the answer in different platforms, different opinions. I have asked excel experts on mrexcel. com platform, but havent find the solution yet.

    https://www.mrexcel.com/board/thread...sheet.1163232/
    Last edited by AliGW; 03-01-2021 at 04:49 AM. Reason: Link fixed.

  4. #4
    Registered User
    Join Date
    01-25-2021
    Location
    Vilnius, Lithuania
    MS-Off Ver
    MS Office 2010
    Posts
    6

    Re: Automatically copy only filled rows from certain sheets to one data sheet

    Please find the attachment below.
    Attached Files Attached Files

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,078

    Re: Automatically copy only filled rows from certain sheets to one data sheet

    You need to tell us where you cross-posted. You will not be able to post a link properly, so break it up with a couple of spaces.

    As I said in the note above, you will get no further help until you do this.

    As this is your second offence, I will not do it for you this time.

    As you don't appear to have taken the reasons for the rule on board yet, please read the information I linked to in the note.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,078

    Re: Automatically copy only filled rows from certain sheets to one data sheet

    Thank you for providing the link.

+ 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] Automatically copy rows from three sheets to a final sheet, autosorting by date
    By Megan.Jayne in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-09-2018, 02:21 AM
  2. [SOLVED] automatically copy data from different sheets and sequentially copy to another sheet
    By darbar76528 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 10-13-2017, 02:12 PM
  3. [SOLVED] Automatically copy rows to another sheet if criteria filled
    By njf1994 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-18-2015, 06:01 AM
  4. Copy and Paste data automatically from master sheet to other sheets
    By wschleis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2014, 04:29 PM
  5. [SOLVED] Automatically Copy Data from Multiple Sheets to a Master Sheet
    By Ryan_Brandt in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-10-2014, 06:45 AM
  6. Copy filled cells from multiple sheets to 1 sheet
    By jomno69 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-15-2010, 09:59 AM
  7. Copy data from 1 sheet to other sheets automatically
    By mattyb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-24-2008, 03:43 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