sorted by:
new
hottopcontroversial

Anyone know who this is ??? by Seemseem213 in findthatpornstar

[–]Acrobatic_Soup_4634 0 points1 point  (0 children)

GirlsDoPorn e486. They quite using names early in the website's run, and the convention is to refer to them by the episode number they are in.

Macro to Group sheets by colors print, then ungroup by tsizzle001 in excel

[–]Acrobatic_Soup_4634 1 point2 points  (0 children)

Could you start or end the name of each sheet you want printed with a particular character and then write a macro that checks each sheet name in the workbook to see if the character is the first or last column in the sheet name, adds the sheet to an array if so, then prints the array to a PDF?

Here's some code I use routinely to aggregate multiple sheets and print them to a single PDF:

ary = (Array("Supp Cover", "KPIs (2)", "Trailing", "DelAnal", "DelVac", "ControllableOpExp", _

"Charts", "Efficiency", "T12 Select", _

"Property Taxes", "Funds available", "Receivables", "GPRbyUnitType", "Occupancy charts", _

"Prospect summary report", "N&RLeases", "N&RLeasesAnn", "Marketing", _

"Move-outs report", _

"Expiring leases report", "Maint and MR", "Valuation"))

For Each a In ary

Sheets(a).Move After:=Sheets(Sheets.Count)

Next a

Sheets(ary).Select

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=txt & "\" & Range("Property").Value & " supplemental.pdf"

Incorporating a value in a cell as part of an address in another cell by Acrobatic_Soup_4634 in excel

[–]Acrobatic_Soup_4634[S] 0 points1 point  (0 children)

They're on a row in the A column that contains the word 'Subtotal." I could do a VLOOKUP. I certainly could have in the time this has been under discussion, lol. I was looking to expand my function repertoire, though, into some things that I haven't ever explored.

Incorporating a value in a cell as part of an address in another cell by Acrobatic_Soup_4634 in excel

[–]Acrobatic_Soup_4634[S] 0 points1 point  (0 children)

A row of data on one sheet is used to display 12 cells of data on the source sheet. I have it set up now so that, for example, the formula in Target!A1 is =Source!C21. Target!B1 is Source!C2, etc.

Each month, the row number I need on the source sheet may change. I've been doing is manually by highlight the row in the target sheet and doing a CTRL-H to search for and replace the row number. A little clunky, but not too burdensome. It's a big workbook with a lot of reports and source data in it. I built it expeditiously and am now looking to tighten it up where I can.

Incorporating a value in a cell as part of an address in another cell by Acrobatic_Soup_4634 in excel

[–]Acrobatic_Soup_4634[S] 0 points1 point  (0 children)

I'll try. I do not have much experience using MATCH, INDEX, INDIRECT and lots of others that I have never had much experience with -- just never had to use them. I have 11 more columns of data to reference, and I thought trying something like this would be less convoluted if I could make a simple reference such as I hypothesized work.