If Statement with or with VBA, please help

[Legacy 383193]

Hi everyone, I would really appreciate your help on this. I have a range E2:E9 with SKU numbers, some of the cells in the range are blank. In cell A11 I would like to search through the range for the first cell with a SKU#, and copy/paste in A11. Then in D11, I would like to search for the next SKU# and copy/paste in D11 and repeat the process for G11, J11, and M11

Do I need an if statement or VBA and if statement? Either way, I don't know how to articulate it in formula or VBA. Your expertise is super appreciated


I'm not sure if the screenshot is viewable. The url is: https://www.dropbox.com/s/dqq54vc7d67vakz/order form screenshot.png?dl=0

Thank you in advance for your help,
Christine

-- removed inline image ---

 

[hiker95]

I'm not sure if the screenshot is viewable. The url is: https://www.dropbox.com/s/dqq54vc7d6...nshot.png?dl=0

CMYOC,

The screenshot is of a PNG file.

Anyone trying to use your data would have to manually enter it into a workbook/worksheet.

For the future, note that images are not much use to helpers as the data cannot be copied to test things with.


We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com

 

[Legacy 383193]

Wow, last time I just posted a question and got an answer. I've looked at your helps and guidelines and downloaded the htmlmaker and still I don't know what to do with it. Then I need to test it, and sadly, it's just too confusing for me and I don't have the time to train on how to ask a question. I sure appreciated the help I got last time. Thank you for your time.

 

[MARK858]

Wow, last time I just posted a question and got an answer. I've looked at your helps and guidelines and downloaded the htmlmaker and still I don't know what to do with it...
and I don't have the time to train on how to ask a question

There is a video in the 3rd post in the Attachments link showing you how to install and use it. It will take a responder longer than the 7 minutes it will take you to watch the video to answer your question or else post the actual workbook to Dropbox rather than the image (as Hiker95 has already stated).

 

[Legacy 383193]

I don't see a video. just more application downloads. What appears simple and straightforward to you isn't the same for those of us who don't use these extraneous applications. Please just remove this thread or give me a tutorial on how to remove it cause I can't figure that out either. I appreciate you trying to help.

 

[MARK858]

Post #3 in the http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729 link has the link below...

how to install & use the MrExcel HTML Maker

in the last line

 

[FDibbins]

★ CMYOC I fully understand your frustration, getting that "install" sorted out can be challenging.

Another option would be to *try* a copy/paste of some sample data in your post, or just type some in here.

 

[hiker95]

Wow, last time I just posted a question and got an answer. I've looked at your helps and guidelines and downloaded the htmlmaker and still I don't know what to do with it. Then I need to test it, and sadly, it's just too confusing for me and I don't have the time to train on how to ask a question. I sure appreciated the help I got last time. Thank you for your time.

CMYOC,

Cay you supply your actual raw data workbook/worksheets?

And, can you also supply a worksheet with the results that you are looking for?

If you can, then:

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com