Automatically copy value from one cell to another skipping empty cells.

[wzm108it]

I know the title sounds basic, but I can't find anything that fits my issue.

I have a sheet that will have a list of times, by minute, down column A. Column B will be filled with notes during an installation as far as what is going on next to the corresponding time. What I need is a way for Excel to automatically take the lines that have text and copy them into another sheet that will allow for easier ability to copy and paste the timeline into our install ticket for future reference. I know the formula to pull the time based on the comment that is copied. I just can't for the life of me figure out how to automatically have Excel pull the information from one sheet to the next, and skip to the next cell with a comment and paste that.

I have attached a file for reference. The log is a sample of how it would be keyed in. The dashboard would be how I would need it to appear. The key being to get the column B under Dashboard to copy over like that as automatically as possible.

Thank you!

[MarvinP]

Hi and welcome to the forum,

If you make your data a list or table (that has the dropdowns at the top) and use column B and unclick the word "Blank", then only what you want will show. Then select the filtered cells and paste them using Values Only to your new sheet.

Look at http://www.contextures.com/xlautofilter01_2003.html for AutoFilter basics.

[wzm108it]

This items that would be keyed in would always be different and I need the items that are keyed into the log column B to be placed in column B of the dashboard in order so that everything in the dashboard, time and comments minus the times when nothing happened, can be copied from excel and pasted somewhere else.

[bebo021999]

Try this Array formula in A1

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Drag down and across.

[wzm108it]

THANK YOU bebo021999!!!!!!!!!!!!!!!!!!!!!!!!!!!

[bebo021999]

You are welcome. This is a very old-basic topic that can be searched in any excel forum.
Good luck!
Please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[wzm108it]

Yeah I searched for it and found something similar, but for some reason just couldn't get it to work! I must of been messing something up when modifying it for my needs.

[sktneer]

@wzm108it

Please update your profile to reflect the correct version of Excel you are using.
And also if that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

[sktneer]

You may also use that Array Formula like this.....(requires CSE.)

Please Login or Register  to view this content.

and then copy across and down.