Excel - Subtotals format
Asked By Quimera
30-Jan-10 06:48 PM
I have a worksheet with a column for Name and a column for Amount. The
subtotal in the inserted subtotal line does not show the subtotal amount
in bold, though the subtotalled name is in bold.
Is there some way to show the subtotalled amount in bold as well?
Thanks for your help.
Worksheet
(1)
FIND
(1)
Database
(1)
Dios
(1)
Vaya
(1)
clr replied to Quimera
Only by hand,..... or by code, if that is a viable solution.
Vaya con Dios,
Chuck, CABGx3
Roger Govier replied to Quimera
Hi
Assuming your Amount is in column B.
Select the range of your data in column B>Format>Conditional
Formatting>Formula is> =FIND("Total",A2) >Format>Bold
This will also embolden your Grand Total row.
--
Regards
Roger Govier
__________ Information from ESET Smart Security, version of virus signature database 4821 (20100130) __________
The message was checked by ESET Smart Security.
http://www.eset.com
Macro to find specific row on database / worksheet Excel I don 't have any VBA knowdledge, therefore I'm using a simple macro somebody wrote to add a user form to my worksheet. The macro looks up the next empty row on a pre-defined worksheet and writes the user input into a pre-defined column of the empty row. It looks like this: 'find first empty row in database lRow = ws.Cells(Rows.Count, 1) _ .End(xlUp).Offset(1, 0).Row 'copy the data to the database With ws .Cells(lRow, 2).Value = Me.cboPeriod.Value Now I'd like to change
de Bruin, I've got code that copies data from a named range to a "database" worksheet. I want to loop through all named ranges (which represent a dynamic range in each worksheet) and copy them to the "database" worksheet. Here's what I've got: Sub Consolidate() Dim SourceRange As Range, DestRange As Range Dim DestSheet As Worksheet, Lr As Long Dim rName As Variant Dim i As Long With Application .ScreenUpdating = False Set SourceRange = Range(rName) 'Fill in the destination sheet and call the LastRow 'function to find the last row Set DestSheet = Sheets("Consolidated") Lr = LastRow(DestSheet) 'With the information from the method Range of object _Global failed. Excel Programming Discussions Range (1) Application (1) Sheets (1) Worksheet (1) Worksheets (1) Workbook (1) Excel (1) Names (1) It might be as simple as
Linking Worksheet to Database? Excel I know how to link an Access Database to a Spreadsheet, but how do you do the reverse? Thank you Excel Worksheet Discussions Excel (1) Database (1) RoadKill (1) Devenshire (1) Shane (1) In Access choose File, Get External Data, Link the data was in Excel and I want to create a new table in the database. But my data is already in a table in the database. So I want to do the opposite. Well in that case, choose Data, Import External Data, New Database Query, and find and select your database. Then proceed through the wizard. - - If this helps
values? Thank you my dear gurus. Sub Post() Dim iRow As Long Dim ws As Worksheet Set ws = Worksheets("Database") ' find first empty row in database 'iRow = ws.Cells(Rows.Count, 1) .End(xlUp).Offset(1, 0).Row iRow = ws.Cells end sub - - Thank you, Jennifer Excel Programming Discussions Worksheets (1) Rows.Count (1) XlPasteValues (1) Database (1) FilterDatabase (1) Jennifer (1) Greg (1) IRow (1) ws.Cells(iRow, 1).PasteSpecial Paste of using Offset. A tad simpler. Sub Post() Dim iRow As Long Dim ws As Worksheet Set ws = Worksheets("Database") iRow = ws.Cells(Rows.Count, 2).End(xlUp).Row + 1 ws.Cells(iRow, 1).Value values Thank you my dear gurus. Sub Post() Dim iRow As Long Dim ws As Worksheet Set ws = Worksheets(
Transfer data from one sheet to another Excel Hi I have a worksheet "current" with data entered in range D5 to N5 and empty worksheet "database". i have created button1 and would like to attach a macro to this button1 so that all the data D5 to N5 from worksheet "current" transfer to worksheet "database" A3 to K3 Any help with codes please cheers Excel Programming Discussions Sheets (1) Worksheet (1) Workbook (1) Macro (1) Database (1) LearnerI (1) Hi Learner Maybe you want this http: / / www.rondebruin.nl / copy1.htm