+ Reply to Thread
Results 1 to 4 of 4

How to remove blank row in formulated sheet

  1. #1
    Registered User
    Join Date
    08-25-2017
    Location
    Sialkot Pakistan
    MS-Off Ver
    2013
    Posts
    43

    How to remove blank row in formulated sheet

    Hello Everyone,
    Have a good day, I'm trying to make a sheet in which all the data will be entered in 'Sheet 1' manually. While in other sheet specific data of individual will be taken automatically with formula from 'Sheet 1'. There are some blank rows found in 'ABC','DEF','GHI'. I would like to ask if there's any need to change the formula or some thing else. So that data automatically put to related sheets without any blank rows. Sample sheet is attached.
    Attached Files Attached Files
    Last edited by AliGW; 12-28-2019 at 04:21 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: How to remove blank column in formulated sheet

    You are talking about blan columns, but are showing blank rows. I will update your title, as it is currently misleading.

    This can be done with PowerQuery - are you still using Excel 2013?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    08-25-2017
    Location
    Sialkot Pakistan
    MS-Off Ver
    2013
    Posts
    43

    Re: How to remove blank row in formulated sheet

    Yes, Columns, Rows. Yes, i'm using Ms. Excel 2013.
    Thanks for Title correction.
    Waiting for favourable response regarding query.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: How to remove blank row in formulated sheet

    The attached sheet shows each of the three separate tables converted to Excel tables and loaded as a connection only, then combined using an append query and filtering out the blank rows.
    Attached Files Attached Files

+ 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. Copyiing formulated rows from one sheet to another
    By mscarr in forum Excel General
    Replies: 6
    Last Post: 12-18-2013, 11:54 PM
  2. Find & select 1st blank cell in a range of formulated column cells
    By jnbroek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2013, 09:26 AM
  3. Clear column D cell based on a blank formulated column A cell
    By jnbroek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-18-2013, 11:05 AM
  4. Cant workout a sum formula if formulated cells return a blank
    By bopsgtir in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-19-2013, 08:53 AM
  5. [SOLVED] The formulated cell appear blank
    By imran91 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-05-2012, 11:36 PM
  6. [SOLVED] VBA Code Required to autofill formulated column according to the adjacent column
    By bonny24tycoon in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-30-2012, 12:05 PM
  7. Remove blank sheet from custom .xla Add in....
    By Mr. Smith in forum Excel General
    Replies: 3
    Last Post: 07-12-2006, 12:55 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