Search results

I'm not sure the answer on this one. I think this feature is called "perspectives" though.

Meh. Yes, Google Docs, Open Office, Kingsoft's stuff, whatever all exist. But they're not excel. So yeah - need to make a little budget file or organize your CD collection? by all means one of those will be fine. But if you're a spreadsheet pro, you need excel.

You can: -Keep it in your PMB -Save it as an addin (I like this one better) If you need to share it, you can just share the addin or bake it into the workbook.

I had this happen to me when I was running Office from a vbox. For whatever reason, it just "went away" one day and now everything is fine:)

just fwiw, last time I got myself into something like this, it ended up swelling out of control. Excel kinda sucks for project management - which I guess I should have seen coming - but ya know....

also, nobody here is an excel professional either:)

how about a file?

Well here's 2 ways that come to mind: -Suck all of your data into an array, write records that aren't flagged as to delete into a new array, put the new array out into a new workbook. -Use access. The latter of which would take you about 5 minutes to set up....

How big are the two lists you have?

Ehhhh maybe not. If you're not counting actual values and instead are counting formatting instances an array is probably not going to work.

Maybe? This looks like something that could be achieved with arrays. I'd really need to understand your application though....

I'm having a bitch of a time opening your file and I'm not sure why. Try this - like I say: it's dead simple and I never get style points

it should be simple. something like this.... Sub test() Dim irow As Integer Dim obSheet As Worksheet Dim sName As String sName = [Name] Set obSheet = Sheets(sName) irow = obSheet.UsedRange.Rows.Count + 1

ehhhh.... Seems like you should be able to do it either in the half ass field & char10 & field & char10 (easy) or I guess you should try to manipulate the whole text thing in html? That sounds like a bitch....

I don't understand; the email comes up with body from cell e4. what's the problem

Errr....Ok so.... -What is it you're looking for in terms of the actual FC calculation? VBA can iterate any calculation you want, it's just a matter of scoping out something that's applicable to your business. -You said in your first post, that you're looking for forecast in monthly buckets...

.....seems to work just fine for me....

I don't follow? Are you trying to run multiple queries that are identical save for parameters?

one more question: why do you have 150 pivot tables in the same workbook?

I would try refreshing them individually. Depending on how if the pivot tables are spread across multiple worksheets, deepak's solutions should help.

How many records are we talking here?

arrays! dim sourcerange as range dim outrange as range dim sourcearray as variant set sourcerange = sheets("whatever").range("a1:f100") sourcearray = sourcerange set outrange = sheets("outputsheet").range("a1") outrange.resize(ubound(sourcearray,1),ubound(sourcearray,2)) = sourcearray

http://www.techrepublic.com/blog/10-things/10-ways-to-screw-up-your-vba-code/1968/

Don't use gotos. Put everything in a loop. This is just on the fly and it won't work, but you'll get the idea: sub populsatesomestuff() dim sometext1 as string dim sometext2 as string dim sometext3 as string dim somedate as date dim repeatvalue as integer dim dateholder as date for i = 1...

It's explained best here: http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm