Recorded macro not running correctly reasons?

Hi all,
I have recorded a macro that transfers back and forth between 2 books. It does a drag of formula on one sheet, a drag of formula on another, runs calculations then 3 copy and paste objects. It does this 13 times. When I record the macro it does correctly. When I run it though, I get different data. I can post the macro if needed, but was just looking for possible reasons as to why it's not running just as it's programmed to do. It's even going into other cells that was not recorded. Relative references is turned off. I've done it over and over so many times now and just tired of that. 2 days of wasted work. Has to be something simple.

Thank you so much!

Hi jolivanes and thank you!

There is two books. It's supposed to go to Pick sheet of one book, G34 and enter "=" then go to Header sheet and pick a cell then affirm.
From there it will calculate, then copy data from Pick sheet G36-G47 and paste into fillin of the book that has the macro, then copy and paste from B51-F51 of the Pick sheet and paste in the fillin book and do the same thing for B52-F52. It will then go to Draw Enter of the other book, drag down X-AB certain rows to 365 rows, go back to G34 enter "=" again and repeat the process 13 times. Finally re-filling Draw enter X-AB back.

Thank you for looking and responding. Here is the macro:

Well, it's saying I've got too many characters by over 11,000 and won't let me post the macro.

Re: certain way you have to post code on here.
If all else fails, read the forum rules. What you are referring to is under #2.
Just explain step by step what you want to do.
Re: It's supposed to go to Pick sheet of one book, G34 and enter "=" then go to Header sheet and pick a cell then affirm
The above might make sense to you but it does not mean anything to me.
"It's supposed to go". What is supposed to go? What is the "It's"?
Pick sheet I assume is a sheet named "Pick".
"Of one book" Which book?
"G34" is obviously a cell reference.
"enter "=" then go to Header sheet and pick a cell then affirm". Sounds like Range("G34") = Sheets("Header").Range(???????)
The "pick a cell" does not work in Excel. It needs a certain Range.
I am not picking on you but you have to know that you know what your books look like and what you want to achieve and we don't have a clue unless it is properly explained.

Originally Posted by Norie

To post code:

1 Paste the code into the post.

2 Select the code.

3 Click the # button.

Thanks Norie. I knew there was something I had to do but it's been so long. It's still saying it's too long anyway.
I may just need a different way to do what I need to.
I do appreciate it!

Originally Posted by jolivanes

Re: certain way you have to post code on here.
If all else fails, read the forum rules. What you are referring to is under #2.
Just explain step by step what you want to do.
Re: It's supposed to go to Pick sheet of one book, G34 and enter "=" then go to Header sheet and pick a cell then affirm
The above might make sense to you but it does not mean anything to me.
"It's supposed to go". What is supposed to go? What is the "It's"?
Pick sheet I assume is a sheet named "Pick".
"Of one book" Which book?
"G34" is obviously a cell reference.
"enter "=" then go to Header sheet and pick a cell then affirm". Sounds like Range("G34") = Sheets("Header").Range(???????)
The "pick a cell" does not work in Excel. It needs a certain Range.
I am not picking on you but you have to know that you know what your books look like and what you want to achieve and we don't have a clue unless it is properly explained.

Thank you jolivanes,
I know what you're saying and why. It's fine. I just can't get it down to the 15,000 character limit, which may be my whole problem with it working anyway. May just have to go a simpler route with all of it. I'll go another route with it and see if I can simplify it to make it work. Maybe set it up in smaller runs, then call each one as needed.

Thank you very much for all your help and replies!

Don't you hate it when it seems they're on your case without reason?
Well, read the rules again. Towards the end about Quoting.

Enough about that from my end.
Forget about the code and just explain what you need. We'll get there for/with you.
It might be easier if you do it, like you more or less said, do it in stages. So ask it in stages if that makes sense.
We'll eagerly await your questions.