Create A Help Section In A Workbook
Aug 5, 2003I want to include a help section in a workbook I created. I need something more than just a MsgBox ;-)
I'd like it to be like the windows' help that you have everywhere.
ADVERTISEMENT
Copying A Section Of Another Workbook
May 26, 2006I am creating a spreadsheet that takes data from the previous week's spreadsheet - it's a weekly report. Using vba how can I access and copy a specific range of data from one worksheet on the previous week's workbook to a range in the new week's workbook. The data in the previous week's workbook is formulas, and I'm not sure how it could affect it, but I only need the values calculated and not the formulas to be transferred. I would also prefer it if the other workbook did not open in excel, so that it happens without any changes on the screen.
View 6 Replies View RelatedMacro: Section And Closed/fixed Section
May 25, 2007I'm trying to create a macro to help me with a running issues list. I what to be able to have an issues column and a fix coulumn. Then I'll have an open issues section and closed/fixed issues section. all issues that do not have any Information and date in the fix colum will stay in the open section unitl the fix is entered and then when I run my macro it will move any open issues that have data in the fixed column to the closed section)
View 2 Replies View RelatedPopulate Section With Information On Top Row Of Section
Apr 2, 2014Refer to the "Example" file I have uploaded. Basically I want to turn table on the left to something similar to the table on the right by adding an additional column to put in card number related to the transaction in each row, so I have information of the transaction and its corresponding card number in the same row.
Example.xlsx‎
Checkbox In One Section Triggers NA In Other Section?
Jun 3, 2014 I have a checklist that I need to have do some different things.
I have two "sections" - not really sections but paragraphs so to speak. On each first line I have a checkbox. Now if the user checks "section" 1, I need the checkbox to change to NA for the "section" 2 first line.
Delete Sheets And Create New Workbook In Shared Workbook
Jun 2, 2014I wrote a code in unshared workbook and it works fine. But when i make it shared i get Run-time error '1004' Delete method of worksheet class failed.
The Deleting of worksheet only occurs once (when the new wb is created) so is there i can unshare and share it back when the process is complete?
Create New Workbook With Separate Sheets From Data In Another Workbook
Jul 16, 2012I have been tasked with creating a macro which creates a new workbook wherein each sheet contains the information for one site from the active sheet. The active sheet already has the values sorted by the site such that all information needing to be copied from the active sheet into the new workbook is together.
I.E.
ATL
ATL
ATL
ATL
CEN
CEN
JCK
JCK
etc.
There are 8 different sites on the active sheet: ATL, CEN, DAL, HAR, JAS, JCK, VIS, NOV
The macro needs to find the range for all of the data of each site and copy/paste that data into a new workbook such that ATL would have its own sheet, CEN would have its own sheet, and so on. The data ranges from A:R.
So, for example, the macro would find that the last row with ATL in the "B" column is 6095 and would then copy A2:R6095 and insert that data into the new workbook under Sheet 1.
I had some code that I had adapted to select the range for each of them, but the code loops through the entire sheet (which is 44,307 rows long) for each site making it a quite clunky and very slow step in an even longer macro. Since the data is already sorted, I know there must be a way to have the macro stop searching when it reaches data not equal to the data the row before, however, my experience with VBA is limited, and I have been unable to find a solution. Also, the data does not have to be conserved after being sent to the new workbook, if that would speed up the macro.
Macro To Create New Workbook And Sheets Inside Each Workbook
Mar 31, 2009I have a spreadsheet which has all the names of trips from a warehouse, the day that they operate (1,2,3 etc) and the job line allocated to each trip. It looks something like that:
A B C
DAYTRIPCUST
I would like to create a macro that will be creating 7 new workbooks and then in those workbooks as many sheets as the trips. In these sheets, the customers should be displayed.
How do I write it? I could not find how to have a "dynamic choice" in the macro. I.e. not to have the criteria as "1", "trips1" but to choose from the range of inputs that are available.
Copy From Closed Workbook Then Create New Workbook
Jan 31, 2007I've got a problem with this code, have been wracking my brains about. Here is the process I am trying to do:
1) Copy a range (a2:av1000) but (ideally) find the last populated row from a closed workbook (with a different password)
2) Create a new workbook and paste this data into it at A2
3) Close all the workbooks but only save the new one.
Sum For Section In Month
Apr 2, 2007I want when I choice the section name,The report will display only selected section sales.
I have tried the function " SUMPRODUCT", But it's display all sales regardless section name.
Extract Section Of Cell To Another?
Oct 6, 2011I am wanting to select a section of a cells data, which can be shown in a selected cell using a formula i.e
AB1350309280000768436000076843
In the example above I want to exclude the first 8 digits and the last 1 from cell A1 and show it in B1
Highlighting The Auto Sum Section
Oct 7, 2008When autosuming a section of a column, is it possible to conditional format a highlight of the 'autosumed section' so i can visually see where it is at all times?? (i.e. so when i autosum, automatically a highlight will appear over the autosumed section)
View 9 Replies View RelatedChanging Section Of Link In Formula?
Jan 20, 2014It's a new year, which means new tables and lists. I have a list of 450 People with a reference to their own individual file. They all receive a new file at the start of the new year that I Need to be able to reference in a new list. Here's an example
Joe Bloggs has a cell next to his Name referencing
[Code] .....
In 2014 Joe will have 'Bloggs 2014.xls' as will 449 of his friends, each named individually. The only part that changes from 2013 to 2014 is the date in the Name of the file. Can I somehow just Change that one part of the link without having to manually relink everything?
Each Section On A Line In Msgbox Window
Nov 20, 2009I have a message box with multiple sections. I would like to display each
section on its own line.
Hide / Unhide Section Of Rows
Apr 3, 2014I have a button that I want to hide/unhide a section of rows.
This is the code a have so far:
[Code] .....
So I've named a a section of rows "rngHideRows". I've tried to use the command .Range("rngHideRows").EntireRow.Hidden = True (and viariants of this) but nothing I try works.
Find A Section In Column And Copy?
Jan 27, 2014I need to go down column C and find the word "Canada" and the find the word "Total", there are some blank spaces between, and select from "Canada" to "Total" in column C and the cells in the same rows from column C to column H.
So if Canada is in C15 and Total is in C29, select C15:H29.
Copy Only A Certain Section Of Data In A Cell
Jan 28, 2010Is there a way to copy all of the data in a cell up to a certain character? I have the following data contained in a cell, and want to copy everything up to the first -v and paste it into another cell. The trouble I am having is that the data to copy will be of a varying length, so I can not use anything involving a count function. I would prefer to do this eiter by macro or VBA:
View 4 Replies View RelatedComments Section - Continue To Next Cell Down
Sep 12, 2012I am creating an excel sheet where there is a comments section where the column width is 58 characters. Is it possible for someone putting in comments to have it automatically go to the next row once they enter 55 characters in the row above? I don't want to use wrap text and need to maintain the rows in this section.
View 8 Replies View RelatedUnable To Get The Highlighted Section To Work
Sep 23, 2009I am editing a Macro from a guy that has left my work and I am unable to get the Highlighted Section to work. In Section 'Paste Values & Formats it appears to work fine until it get down to Selection.PasteSpecial.Paste = x1PasteValuesAndNumberFormats and it throws you out. Is this because the Macro is generating a new workbook….?
In regards to the other sections; I am unsure if it does or does not work because every time I go down to it in Debug mode it highlights it as an error…
Sub Generate_Statements()
'Declare Variables
Dim i As Long, SMax As Long, SPath As String, fso As New FileSystemObject, file As file, statement As Workbook
Dim forma As Workbook, macro As Workbook, OldVar As Long, social As Long, rng As String, rng2 As Range....................
Excel 2010 :: How To Increase Section Of Footer From 3 To 5
Jul 15, 2014In excel 2010 is there any option to increase the section of Footer from 3 to 5.
View 3 Replies View RelatedSumming Same Section Of Multiple Tabs Separately
Oct 8, 2012I have 199 tabs in which i have, for example, sales data month by month. I want to consolidate into one tab the total sales per tab. I.e. so that i have a list of tabs 1 to 199 with the sales for the year for each tab. I don't want to sum the same cell across each tab.
Is there a way of doing this without having to do 'sum(tab1...)' for my tab 1 sales and then 'sum(tab2...)' for my tab 2 sales etc?
Runtime Error '1004' Section Is Too Large
Jan 19, 2007I am copying a large section of formulas. It has to paste one row of formulas into an area from A2:AI46754.
I get the above error in VBA.
Will A Hyperlink To A Hidden Page Or Section Work
Nov 20, 2007I am looking to publish some workbooks to the masses as a mht (single web file), but I had a couple of questions before I did that:
Is it possible to have a hyperlink to a hidden or very hidden page in the same workbook?
or
Is it possible to hide some rows and have the hyperlink unhide those rows when selected?
Also, will the areas be exposed when opening the .mht?
Setting Up The Range In The Criteria Section Of Sumif Formula?
Feb 17, 2014A B
17-Feb 5.00
19-Feb 12.00
22-Feb 7.00
26-Feb 10.00
I would like to see the sum of B given it is in the range from 17-Feb to 23-Feb. My estimations so far:
=sumif(A:A,????, B:B)
How do I set up a criteria which would take values from 17-Feb to 23-Feb?
I also tried =sum(sumif(A:A,{17-Feb;?;?;23-feb}, B:B) but it wouldn't let me.
Particularly the problem is in entering the date in the array.
Information Dissapears From Graph When Section Of Other Sheet Is In 'group'
Sep 29, 2009i dont know if there is a way around this, i have a sheet, it has one large sheet with hundreds of rows under 3 headings, and i have a group on each of these so people can go in and expand their section and add details, i have a second sheet that contains some graphs simplifying the data collected in the 3 sections of the other sheet..
but i have just noticed when a section of the sheet is grouped its details are removed from the graph.
is there any way around this? i need the groups on as the sheet is so big and people do not want to be scrolling through other area's data when they can just expand their own.
Excel 2007 :: Repeat Same Code Pattern For Each Section
Jan 27, 2014I have a macro that does exactly what I need it to do, but it takes a long time.
There are 4 horizontal sections. The top section (code not included) is the total of 3 sections which are segregated by location.
For the 3 sections:
rows 101 to 172 (section 1), 198 to 269 (section 2), & 295 to 366 (section 3) have the same formula for every other column starting with column F ending with column AT (sums hrs)
rows 173 to 194 (section 1), 270 to 269 (section 2), 367 to 388 (section 3) have the same formula for every other column starting with column G ending with column AU (sums dollar amount)
the columns are corresponding dates
Below is the code snippet that produces the results for section 1. I repeat the same code pattern for each section.
Dim r As Long
For r = 101 To 172
With LaborDetail.Cells(r, "F")
.FormulaR1C1 = "=SUMIFS('Data '!C17,'Data '!C38,RC1,'Data '!C37,R1C)"
.Value = .Value
[Code] .........
Posting Links / URLs To Favorites Section Of Outlook?
Feb 24, 2014creating a distributable add in which will post either one or many URL's (predefined by me) to outlooks favorites section. I.e. when I distribute this add in to the user and the user runs it, the url's should be posted to the favorites i.e. the user should be able to click on the links and access the URL's.
View 4 Replies View RelatedPull A Reference Number And Assign It To All Records In A Particular Section
Oct 14, 2008I need to pull a reference number and assign it to all records in a particular section. The code I recorded keeps going back to the first section. Also would like it to repeat until all records have the reference number attached.
06010-100Beginning Balance07/09/2004AD06011-10007/23/2004AD06011-10008/06/2004AD06011-100
06011-100Beginning Balance07/09/2004AD07/23/2004AD08/06/2004AD
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 10/14/2008 by acantu
'
'
Selection.Copy
Selection.End(xlDown).Select
Selection.End(xlDown).Select
Range("C7").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("B7").Select
Selection.End(xlDown).Select
Range("C63").Select
Range(Selection, Selection.End(xlUp)).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Selection.End(xlToLeft).Select
Selection.End(xlDown).Select
Selection.End(xlDown).Select
Selection.End(xlDown).Select
End Sub
Extract 1st 2 Words & Middle Section From Text String
Jun 18, 2008I have a text string with 3 data to be extracted and then split throu range, but only specific parts is needed.
string is like that:
Name Surname - Number : ################ - Exp : YYMM - Centre etc etc....
Lets say its allways happens in cell A3, for example:
Adrian Kukuwas - Number : 1235467890123456 - Exp: 1009 - Centre... I would like a macro:
*that runs only if string starts with a letter, then if so
*takes Adrian Kukuwas to cell D3
*takes 1009 (the exp) to B3 and makes it look like 09 10 (or 09_10)
*in A3 leaving only the number 1235467890123456 text formated (sometimes the copy source formats the cell for bad)
Msg Box To Create New Workbook
Aug 24, 2008way to create a msg box with if you click "yes" it will copy the data from sheet 4 on workbook 1, and paste it onto a new workbook that is a copy of a standard template of workbook 1, and rename it based on a file name you give it.
ex. Pro Shop Template
Workbook 1 is Pro Shop 9/08-10/08
New Workbook 2 is a copy of Pro Shop Template but names Pro Shop 10/08-11/08