Macro pasting Data from one sheet to Another

[DPD]

Hello,

Im trying to pull data from one sheet and paste to a data sheet, the macros Im currently using are pulling the spaces between the cells Im gathering the data from. Data Sheet 3 is my ideal version of how I would like the data to be pulled from sheet Goal. My goal is to populate the sheet Dashboard with the data collected from the data sheet. Any tips or help would be greatly appreciated.

 

[Nebu]

Hi:

Find the attached, click on the run button on the goal tab the data will be populated on your current data sheet.

Thanks

 

[DPD]

Thank you, but I only need the current data from the goal sheet looks like the macro is keeping the old data. Anyway to separate the sections like on sheet Data Sheet 3?

 

[Nebu]

Hi:

I have coded another macro press the run button in your data sheet 3 . I have assumed your pending will be ongoing and have coded the data. I am not sure about how you want to capture the data for withdrawal. You can tweak the macro as per your need.

Thanks

 

[DPD]

Thank you again worked 90% to what I need, just need to remove the duplicate entries and keep the current data, late here will work on it tomorrow. Much appreciated.