Posts by Claire

Re: Pivot Table Refresh

Hi Richard,
the pivot table gets its data from a range that is not in the pivot table work book but work book C.

Its basically a time sheet. Work book C has a lit of jobs worked on on different days and the time worked on the jobs.

The pivot table then collates this data to add up the times for each job.

Work sheet B then takes the data from the pivot table and works out a fee for each job.

Work sheet B looks at numerous pivot tables from numerous employees to get the total time worked on that job so it can be very time consuming to open up each pivot table and refresh it so that work sheet B can et the current times!

I have a pivot table in spreadsheet A.

I have some formulas in another spreadsheet B.

The formulas look up data in the pivot table in A and use that data in B to return and answer.

Is there a way to refresh the pivot table in A from B without having to open A and refresh the table?

Hope that makes sense.

Cheers

Re: Combo box linked to cell

Thanks very much, thats exactly what i was after.

Re: Combo box linked to cell

The combo box list will have say 5 categories in it and will run down say column E for 50 rows, maybe more, so there will be 50 combo boxes. There will be an item in row C in the 50 rows. The items in row C needs to be categorised into one of the 5 categories in the combo box list and this will appear into column D next to it. The idea is to complete 1 combo box and copy it to the other 50 rows without having to change each one.

Re: Combo box linked to cell

Well the one i'm looking at is a control combo box.

I can set it to show the data in a fixed cell but when i copy it to another cell it still links to the same cell, i want it to link to another cell without having to go into it and change the reference!

Hi,
is it possible to link a combo box to the cell below the combobox so that if you move or copy the combo box to a new cell it will link to the cell it is above.

Or as an alternative could it be linked to the cell to its imediate left?

Any help would be appreciated.

Re: Return The Value In The Last Filled Cell

Thanks very much

Hi,
i'm looking for a formula that will return the last value in a row of values, such that this would be the current value for another formula.

Any help would be apprecited.

Cheers

Re: zooming

Well i have 4 buttons set up which will zoom to different areas on a sheet. When i zoom to the first area by pressing any of the buttons it works fine. When i then press any of the other buttons to zoom to another of the areas it centres on the upper left of the zoom area rather than filling the page. which means that half of the area i want to see is off the page.
Its not easy to explain without seeing it.

i am trying to set up a user toolbar button and a macro to be able to zoom to a set certain area on a sheet such as the range AB1:AB25 which will be available in all worksheets i open.
i have the following so far but it doesn't seem to work every time.

Range("A1:AM25").Select
ActiveWindow.Zoom = True
Range("A1").Select

Any help would be appraciated.

Cheers.