Macro Help with Pasting Formula Values

Perfect. Thank you very much for the help.

I was wondering if you could explain your code a little to me if you would. Are you making a data array of numbers?

I guess I have one last step. I got the suggestions here implemented and it's working great. I appreciate the documentation as well. This part I wasn't told but I can't figure out as well. I worked on it most the day friday. I need to run the macro and then the remaining amounts left in column E should also go to the side where the account# goes to Credit and the Amount goes to before and after amount. I tried to use the coe I was helped with but had some trouble and I don't want to ruin what has been done so far.

Hopefully this makes sense. I attached the most updated version I have that I am working on I filled in the data so you can go to the bookstore tab and click run macro. This does the subtraction code that you wrote. It will run first then after it runs I need it to move the remaining values from column F to column M and the associated Account# with column F would go in Column J under credit.

After that it needs to move any cell in column F that still has a value to the side. There's no subtracting or any more math involved. Just find the cells in column F and move them to column M and move the associated account# with the amount from column E to column J.

After that I click make Bookstore JE and it goes to a tab where it pulls in the information from the bookstore tab so I can eventually create a text file. I need to have description filled in but I think I can get that part. Also the reference numbers will fill in if you put in a reference # in cell B16.

I hope this makes sense.

Yes that works perfect. Thanks. You've been the most amazing help.

I do have one other question. Why won't access let you begin numbers with 0? It always gives an error and I have to ignore error. Is there a way around this so you can start a number with 0?

Thanks for the advice I'll have to make the format then. I'll mark the thread as solved.

I am back with one more issue I am needing help with. I finally got it tested out today. I've worked quite a bit on it getting it to reset everything and create a text file. It works great.

The issue I am needing help with now is dealing with negative numbers. A negative number in Column C will just be added to an amount in column F and documented in columns G:M much like when subtracting. The only difference is with the negative numbers the account numbers will be switched. Also a negative amount in column F will be moved to column G,J,M much like the other remaining amounts. The other tricky part about negative numbers is the account numbers will be reversed where the debit# will go in the credit column and vice versa.

I attached my example and any help will be appreciated.

Thanks.

anyone have any ideas on this?

Thanks.

anyone have any suggestions?

Thanks.

Yes give me about 15-20 minutes and I'll it up. Thanks.

Alright I made up some examples Before is what I get now with some explanations in it then the example file shows what it should be getting. I hope this helps I really appreciate the help on this.

Originally Posted by tigeravatar

Unfortunately I don't have time to go into this very much today, but I'll definitely have a go at it tomorrow, sorry for the delay. Work has been crazy ><

I know how that is I just appreciate all your effort helping me out with this. I've worked on it for about 2 weeks now it's 1 part to generate a text file while I have almost finished the other part. I look forward to seeing what you come up with. Thanks.

Any ideas on this?