Search results for query: *

Hi guys, I am a bit confused now, sorry. 1. The way my excel looks i cannot find the pivot table wizard in any menu-bar. I only found it by googeling and finding the key combination alt D P. It will not let me do that on the old pivot table though, so i can't go back to see how the source data...

Hi Gavona, Thanks for the help. My data that is beeing entered is in a "table" format and the data is being entered with the "form" function. Does this make it a dynamic range? Otherwise there are no formulas in there. I will do a trial with a sheet if the data isn't in a "table"format. Heiko

Hi guys, I'm stuck again. I have one workbook where the data gets entered as it becomes available. I have another workbook which is on my pc which has the pivot table in it which summarizes the data from workbook 1. It does not seem to update the pivot table when the other workbook is not...

thanks for all the help guys, got it to work. kind regards, Heiko

Hi skip, now i need help with pivot tables: I want to have my data in one workbook and the pivot table in another. Any ideas how that can work? Thanks, Heiko

Hi Skip, No, I didn't know about it but tried it out last night and i must say, what a powerful tool. had to change the layout of my data a bit but then it worked really well. Thanks again for the help. Kinf regards, Heiko

Help Please. I have a production sheet where the tanks get listed with the date they were produced and each tank gets a number. I want to copy the cells next to the latest date, ie the current stock to a different sheet. It must automatically look for the latest date, then copy the cells...