Hey everyone,
Ok heres an easy question for you experts but im an excel noob so im needing some excel love basically i have 4 invoice's on 4 different sheets. One is in AUD and another in USD ect... I have them set up so any amounts entered on the first form automatically carries over to the other 3 forms and does a currency conversion. What im having problems with is , i want to be able to enter the products and descriptions (in the products and description fields) and have them automatically fill in the correct cells on the other invoice sheets. So basically all i am doing in filling in one invoice and the rest are just duplicates. Doing this with numbers was easy, but i can seem to do it with text
Please help
Ok heres an easy question for you experts but im an excel noob so im needing some excel love basically i have 4 invoice's on 4 different sheets. One is in AUD and another in USD ect... I have them set up so any amounts entered on the first form automatically carries over to the other 3 forms and does a currency conversion. What im having problems with is , i want to be able to enter the products and descriptions (in the products and description fields) and have them automatically fill in the correct cells on the other invoice sheets. So basically all i am doing in filling in one invoice and the rest are just duplicates. Doing this with numbers was easy, but i can seem to do it with text
Please help