I need to auto populate another sheet, when a button is clicked to do the following please
Main data is on a sheet called "Master"
Data needs to populate on sheet called "Priority"
If there is data on the "Master" sheet in column AC (from Row 3 downwards to row 500) I want the following to happen:
From Master Sheet to Priority Sheet
Column A (Master) to Column A (Priority)
Column - (Master) to Column B (Priority) - Leave Blank
Column B (Master) to Column C (Priority)
Column F (Master) to Column D (Priority)
Column D (Master) to Column E (Priority)
Column E (Master) to Column F (Priority)
Column C (Master) to Column G (Priority)
Column O (Master) to Column H (Priority)
Column P (Master) to Column I (Priority)
Column W (Master) to Column J (Priority)
Column - (Master) to Column K (Priority) - Leave Blank
Column X (Master) to Column L (Priority)
Column - (Master) to Column M (Priority) - Leave Blank
Column Y (Master) to Column N (Priority)
Column - (Master) to Column O (Priority) - Leave Blank
Column Z (Master) to Column P (Priority)
Column - (Master) to Column Q (Priority) - Leave Blank
Column AA (Master) to Column R (Priority)
Column - (Master) to Column S (Priority) - Leave Blank
Column AB (Master) to Column T (Priority)
Column - (Master) to Column U (Priority) - Leave Blank
Column AC (Master) to Column V (Priority)
Hope this makes sense!
Main data is on a sheet called "Master"
Data needs to populate on sheet called "Priority"
If there is data on the "Master" sheet in column AC (from Row 3 downwards to row 500) I want the following to happen:
From Master Sheet to Priority Sheet
Column A (Master) to Column A (Priority)
Column - (Master) to Column B (Priority) - Leave Blank
Column B (Master) to Column C (Priority)
Column F (Master) to Column D (Priority)
Column D (Master) to Column E (Priority)
Column E (Master) to Column F (Priority)
Column C (Master) to Column G (Priority)
Column O (Master) to Column H (Priority)
Column P (Master) to Column I (Priority)
Column W (Master) to Column J (Priority)
Column - (Master) to Column K (Priority) - Leave Blank
Column X (Master) to Column L (Priority)
Column - (Master) to Column M (Priority) - Leave Blank
Column Y (Master) to Column N (Priority)
Column - (Master) to Column O (Priority) - Leave Blank
Column Z (Master) to Column P (Priority)
Column - (Master) to Column Q (Priority) - Leave Blank
Column AA (Master) to Column R (Priority)
Column - (Master) to Column S (Priority) - Leave Blank
Column AB (Master) to Column T (Priority)
Column - (Master) to Column U (Priority) - Leave Blank
Column AC (Master) to Column V (Priority)
Hope this makes sense!