Copy and paste value & skip Blank to a date dependent destination using VBA

[kankuroo]

Hi Everyone,

I have limited experience with VBA, and barely any with writing my own codes. (specially with rows/columns and dates). So, At the moment I am stuck on something that sounds fairly simple, and that is to copy a column of daily figures in one tab and pasting it in to a collection of Month-To-Date figures on another tab. Therefore I need the list of daily figures to be pasted in the column under that matching date.

Where it gets more complicated is that I also need it to copy the list of 160 values with the occasional blanks between them, and "Paste Value" & "Skip Blanks" to the destination (which essentially depends on a date criteria) on a separate sheet.

I attached a simple example but I dont even know where to start with a code..

If anyone knows how to achieve this, or where I can get started I would really appreciate the help.

Cheers

 

[Luke M]

Hi kankuroo, and welcome to the forum!

Would you mind expanding your example with more columns, and/or show what you'd like the final output to look like? Given your setup, I think the easiest might be to actually have a macro (or manually) use a formula to bring over the data, but will need to see more.