Messages - kalos [ switch to compact view ]

Pages: prev • 1 ... 21 22 23 24 25 [26] 27 28 29 30 31 ... 365 • next
126
Living Room / Is there any compact portable browser?
« on: February 25, 2019, 07:59 AM »
Hi!

Is there a compact portable browser?

I use Palemoon and its 160MB are too many for my space allowance.

Thanks!

127
Living Room / Re: Any VBA experts?
« on: February 24, 2019, 10:45 AM »
I have a sheet with lots of formulas and text called TEMPLATESHEET. This sheet is stored in a TEMPLATEWORKBOOK.

When I open any xls file, I want a macro that will insert to the active workbook, the TEMPLATESHEET.

However, the TEMPLATESHEET, has some formulas that refer to a sheet called REFERENCESHEET.

So, when the xls file I open has a sheet with the same name, REFERENCESHEET, I want the formulas for the TEMPLATESHEET to link to the REFERENCESHEET.

Would that be possible? I may have to search-and-replace the #REF of the TEMPLATESHEET to match the REFERENCESHEET, unless the TEMPLATESHEET will preserve the references and have them working.

I don't think there is more info than that available.

128
Living Room / Any VBA experts?
« on: February 22, 2019, 01:25 PM »
Hello

I have an Excel sheet with formulas and text in hundreds of cells.

Is there a way to click a button and add this sheet to the active workbook, in any xls file I have opened?

Some formulas refer to a sheet with a specific name, so when this sheet is present in the workbook, the formulas must work.

Thanks!

129
Living Room / Re: How to automatically generate reports based on xls files?
« on: February 19, 2019, 08:32 AM »
I cannot find how to do this:

Range("A1").Formula = "This is some text ",TEXT((COUNTIFS(UDE!$AC:$AC,"Low",UDE!$G:$G,"High")+COUNTIFS(UDE!$AC:$AC,"MLD",UDE!$G:$G,"High"))/COUNTIF(UDE!$G:$G,"High"),"00%"))"
Range("A1").Formula = "=CONCATENATE("This is some text ",TEXT((COUNTIFS(UDE!$AC:$AC,"Low",UDE!$G:$G,"High")+COUNTIFS(UDE!$AC:$AC,"MLD",UDE!$G:$G,"High"))/COUNTIF(UDE!$G:$G,"High"),"00%"))"

Neither works, any idea?

130
Living Room / Re: How to automatically generate reports based on xls files?
« on: February 19, 2019, 03:46 AM »
Thanks,
So far I plan to write a macro in excel that will create a new sheet and populate some cells with the formulas that calculate the numbers I want.
Then, I suppose I can use Mail Merge to grab the numbers from these cells and populate the report.

Would that be the best approach?

Or is it possible to do easily everything with Powershell or Word or Excel only?

Pages: prev • 1 ... 21 22 23 24 25 [26] 27 28 29 30 31 ... 365 • next
Go to full version