Thanks for all the help I have now sorted this issue.
I created a template chart and have added a series of buttons on each page withthe following code behind the button.
Not pretty but it works.
Sub CreateNEETChart()
Sheets("Neet 16 - 18").Visible = True
Dim SelectChart As Chart
Set...
SkipVought I am no novice at excel thank you, unfortunatly the make up of the sheets has been dictated by the needs and requirements of the business and what the scorecards have been designed to do, which is to allow for a scorercard/dashboard system of data, allowing users to only access their...
I have a series of scorecards type sheets that I want to chart the data from.
While I could do each one in turn, I can have up to 20 seperate sheets, with 20 measures on each sheet.
I have half found an answer to this but wondered if someone can help with the rest
I want to select a row using...
Does anyone have any code that will set up a simple logfile of persons entering an inital page on a intranet site, i just need to write the network id, Time and date into a text file.
I only want to do this for a short time to enable me to find an rouge network user...
I want to connect Mappoint to an odbc that already exists on my machine, it is a sybase server not SQL so i can't use the Map Point SQL free add in.
Has anyone managed to do this??
I know i can link my database via Access into mappoint, but i do'nt really want to do this if i can help it...
I know i said this held, but it doesn't seem to, i still get spasmodioc link errors, anyone have a piece of code that i can run when the workbook is first open to check the links and update them.
The files it links to are static, so it isn't as if they move.
--------------------------------...
Brilliant, cheers.
--------------------------------
Luke: But tell me why I can't...
Yoda: No, no, there is no why. Nothing more will I teach you today. Clear your mind of questions.
I can't seem to find a piece of VBA code that will give me the last saved date of the workbook so that i can show this in a cell of a sheet, anyone know of anything that would work??
--------------------------------
Luke: But tell me why I can't...
Yoda: No, no, there is no why. Nothing more...
Converting the seets to either xlsx or xlsm dependant on the content worrked a treat, cheers
--------------------------------
Luke: But tell me why I can't...
Yoda: No, no, there is no why. Nothing more will I teach you today. Clear your mind of questions.
I have a number of spreadsheets that are linked to a series of data sheets. Every so often for no reason these sheets lose the links, although the sheets do not move, just get updated with data.
Despite clicking on 'Don't display the error and update links' on the edit links box, and also...
I have a number of spreadsheets that are linked to a series of data sheets. Every so often for no reason these sheets lose the links, although the sheets do not move, just get updated with data.
Despite clicking on 'Don't display the error and update links' on the edit links box, and also...
The only problem with that is that it always just gives me the same 6.
I have solved this now anyway using Crystal reports out of the database.
--------------------------------
Luke: But tell me why I can't...
Yoda: No, no, there is no why. Nothing more will I teach you today. Clear your mind...
In a table i have a list of names and address's, each of these has a unique client ID, and each of these clients is allocated a caseload advisor.
In order to do a caseload audit, i have been asked to create a report with 6 random client no for each of the advisors.
I can't seem to get the...
I am sure that it is listed here somewhere but I cannot find it.
I would like to have a program running in the background that will be checking the contents of a folder, once a file exists with a certain name, the following will happen.
A) Create text file with names and update dates of all...
Ok, adapting the code you sent to this
Sub Findid()
Dim wbNEET As Workbook
Dim r As Range
Dim Var1 As String
Var1 = 0
Var1 = Cells(4, 2) 'Find Advisor Name
Set wbNEET = Workbooks.Open(Filename:="c:\Scorecardtest\Neet.xls") 'Open Consolidated workbook...
The source data is coming from a program written by our software supplier to aggregate data every month.
From this I am pulling out data for all advisors from 5 offices in the 8 soon 9 target areas for reporting, I cannot simply extract the data that i need at advisor level without doing it...
First, i am using a report to export my data into a usable format, as detailed above, so hardly shooting myself in the foot, more getting the data in the least unweildy format possible, if it wasn't a pain in the backside i would prefer to be using BCP or similar from the database, unfortunatly...
This needs to be an automated process.
The data will be coming out of a database via a crystal report overnight.
The VB code will hopefully run each time the speadsheet is opned to update the data, as i said, this will be approx 200 speadsheets needing to be updated with data everymonth.
Can...
Sorry, just to clarify this, this is the code i am currently using
Sub FindId()
Dim Var1 As String
Dim CopyRange As Range
Var1 = 0
Var1 = Cells(4, 2) 'Find Advisor Name
Workbooks.Open Filename:="c:\Scorecardtest\Neet.xls" 'Open Consolidated workbook
Range("A1:G16").find(What:=Var1...
I have the below spreadsheet:
Advisor Type Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
A Barrett NEET 25 25 25 25 25 25 25 25 25 25 25 25
A Barrett In Learning 15 15 15 15 15 15 15 15 15 15 15 15
A Barrett Not Known 26 26 26 26 26 26 26 26 26 26 26 26
A Barrett YP JWT 29 29 29 29 29 29 29...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.