Need to copy data from one worksheet to another based on Particular value in the Cell.I am attaching the format and how the copy should work.
I have three worksheets named Report,Posted and Pending
On the Report work sheet i will have two cells with values (Posted and Pending respectively).
The data from Posted worksheet has to get copied below the Posted Cell and Pending has to be pasted below the Pending Cell
The Cell numbers of posted and pending is dynamic and will vary from report to report
I am attaching the format of the report .It would be great if someone can provide me a vb code which does this.