Required a code to copy data from a cell

[RN12345]

Ladies and Gentlemen,

Please help me to find solution for a requirement. It would be a great help if you all can help me to receive a VB code for the following requirement.

I am attaching a spreadsheet which have the following pages,

Page 1: Split Entry (Requires VB coding)
Page 2: Split Details (Manual entry sheet)

I have bulk payments which should be split and applied to different accounts. I will enter the IDs and payments in Page 2 (which have some formula's to calculate the amount) I will enter details in column F and Column G, rest all will be locked cells.

Once I complete my entries, I will move to Page 1 and click the "Apply Split pay" command button, then there should appear a pop up box or box with the details as drawn in the yellow box which have the split details. First ID and its $, when we press copy id#, the Id should be copied to the memory and can paste to somewhere, then we press copy $, the can be copied and paste to somewhere. When we copy the Id and dollar it should no longer be available in the popup box to copy again, because this will help in preventing posting to the same account twice. Once we complete with the first posting, there should have a button next and second ID with its dollar amount should appear, then the same process continues until we complete posting to all of the ID's mentioned in page 2. Once all Id's are completed, message should appear "Split completed". Simultaneously payment details should appear in the left chart with Sl#, ID# and $. Can someone help me to resolve this plss. The password for the file is aa
Thanks for the efforts..

[HaHoBe]

Hi, RN12345,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

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

Ciao,
Holger

[HaHoBe]

Hi, RN12345,

I looked at the workbook but Iīm afraid I canīt make any sense of the information inside the workbook. For me you would need to explain how the information will be entered into Sheet1, how the amount comes into that sheet and the split amount as well.

Ciao,
Holger

[RN12345]

Thanks for your reply..
What I am looking is for vb code which picks data from page 2 and displays it in a msg box in page 1. So that I can copy that and paste it to some other place. Atleast if this thing happen, it will be a great help. A code which picks data by row by row and once copy done and click next it picks data from next cell for copying

[HaHoBe]

Hi, RN12345,

now thatīs the problem: you want us to work a miracle but maybe donīt know what miracle we should let happen. What values and from which cells - thatīs what interesting as well as the relationschip between the amount handed over and the distribution. On the given sample it doesnīt make much sense to me (Iīm too much in the german bookkeeping system and am not seeing/getting the point there).

Ciao,
Holger

[RN12345]

Thanks again..sorry if my words are confusing..
If you read my first thread, I hve mentioned the details there, column F and G from where the values to be captured. Now from where there those values come into F and G. Those values will be in putting by me. Just a msg box which displays values one by one from those columns.

[HaHoBe]

Hi, RN12345,

thatīs exactrly the point: where do you get these values from? Your sample doesnīt show any information on that, your posts do not. And Iīm out of this for good and hope somebody else will understand the "magic" of never ending money in your sample: $40 are listed as income and you want to distribute $100.

Ciao,
Holger

[RN12345]

Hello Holger,

I guess the format which created the spreadsheet is confusing..I just deleted everything and kept the columns which required a VB coding. I will try to explain the scenario as simple as I can...
I will get a check of bulk amount which I have to distribute between different ID,s or accounts. Those accounts will be entered in column F (Sheet 2 ) manually and I will enter the amount in column G (Sheet 2) manually...then I will go to page 1 and press apply split button, I would like to get a msg box which displays the ID and amount entered in page 2. Eg: if there are 5 ID's, the msg box should appear 5 times with each ID and its $ amount. Wen I press first time the macro will display ID and amount in F6 and G6, when I press next it wil display ID and amount in F7 and G7, this will continue until the 5 ID completes. Can any one pls help me with this code??