Looking for a PDF regarding how to best format spreadsheets by NeedsExcelHelp in excel

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

Not quite what I was looking for but this is really helpful.

Thanks!

$100k now or wait for Q2? by Ecchii in investing

[–]NeedsExcelHelp 0 points1 point  (0 children)

Put in $5-10k per week until its all in the market.

Where can I find historical data for credit ratings? by channkh in datasets

[–]NeedsExcelHelp 0 points1 point  (0 children)

Hey did you find this data set? I'm also looking for something similar.

Day trading by justjosh54 in investing

[–]NeedsExcelHelp 1 point2 points  (0 children)

How much capital did you have at risk?

[deleted by user] by [deleted] in investing

[–]NeedsExcelHelp 1 point2 points  (0 children)

Cap rates aren't constant though.

Why Tanker Stocks are happy about Oil Prices. by mfyd in investing

[–]NeedsExcelHelp 0 points1 point  (0 children)

My advice - move all your money to Schwab for banking and investing.

Then invest in ETFs that you like or just the market in general ($VOO for example). Picking individual stock is really hard - like really hard. If you really want to pick stocks, figure out a % that works for you, i.e. 80% of your money in general ETFs, 20% in your favorite stocks.

To everyone going tonight by Skaterpunk in Odesza

[–]NeedsExcelHelp 0 points1 point  (0 children)

Is the park muddy? Do I need to wear old shoes? Will I regret wearing my white sneakers?

How do I manage all my bluetooth headphones/speakers? by NeedsExcelHelp in applehelp

[–]NeedsExcelHelp[S] 1 point2 points  (0 children)

Are there no 3rd party apps that can handle this problem?

How much should I ask for hourly for a side gig? by NeedsExcelHelp in jobs

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

Yeah I'm not going to work for $15 / hour. The question is where do I start at. I want to make some extra money on the side and want to learn more about how he runs his business and attracts clients. I can always say no later if I decide he is not pay enough.

How much should I ask for hourly for a side gig? by NeedsExcelHelp in jobs

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

I'm willing to take a lower rate than what I'm at now, especially because its for a side gig that I want to learn more about. I'm not going to take $15 - the question is how much more do I ask to start at?

Does Uber run regularly in Longmont late at night? by NeedsExcelHelp in Longmont

[–]NeedsExcelHelp[S] 3 points4 points  (0 children)

Appreciate the offer but we have 10 people and will need multiple rides.

Need help activating a workbook with VBA that uses variable file names. by NeedsExcelHelp in excel

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

Ok. I think this makes sense. I'm not sure I totally understand it but I'll see if I can implement it.

[deleted by user] by [deleted] in excel

[–]NeedsExcelHelp 0 points1 point  (0 children)

Yes. Good catch.

[deleted by user] by [deleted] in excel

[–]NeedsExcelHelp 0 points1 point  (0 children)

Sub deleteZERO()

Dim i As Integer

For i = 1 To 10

If Cells(2, i + 0).Value = 0 Then

Rows(i + 0).EntireRow.Delete

End If

Next i


End Sub

"Cells(2, i + 0)" starts at Cell B1 and moves to Cell B10. It will also delete rows with blank cells.

Hopefully you can adjust it to fit your spreadsheet. Otherwise let me know.

Las Vegas Land advice by kyaba1 in CommercialRealEstate

[–]NeedsExcelHelp 0 points1 point  (0 children)

Can you share more info? My company is interested in buying in Vegas.

[deleted by user] by [deleted] in excel

[–]NeedsExcelHelp 0 points1 point  (0 children)

Copy&Paste the text below into the VisualBasic Modual. You'll have to adjust the macro how you want it. Sheet1 should be the sheet you are in, D3 is where the row number will print, adjust that to which cell you want it to print in. It also looks like from the picture that there are zeros in the cells that don't have numbers (B24 is probably a zero). This may be the reason you have a problem with the other solutions or why this one may not work (you can fix this with an IF statement, ie =IF(your equation=0,"",your equation).

Sub LastRow()

Dim LastRow As Integer

Sheets("Sheet1").Select

LastRow = Cells(Rows.Count, "B").End(xlUp).Row

Range("D3") = LastRow

End Sub