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

mkh12ab

New Member
Joined
Apr 9, 2021
Messages
15
Office Version
  1. 2019
Platform
  1. Windows
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 :)
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

mkh12ab

New Member
Joined
Apr 9, 2021
Messages
15
Office Version
  1. 2019
Platform
  1. Windows
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

Well-known Member
Joined
Oct 22, 2012
Messages
2,311
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
You're Welcome & Glad You can sort it.
 

Forum statistics

Threads
1,141,051
Messages
5,703,957
Members
421,321
Latest member
blusky4

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top