troubleshooting Question

INSERT A ROW IN EXCEL SPREADSHEET DEPENDING ON CRITERIA

Avatar of Pabilio
PabilioFlag for Spain asked on
ProgrammingMicrosoft ExcelVisual Basic Classic
6 Comments1 Solution363 ViewsLast Modified:
Hi,

Attached is a sample of the data that I´m working with....is a monthly store's sales resume.

Columna A have the date of sale ...column B have the invoice number...the other columns have details of the sale....one day could have more than one sale or none at all.

What I need is when I press a command button the code inserts a row when there is a day without sale, writing in column C: "NO SALE"  ...  and when is saturday or sunday (Shop closed) the code have to insert a row for each non workable day and write in column C: "NO WORKING DAY".

In the document attached, in sheet "hoja1" is how I have the data actually and in sheet "hoja2" is how I need it (The final result after the code runs)

I really appreciate your help with this.

Thank you for your time.
Roberto.
SAMPLE.xls
ASKER CERTIFIED SOLUTION
Dave

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros