copy cells to corresponding sheets

Hi,

Someone help me! How to copy cells date column and narration column (H column Values) and debit credit values to corrosponding sheets.

While you have a nice looking spreadsheet, I am not a mind reader as to what you require. Please, in simple language explain what you want to happen.

Sir, I highlight cells that will be copy to corresponding sheets.

Suppose
First word is Rent expense now code will work and copy

a) column DATE (Value 2)
b) column DEBIT (value 100) and column CREDIT (value 0)
c) Description Column (value Paid July Rent)

to paste Rent expense sheet.

Next word is Cash now

a) column DATE (Value 2)
b) column DEBIT (value 0) and column CREDIT (value 100)
c) Description Column (value Paid July Rent)

to paste Cash sheet.

Next word is again Cash now

a) column DATE (Value 3)
b) column DEBIT (value 6000) and column CREDIT (value 0)
c) Description Column (value Received Cash on account)

to paste Cash sheet.

Next word is Accounts Receivable now

a) column DATE (Value 3)
b) column DEBIT (value 0) and column CREDIT (value 6000)
c) Description Column (value Received Cash on account)

to paste Accounts Receivable sheet.

Hi internet_imran

Would this exercise be a Classroom Assignment? If so, we cannot provide you with a solution, only direction.

Let us know how we should proceed...

Thanks Mr. John

This is not a classroom assignment, actually this is my office work task, That I have already completed partially.
but this is not perfect code. Please look this code...

The following code worked only on the word of Cash

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Hi internet_imran

Try this Code in the attached...Ctrl + x will fire the Code.

Please note, I've modified Sheet database to eliminate merged cells in Columns("F:H").

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Hi internet_imran

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

Dear sir

I marked this thread as solved but where is star icon at the lower left of my post, SORRY I could not find this.

Thanks

Imran

Originally Posted by internet_imran

...
I marked this thread as solved but where is star icon at the lower left of my post, SORRY I could not find this.

Try this..........
Rep.JPG

( you can write a messsage in the small Box, such as " Thank you Mr Jaslake .. Good wonk "

Edit
P.s. You will need to be logged in to see the Star, ( Just as you would have needed to have be logged in to mark the Thread as solved )