Forum Discussion
Deleted
Jan 20, 2021Macro that concatenates two cells, references a Date and then copy pastes value into first
Would love some help writing this macro i tried attaching a file with more explanations within the file if it helps make it clearer. (in yellow highlights & red text) I have two sheets. One tit...
AnaBoyko
Copper Contributor
Deleted
I agree with Mr. mathetes it is not an easy job to create a macros like this. Try to create your report for one date with sufficient extra space and link the date of the report to a list of the dates. Then you can create much more easy macros, thal will change the date in the report, calculate and copy the result to a new sheet or book
Deleted
Jan 21, 2021thanks for the input AnaBoyko .
yeah i was thinking last night that i should probably take that route...simplify what i want the macro to do and then just try to evolve it.