robkrouse
asked on
Problem with Excel Macros and Ipad2 using quickoffice pro hd
last night one of the gents on here helped me with a couple of formulas to enable me to pull data from one worksheet and populate a cell on a SUMMARY sheet, if it met certain conditions.
It worked great in Excel on my laptop, but when i tried to open it on my IPAD, it wouldn't work, because no programs support Macros and the ability to edit.
I was wondering if someone could help me take the macros that this gent put together and break them down to so that i can use this workbook on ipad.
I have attached the file in question.
the areas we worked on were Monthly, weekly and daily $sales and %to goal on the SUMMARY worksheet
Also, he added additional formulas at the bottom of each monthly worksheet and added a separate worksheet titled Nomenclature.
Thanks in advance for your help.
It worked great in Excel on my laptop, but when i tried to open it on my IPAD, it wouldn't work, because no programs support Macros and the ability to edit.
I was wondering if someone could help me take the macros that this gent put together and break them down to so that i can use this workbook on ipad.
I have attached the file in question.
the areas we worked on were Monthly, weekly and daily $sales and %to goal on the SUMMARY worksheet
Also, he added additional formulas at the bottom of each monthly worksheet and added a separate worksheet titled Nomenclature.
Thanks in advance for your help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It works with the file posted on your previous question.
Can you post your file where it does not work?
Can you post your file where it does not work?
ASKER
i saved a few different copies because of all the back and forth to my ipad. we'll stick with the one you have.
Do you mind helping me out with a couple of other questions? Or should i post them separately on the forum?
Do you mind helping me out with a couple of other questions? Or should i post them separately on the forum?
ASKER
actually would you mind sending that back to me, cause when i put in the formulas, it's not working for me on the copy i sent you. curious to see if it's something wrong with excel on my end.
ASKER
ok, i had just put the weekly equation into each separate worksheet.
quick question though. when i put it into each separate work sheet, it's populating at 500, so with =SUM(Start:End!C33) it's bringing back a total of 6000 (12months*500) which it only needs to show the 500 for the current month.
do i need to add a IF function to the weekly to make that happen?
quick question though. when i put it into each separate work sheet, it's populating at 500, so with =SUM(Start:End!C33) it's bringing back a total of 6000 (12months*500) which it only needs to show the 500 for the current month.
do i need to add a IF function to the weekly to make that happen?
I do not understand. The formula is for the summary sheet. Why do you want to put it in each separate worksheet?
ASKER
it's the solution that DLM came up with. i didn't realize that your solution took care of everything from one spot. it's more complex with code, but much cleaner in actual implementation.
Does that solve your question or are you looking for more?
ASKER
absolutely. i appreciate all the help. i'll close this one out and, most probably, post another one later on.
Thanks again.
Thanks again.
ASKER
I'm still getting a value error on the Summary page though for dollar amount, amount to reach and % to goal. why would that be? i tried different formatting but it doesn't work. any ideas?