Luis Diaz
asked on
VBA: copy range dynamically based on config sheet v3
Hello Experts,
I have the excellent procedure which allows me to copy and paste dynamically based on a config sheet reported at:
I would like to add additional requirement:
In the same procedure, I would like to fill default values reported in Config Sheet.
Example: in line 4 I report the required values:
-DestinationSheet: Sheet concerned by the fill action
-DestinationHeaderRange: field in which should be filled the default value.
-DestinationHeaderRow: first row concerned by filled (as it is in the existing procedure)
-DefValue: reference value concerned by the filled action
I added a Boolean = 1 to copy-paste in order to apply the procedure as it is and =2 in order to apply the new loop concerning by the filled action.
Concerning the verification of new procedure.
If Destination sheet, Destination field doesn’t exist skip line as it is done for the existing procedure.
If you have question, please contact me.
Regards,
CopyPasteRangeDynamically_v3.xlsm
I have the excellent procedure which allows me to copy and paste dynamically based on a config sheet reported at:
I would like to add additional requirement:
In the same procedure, I would like to fill default values reported in Config Sheet.
Example: in line 4 I report the required values:
-DestinationSheet: Sheet concerned by the fill action
-DestinationHeaderRange: field in which should be filled the default value.
-DestinationHeaderRow: first row concerned by filled (as it is in the existing procedure)
-DefValue: reference value concerned by the filled action
I added a Boolean = 1 to copy-paste in order to apply the procedure as it is and =2 in order to apply the new loop concerning by the filled action.
Concerning the verification of new procedure.
If Destination sheet, Destination field doesn’t exist skip line as it is done for the existing procedure.
If you have question, please contact me.
Regards,
CopyPasteRangeDynamically_v3.xlsm
ASKER
Hello GowFlow,
Noted. Please find bellow revised requirement.
I would like to fill values based on information in a config sheet which have the following attributes to report
-DestinationSheet: Sheet in which is located the Range concerned by the values to filled automatically
-DestinationRange: Range in which will be fill the reference value
-DefValue: reference value which should be filled in Destination Range.
In my previous comment I attached xlsm file which have an example of what I am looking for
ConfigSheet
Result
The idea is to keep the existing version and add a Boolean reported in column G if equal to 2 apply the new procedure if equal to 1 apply the existing procedure.
If it is not clear please contact me.
Thank you very much for your help.
Noted. Please find bellow revised requirement.
I would like to fill values based on information in a config sheet which have the following attributes to report
-DestinationSheet: Sheet in which is located the Range concerned by the values to filled automatically
-DestinationRange: Range in which will be fill the reference value
-DefValue: reference value which should be filled in Destination Range.
In my previous comment I attached xlsm file which have an example of what I am looking for
ConfigSheet
Result
The idea is to keep the existing version and add a Boolean reported in column G if equal to 2 apply the new procedure if equal to 1 apply the existing procedure.
If it is not clear please contact me.
Thank you very much for your help.
ok will look into this during the course of the day and if any question will let you know.
gowflow
gowflow
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much! Unable to test it now I will test it tomorrow.
ASKER
I tested the proposal and it works! Thank you again for your help.
If you can explain in few words in 'English' simply what you are trying to achieve then we can move to the technical part and understand what you want.
gowflow