Hi Guys,
Can't seem to use source data properly.
Simply put, I copy and paste an matrix of data into an area which already has a pivottable associated with it. If I just do a PT refreshtable then I might miss some new data that is now outside the range (on rows only) so I thought this might...
Hi Guys,
Not sure if this is the right place to post this so apologies if it is not!
On some websites I get a popup window saying a runtime error has occurred-do you want to debug? This actually stops me clicking on links.
Using XP Home.
How can I stop this happening?
Thanks
Ig
Hi,
Got a problem with a For Each loop
This is my code:
Sub D()
Worksheets("DG").Select
For Each cell In Worksheets("CDS").Range(Cells(1, 1), Cells(1, 1).End(xlDown)).Cells
Unfortunately it bombs out at the For Each line. I have tried different alternatives and it...
Skip,
Like I said, it only gets deleted because I copy over new data, consolidate and then put it back.
DPlank,
Ideally I want to avoid that because I have several that need replacing and it loops hundreds of times.
Will turning off automatic calculation when I'm doing the jiggery-pokery...
Hi,
I have a SUMIF formula in a worksheet1 that references a worksheet2. I then run a macro that moves and deletes all sorts of columns but eventually leaves it in exactly the same format it started in albeit with different data. However, the SUMIF formula in ws1 now has #REF errors where it is...
Hi,
I want to use a generic user form called from several menu items. Basically it allows the user to chose whether the macro should be run on one dataset on another.
My question is, obviousy depending which macro called the userform, different follow on calls will be required so - how can I...
I know which is why I am baffled! Here is the part of code not working:
On Error GoTo jump
ActiveSheet.PivotTables("PT).PivotSelect _
"I[ALL]", xlDataAndLabel
Selection.Copy Destination:=Workbooks("x.xls").Sheets("DS").Range("R1")
jump...
Hi,
I've run into a problem with my error handling. I didn;t realise that using the On Error Goto line statement actually instigated an error handling routine that rendered future error trapping useless. I was using it as a way to jump say three lines of code and carry on execution
eg
On...
Thanks Skip but not realy what I need. I fear you may have answered my question though in saying you can't filter a pivot. I need to base the exclusion on the sum of the data itmes to know whether two items have cancelled each other out (ie sum = 0). :(
Hi,
Can you hide data items on a pivot table that meet a certain criteria? I know about hiding PivotItems but I am looking to hide all entries that have a Sum of Value = 0.
Any way to do this?
TIA.
Ig
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.