How should I skip blank cells?

Microsoft Excel 2010 - windows
November 30, 2010 at 21:34:32
Specs: Windows 7
I have data that looks like this below:

Humptys Bumptys Tommies Harries
Floaters Price Cost Price Cost Price Cost Price Cost

35.00 22.00 31 15 45 20

I want to make it look like this below:

Humptys Bumptys Harries
Floaters Price Cost Price Cost Price Cost

35.00 22.00 31 15 45 20


Since Tommies has not relevant data it should not show up. Any ideas how this can be achieved? Thanks!


See More: How should I skip blank cells?

Report •


#1
November 30, 2010 at 21:55:19
Please read the How To referenced below and then repost your example so that we can see the correct lay out.

Posting Tip: Before posting Data or VBA Code, read this How-To.


Report •

#2
November 30, 2010 at 22:41:09
Thanks for your prompt reply Derby. I have not really used macros or advanced functions in Excel often. Hence the struggle! I need some spoon feeding like a baby and I hope you would kindly bear with me.

I tried typing in the macro but I am unable to get it working. Do you mind tailor making it for my problem? I would really appreciate if you could kindly help me out. Here is a more clearer description of my problem.


Butter Butter fat Milk

cost price cost price cost price

AGA 20 30 15 20

After I run the "if loop" or the macro I should be able to get all the revelant data. The blanks cells above under Butter fat are irrelevant for me. The new table should like this as shown below:

Butter Milk

cost price cost price

AGA 20 30 15 20

Note the "Butter fat" section is gone since there is no relevant data available. I need to do this for about 818 rows and 61 columns. Thanks for your help in advance Derby! Cheers!


Report •

#3
November 30, 2010 at 22:48:38
Derby,

I have posted a reply to your earlier response. I think it is difficult to get the formatting right in this editor. Do you mind providing me your email id? I can email you my sample excel sheet and you can email me back with the macro or the nested if statement that does the trick. Sorry I am bothering you too much. As I mentioned I am kind of a freshman in this area. Thanks a lot for your help!

Cheers!


Report •

Related Solutions

#4
December 1, 2010 at 04:15:49
re: "I think it is difficult to get the formatting right in this editor."

Did you read the How To referenced in my subject line? Click on the words How To and follow the instructions given there. They explain how to line up your data to make it easier to read.

It also explains how to use the Preview Follow-up button to view (and re-view) your post so that you can check the formatting before you post it.

I prefer not to answer questions via email because they do not get saved in the archives for others to benefit from. I might do it as a last resort, but we are not at that point yet.

Posting Tip: Before posting Data or VBA Code, read this How-To.


Report •

#5
December 1, 2010 at 07:36:19
I think it is difficult to get the formatting right in this editor.

Here is an expanded version of DerbyDad03 How To

Step 1. Click the Pre icon found above the Reply box.
Step 2. Enter your data/table(s) or VBA code between the tags. (See below)
Step 3. Click the Preview Follow Up button, below on the right, DO NOT press Submit Follow Up.
Step 4. If you need to fix the layout, the top window shows what your messages looks like, 
        the bottom window allows you to fix and modify your message. Make your changes here.
Step 5. At the top there is a box with "Check To Show Confirmation Page Again" check this box.
Step 6. Click either Confirm button to Preview the post again.

You can now edit your message again, make your changes/edits and 
to review these new edits start at step 5.
You can keep making corrections until you get it the way you want.


Pre Tags
When you click on the pre button,
two symbols should appear in your message,
they should be the word PRE
surrounded by left & right arrows
they should look like:

< pre > < / pre >

I've added spaces between everything to highlight what they look like, they will not have the spaces normally.

Post your data between the two symbols:

< pre >

    A         B        C
1) Data      Goes     here
2) more      data     here

< / pre >

This will keep the columns aligned.
When you preview your message, you can now modify the columns so everything lines up correctly

MIKE

http://www.skeptic.com/


Report •

Ask Question