Automatically add line

Asked

Viewed 60 times

0

I wanted an sql script or excel function that runs along the line and when find "Out of Compliance" add me a new line

    Name        Food from Approved Source (C)   Food Protected from Contamination (C)       
16 HANDLES      Out of Compliance                             Out of Compliance

in that new line would have:

         Name       Violation       
      16 HANDLES    Food from Approved Source (C)         
      16 HANDLES    Food Protected from Contamination (C)
sql excel script

  • Hello. Add or replace the line? You are using VBA? Talk of SQL, the data comes from a database? When do you want the addition/replacement to happen? In the database or excel document?

  • the data is in excel, but it is 50000 lines. it was preferable to happen in excel. However I can import into a database and handle through sql query

  • I don’t understand how the new line has to be.

No answers

Browser other questions tagged sql excel script

You are not signed in. Login or sign up in order to post.