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‎
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 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.
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.
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.
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
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 RelatedI 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.
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 RelatedIt'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?
I have a message box with multiple sections. I would like to display each
section on its own line.
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.
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.
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 RelatedI 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 RelatedI 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....................
In excel 2010 is there any option to increase the section of Footer from 3 to 5.
View 3 Replies View RelatedI 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?
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.
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?
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.
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] .........
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 RelatedI 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
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)
I have a column that has section numbers like 001.002.006.003.010.011.002.
I would like to divide that single column into seven columns with only the single or double digit in it, ie
1 in a cell
2 in a cell
6 in a cell
3 in a cell
10 in a cell
11 in a cell
2 in a cell
Have been using MID and FIND togther, but when I get to the double digits like 10 an 11 I run into problems.
I'm making a macro that filters a data set and then inputs a value into all of the rows for a certain column. When no results show up for the filter I receive a runtime 1004 error because there are no cells to select.
Here is my code:
Sheets("External Buys").Select
Range("G5").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Raw Data").Select
ActiveSheet.Range("$A$1:$AU$10432").AutoFilter Field:=39, Criteria1:= _
[Code] ......
I've used VBA to make a picture appear when all the correct answers have been entered and it all works well. However, not to be too mean to 15 year olds, many of my students can be devious little feckers, and I want to hide and password protect the VBA code so that they can't just change the pictures visible section to true. I can password protect the workbook and worksheet, but not the VBA.
I'm entering the Visual Basic editor and I can see my simple script. I then click Tools - VBproject properties - protection. I'm clicking the "Lock Project for Viewing" box then filling in the password and confirming the password and clicking OK. But I can still see and edit my script, despite protecting the sheet and workbook.
I am working on a concrete pour summary, I would like to have the specific codes on each tab be affected from one summary page. So when I enter a certain number on sheet 1 , it will affect that same number section that is on a different sheet. It will be adding a certain amount to that code section every time its entered. What functions need to be used to make this work..?
View 6 Replies View RelatedI am working on a concrete pour summary, I would like to have the specific codes on each tab be affected from one summary page. So when I enter a certain number on sheet 1 , it will affect that same number section that is on a different sheet. It will be adding a certain amount to that code section every time its entered. What functions need to be used to make this work..?
View 3 Replies View Related
