Hi all,
I have another issue with working with multiple worksheet when trying to copy data from specific column (formula) to another column and paste as values for multiple sheets.
The sheets layout are build the same way and the sheets name will be changed during the process which is why the macro should target the sheets as sheet number and not sheet name.
1) The Macro needs to perform this action for the yellow maked sheets
2) The macro needs to copy from the column F and paste to column E as values
3) The macro needs to copy the rows based on numbers in the K kolumn until the value 100 for example
Many thanks for the help in advance!
I have another issue with working with multiple worksheet when trying to copy data from specific column (formula) to another column and paste as values for multiple sheets.
The sheets layout are build the same way and the sheets name will be changed during the process which is why the macro should target the sheets as sheet number and not sheet name.
1) The Macro needs to perform this action for the yellow maked sheets
2) The macro needs to copy from the column F and paste to column E as values
3) The macro needs to copy the rows based on numbers in the K kolumn until the value 100 for example
Many thanks for the help in advance!
