Pasting value for a Row if coloumn A has a certain value

[kohno71]

Hey all!

I would like some help regarding a certain task I want to automate. I understand this task will require vba macros. Essentially, the idea is if coloumn A has "#", that row will be copy pasted. Lets say cell A3 has a "#", therefore cell b3:z3 will be pasted value.

I dont really have much knowledge in vba so with what I understood about it, ive been able to return the first cell with "#" in vba, and then using a count function to return the number of "#" in vba ( rest assured that there wont be any gaps between the hashtags). My approach was that with the first output which gives a result of $A$3 and second outputs which result in a count of 5, I could combine the two to result in a range of A3:A8. And then use that output to select range B3:Z8 and paste that as value. But other than the first and second output, I couldn't figure out to do the rest. If you guys have a more efficient method, will be much appreciated.

Please also note that .Cells(.Rows.Count, "A").End(xlUp).Row wont really work. The output of "#" in coloumn a will be result of a formula, which will with result in # or "". As I understand, that method selects even the null string outputs.

[alansidman]

Please read the yellow banner at the top of this page on how to attach a file.

[kohno71]

I figured it out, heres the code for people who have the same problem~

Please Login or Register  to view this content.