Hi there and welcome
I can do this for you.
Can you explain what exactly is needed? When you say workbooks, these are seperate files or sheets?
And is it the entire sheet you need to copy in or a range?
Please let me know
ok, so G and H from the commissions goes into B and C of the QB import sheet? As the sheets have different data
Can you tell me which Column you mean in the import file with this
The $$ in the Expense column need to go on the import sheet on a line that says "Prepaid Commissions:Prepaid Sales Rep Expense Reimb"
As I do not see that column
ok no problem
ok, so your saying Volume H & E & F all go into Column F in the QB import file?
Can I ask please as we initially discussed, give me one clear list of which cells in the commission sheet goes into the QB import sheet please.
Just as Comission H&E&F to QB Import H as totaled as example else the explanation is too confusing sorry,.
ok, maybe you need to take a minute and explain it here? As now your saying B which is a date to G which is a currency amount.
Please, I just want you to tell me
Which cells from Comission go to the import sheet.
Don't over complicate it.... just line by line for each one
Commission B to Import G
Comission D + G to Import H
Just like that...
ok, thats much cleaner
So I am adding Commission E,F,G,H togther and putting the total in H right?
ok, so you mean
If Commission E has a value then E else F and put in Import H and in Import F auto populate with "Prepaid Commissions".
If Commission H as an entry, then Import H and Import F auto populate with "prepaid commissions:Prepaid Sales Rep Expense Reimb"
Is this correct and everything?
ok, please explain exactly like we just did, all other rules, clearly and per line for each rule please
commission J, K, L, M, N are all blank in the files you gave me.
does every sheet begin on row 6?
ok, last point then is how will you want it to choose the files to import? you run the macro, select the file and it imports, then run it again and it imports the next one and you repeat till its complete?
ok... what do you mean with the last point?
ok, thats a new requirement.
I am going to opt out of this question, it may be better suited to another expert to go through and finalize these requirements and gather any additional ones remaining.
You do not need to do anything, you will be notified when an expert takes over.
i think I was working with you on a similar question before. You decided not to continue at that time
Looks like you want to do this again.
Can I assume that the files attached are the latest.