VBA copy data from ("Sheet4") to frontsheet ("Sheet1")

[mkh12ab]

Hello every1

i am not sure how to begin, but i hope some1 can help me here?

i need to copy some data based on 9 different values. ---> (Could be more different values in the future)
For now the data are between Column(D:L), but for the futere there could be added more columns.. --> (Column(D) will always be first column of data)
Each columns between Column(D:L) has some data, which should match my criteria from the frontsheet ("sheet1").
If the cells.value = "Not calculated" then a can skip this criteria..
If 1 or more criteria are wrong then go to next row of data.
If all cells are correct or cells.value = "Not calculated" then i want to copy this data to my frontsheet ("sheet1").. --> Data can be copied Max 11 times

if a kind person wanna help and have questions please let me know. any help will be highly appriciated

 

[maabadi]

Please upload Example file & Desired Result with XL2BB Addin (Preferable) or Upload at free Hosting Site e.g. www.dropbox.com, GoogleDrive, OneDrive or ... and Insert link here.

 

[mkh12ab]

Please upload Example file & Desired Result with XL2BB Addin (Preferable) or Upload at free Hosting Site e.g. www.dropbox.com, GoogleDrive, OneDrive or ... and Insert link here.

hello maabadi

Thanks alot for explaining above will most likely be usefull for the future
i have found a solution (Might be a little messy my macro)
is it possible to remove/delete a question then no longer need help? not complite sure how this work?

once again thanks for your time and for the explanation above this will help me futurewise

 

[maabadi]

You're Welcome & Glad You can sort it.