Search results

Looks like it worked now

yes when I select my file it loads to 100% and completes - but does not show?

I keep uploading it but it wont appear???

Please can I get some help producing a report: I have an invoice and a credit note for flowers on two separate sheets. I want to create a pivot table that will be able to show me the total stems sold by variety. Ie. In my invoice page I would have: Date Quantity Variety 20.07.14...

Hi there, Can anyone tell me how to work out: $10 how to work out that you need 1x $10.00 note $12 how to work out that you need 1x$10.00 note and 1x$2.00 note in a spread sheet I have for workers pay, what is the easiest way to do this?

Just Rand and USD - it was getting so annoying looking for the Rand symbol as its used so much in my tables

Please can someone tell me how I can sort a currency symbol list so the main currencies I use are at the top of the list. I get tired of looking for them in the list. I usually use the accounting format.

Can someone help explain how to upload a file?

Thank you for your help, I dont know why the name wouldnt show up? I just re-did the pivot table and it showed up again? Alanna

Sorry its been a few weeks! I have had a look at this setting and it is checked on. Not sure what other setting might not be working. I have now discovered that some do work but most dont, its quite anoying as I have to keep typing the whole word in when I know I dont have to. I have...

Please can someone help me: when I refresh my data, some of the text does not show up, one in particular. I have created a worksheet with the data and the price list when I refresh the invoice (pivot table) one name in particular does not seem to want to show up, all others do? the data...

Hi there, What I mean is when you type in a word/name ie Alice and then you write it again a few times excel should know you are writing alice when you start typing a and then you dont have to type the rest in, it does it for you. One one of my documents its not doing this, and would be...

I use a lot of continous text in cells, what setting is there that tells excel to remember the text written for the next cell?

Thank you, thank you,im very pleased it worked!!! :)

Dibs that example is exactly how I want to use it, however I cant see your formula in the example you gave me, can you give me a formula to use? Alanna

Thanks Harry, I will try your formula. Narayan - the sencond option you were talking about having the flower type in one cell and the cms in another, exaclty how you have typed it in. I will have a price list with the variety type then the cms and then the price that relates to the cms. Then...

Can anyone help me? I need a formula for: Flower Type/Length/Price (next line-answer) Aster/60cm/......? Price List: Aster/60cm/$1.80 Aster/70cm/$2.00 How can I get a formula to find out the price when I enter the flower type and the lengh (there may be a few different lengths for...

Ok so sorry im very very new to Macros, I dont even know what they are? Also not sure how to post/attach anything

Thanks, no those links didnt help. Can you help me with the Macro option?

Hi there, I know its probaly a common question however I need help with formatting my pivot table. I have set up my lines/fills/font and accounting but when I refresh it dosnt stay. I have the Preserve cell formatting on update clicked on but it still changes. Please help - its for an...

Not sure how to add it?

Please can someone help me design my delivery note. I have the 1st page (tab) with a price list (I dont want to touch this)- the 2nd page (tab) I want to put in my stock and quantity- and have the price list automatically corespond. Then I want to have the 3rd page (tab) as a pivot table...