Create A Help Section In A Workbook

Aug 5, 2003

I 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.

View 9 Replies


ADVERTISEMENT

Copying A Section Of Another Workbook

May 26, 2006

I 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 Related

Macro: Section And Closed/fixed Section

May 25, 2007

I'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 Related

Populate Section With Information On Top Row Of Section

Apr 2, 2014

Refer 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‎

View 7 Replies View Related

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.

View 1 Replies View Related

Delete Sheets And Create New Workbook In Shared Workbook

Jun 2, 2014

I 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?

View 3 Replies View Related

Create New Workbook With Separate Sheets From Data In Another Workbook

Jul 16, 2012

I 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.

View 5 Replies View Related

Macro To Create New Workbook And Sheets Inside Each Workbook

Mar 31, 2009

I 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.

View 9 Replies View Related

Copy From Closed Workbook Then Create New Workbook

Jan 31, 2007

I'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.

View 9 Replies View Related

Sum For Section In Month

Apr 2, 2007

I 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.

View 6 Replies View Related

Extract Section Of Cell To Another?

Oct 6, 2011

I 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

View 3 Replies View Related

Highlighting The Auto Sum Section

Oct 7, 2008

When 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 Related

Changing Section Of Link In Formula?

Jan 20, 2014

It'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?

View 4 Replies View Related

Each Section On A Line In Msgbox Window

Nov 20, 2009

I have a message box with multiple sections. I would like to display each
section on its own line.

View 3 Replies View Related

Hide / Unhide Section Of Rows

Apr 3, 2014

I 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.

View 7 Replies View Related

Find A Section In Column And Copy?

Jan 27, 2014

I 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.

View 4 Replies View Related

Copy Only A Certain Section Of Data In A Cell

Jan 28, 2010

Is 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 Related

Comments Section - Continue To Next Cell Down

Sep 12, 2012

I 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 Related

Unable To Get The Highlighted Section To Work

Sep 23, 2009

I 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....................

View 9 Replies View Related

Excel 2010 :: How To Increase Section Of Footer From 3 To 5

Jul 15, 2014

In excel 2010 is there any option to increase the section of Footer from 3 to 5.

View 3 Replies View Related

Summing Same Section Of Multiple Tabs Separately

Oct 8, 2012

I 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?

View 2 Replies View Related

Runtime Error '1004' Section Is Too Large

Jan 19, 2007

I 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.

View 9 Replies View Related

Will A Hyperlink To A Hidden Page Or Section Work

Nov 20, 2007

I 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?

View 9 Replies View Related

Setting Up The Range In The Criteria Section Of Sumif Formula?

Feb 17, 2014

A 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.

View 1 Replies View Related

Information Dissapears From Graph When Section Of Other Sheet Is In 'group'

Sep 29, 2009

i 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.

View 4 Replies View Related

Excel 2007 :: Repeat Same Code Pattern For Each Section

Jan 27, 2014

I 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] .........

View 6 Replies View Related

Posting Links / URLs To Favorites Section Of Outlook?

Feb 24, 2014

creating 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 Related

Pull A Reference Number And Assign It To All Records In A Particular Section

Oct 14, 2008

I 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

View 9 Replies View Related

Extract 1st 2 Words & Middle Section From Text String

Jun 18, 2008

I 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)

View 9 Replies View Related

Msg Box To Create New Workbook

Aug 24, 2008

way 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

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved