Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...)

gentleranger82 said:So, here’s the vision for this Invoice setup: I want to type in a client's name and have the whole block—address, zip code, phone number, city—just pop right in there automatically. I also want the invoice number and today's date to auto-fill the second the data entry form opens up. Then, once I start punching in items, the unit price and the unit of measure should just show up on their own. I'll toss in the quantity, get my subtotal for that item, and then have the grand total waiting for me at the bottom of the form. Done.

Nicholas King said:Sub Macro1()

BrojListova = Application.Sheets.Count

For i = 1 To NumberOfSheets
select Sheets(i).Select
FirstRow = Range("$A:$A").End(xlUp).Row
LastRow = Range("$A:$A").End(xlDown).Row

Range("B" & FirstRow, "B" & LastRow).Select
select Selection.Value = "z"

Range("C" & FirstRow, "C" & LastRow).Select
select Selection.Value = ActiveSheet.Name

Range("D" & FirstRow, "D" & LastRow).Select
If (Month(Now) > 10) Then
Mjesec$ = "11" & (Month(Now()) - 1)
Else
mjesec $ = "110" & (Month(Date) - 1)
end if Selection
Value = ActiveSheet$

Next i

end Sub macro

The macro loops through every single worksheet. That’s where you can see exactly how to set up a loop.

Column A serves as the primary reference for determining the range where values will be entered. Just a heads-up—if you're working with headers, you'll need to adjust the expression for FirstRow accordingly.

It populates columns B, C, and D with the exact values you were looking for.

It’s entirely up to you what you want to enter as the month for January. And once we hit 2012—though I'm assuming this "11" actually refers to 2011—you can decide how to handle that too. 🙂)

Larry Peterson30 said:I was wondering if there's a way to automate this—basically, getting all the data copied over into one single shared spreadsheet.

James Rogers53 said:I've got an Excel file with over 80 sheets and I need to dump them all into one single sheet.
Is there any way to do this without just grinding through copy-paste?
Luckily, the number of columns is the same on all of them.

Nicholas King said:I mentioned this in my first reply too: just type your text into a TextBox (if you don't like the border, just set the TextBox to have no outline). Once you do that, you'll be able to group everything together.

Bradley Flores said:Hey, I'm using Word 2010—can anyone help me figure out how to make page 1 start on the fourth page? Thanks! 🙏

Bradley Flores said:Hey, I'm stuck using Word 2010... can someone help me figure out how to make page 1 start on what's currently my 4th page? Thanks 🙏

Rebecca Wright63 said:So, I'm sitting here trying to get this thing to work—just a simple request, really—but instead of actually starting where I need it to, the system just hands me this single "word" and calls it a day. It’s incredibly frustrating. I mean, I’m asking for a sequence, a beginning, something to actually build upon, and yet... it just stalls out right at the start. I guess I shouldn't be surprised, given how finicky these settings can be sometimes, but still—it's a bit much, isn't it?
Below, "word"

crimsonotter32 said:It looks like someone accidentally clicked something—I guess you could say they tripped over their own mouse—and now all of their toolbars have just vanished into thin air.

redstag82 said:The final result I need from my Query should look like this:


Does anyone have any ideas on how to fix this? If you need more details, just ask...

Thanks a lot!

Rebecca Wright63 said:I'm using Word 2007.
That checkbox is definitely checked on my end...

Rebecca Wright63 said:tonight
Can someone please help me out? So, I'm working in Word and whenever I type quotation marks, it keeps giving me "word" like this, but what I actually need is for them to look like
,,word"
How on earth do I fix that setting?
thanks