Creating A Help Guide Within Excel
Sep 26, 2007within excel for a big spreadsheet they developed?
can you suggest a way of doing this or an article to read?
could users press F1 and let my own custom help guide appear?
within excel for a big spreadsheet they developed?
can you suggest a way of doing this or an article to read?
could users press F1 and let my own custom help guide appear?
Does anyone have a comprehensive / detailed guide on using the Solver which includes many examples?
View 3 Replies View RelatedJust striving to have this kind of "picture arrangement's macro" to work, macro that whenever you choose a certain cell and operate it on hotkey it'll:
1. Create a new folder named "PicturesAuto" beside the excel file (wherever the excel file located).
2. Inside folder "picturesAuto it'll create a new subfolder named by the same name of the sheet related to that cell you operated the macro upon. (let's say this cell placed on sheet named: "happysheet"- that'll be the name of the subfolder created.)
3. Inside the subfolder "happysheet" it'll create a new subfolder named by the text of the cell you activated the macro upon (let's say you initially operated the macro on B5 cell -which has the text "montana" so it'll create "montana" subfolder also inside subfolder "happysheet")
4. Lastly instead of having only the text "montana" in "B5 cell" like we had initially before activating the macro, the macro'll also add to that text "montana" the link to "montana" folder (path of excel file->picturesAuto->happysheet->montana)
The way I'm planning to use this is to add a lot of HR pictures inside those folders created by the macro that related to that specific sheet, and that specific cell I've activated the macro upon. Plus just having those pictures so organized is just outstanding in every scale, and the excel file will keep running smoothly without any resource consuming overload.
Adding a search engine like feature to a spreadsheet we have which has multifarious columns of data on it, here is a screenshot of what it looks like:
[URL]
We have multiple sheets for each tutor like that picture which lists all information of their learners for reference, now I want to do a search feature on the main home page or perhaps on a dedicated "Search" page which allows us to filter out specific information out of those columns, mainly the ability to search by "Tutor" (aka sheet name), "Postcode", "Venue", "End Date", "Learner Name" and "EBS" number...
I have a table
item_desc
a
b
c
a
b
c
a
b
c
As you can see, a,b and c is repeated times.
How do you make it so that it would look like
item_desc
a
b
c
item_desc2
a
b
c
item_desc3
a
b
c
Is there a shortcut in doing this instead of copy pasting it?
I have a record just like this with about 572+ rows and 13 repeating items with that 13 items having their own column so copy pasting is really a tedious task. Kindly please help me solve this?
I have created a excel document. Would like to create report using the data.
create reports using excel data
The following code is used to export values form Excel into a word document:
The report obtained then looks like this:
Excelforum.jpg
How can I make the values fit within the margins of the word document?
I've got quite of few excel charts to make and have been looking for a way to automate the process. The chart types include line, pie, and bar. Basically, I have data for each state in the US that I am comparing with national level data. Thus each chart will have national level data and the data for each state. What I need is a macro that I can easily change the parameters for because different worksheets have slightly different layouts. I started by using the macro recorder to make a chart. Then I attempted to edit it so that it would run loops to make additional charts. Below is some sample data for the first worksheet I have and my attempted macro.
Sample Data:
Code:
State Characteristic Value07 Value08 Value09
Alaska A 11 23 45
Alaska B 13 22 98
Alaska C 99 91 21
Alabama A 23 14 11
Alabama B 44 62 76
Alabama C 75 47 21[code]....
This code doesn't run at all.
How can I create keyboard shortcuts in the easiest way.
E.g.: I would like to create my own shortcut for "Merge".
I've used excel to do a lot of managing stuff as far as budgets. I'm not sure if this can be done or how. I'm not to great in excel, So perhaps you can lead me a hand. I'm starting out a home based business and trying to set everything up so I'm ready to officially start. I am planning on getting a scanner to keep track of what comes in and out.
So what I wanted to try was if I scan "A" 4 times I wanted the QTY to be 4 so basically group similar Items move on to "B" and oh crap I found 10 more of "A" scan that and have it updated now to 14. You catch my drift? so I'm not sure if a statement like {if "A" is scanned then the QTY would be +1} Then the sales part would be the opposite of that statement.
I have a bunch of data about companies in an Excel workbook. I need to be able to create a "summary document" about a selected company in word. One of the items that needs to be in this summary is a pie chart.
This code works fine for generating the basic text of the document:
Code:
Sub export_to_word()
Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
Dim companyName As String
Dim address As String
Dim revenue As String
[code]....
Creating the chart has been more problematic. I adapted the following code from an example found on MSDN:
Code:
Dim valueChart As Chart
Dim chartWorkSheet As Excel.Worksheet
Set valueChart = wrdDoc.Shapes.AddChart.Chart
valueChart.ChartType = xl3DPie
Set chartWorkSheet = valueChart.ChartData.Workbook.Worksheets(1)
chartWorkSheet.ListObjects("Table1").Resize chartWorkSheet.Range("A1:B12")
[code]....
What I've found though is that this code is based on a macro inside the word document, not excel. So it runs fine from within word, but within excel it throws an error at this line
Code:
Set chartWorkSheet = valueChart.ChartData.Workbook.Worksheets(1)
because ChartData is not in the object model in Excel. how to proceed at this point.
Any formula that would add a number in excel in a particular cell by clicking the "+" key.
Almost like a take a number display at the deli?
Any way to create a queue system in excel.
Here is what I would like to do:
Pull emails from outlook into a spreadsheet and click an add button that would add the From and Subject of the email to the bottom of the list with a timestamp showing the time the add button was pressed for that email. I would like the list to have the oldest timestamps stay at the top of the list, if possible.
I need to create a pyramid in Excel with 5 boxes. It will have 3 levels. The middle level will have 3 vertical boxes and the top and bottom box will be horizontal. How do I create it?
View 6 Replies View RelatedMy chart is coming in blank when I set up a line chart. This is my data that I selected and then pressed chart. 1997
63.9%
1998
63.2%
[Code].....
I want to create a bell curve for my team's annual appraisal. There are 12 people in my team. The scale is 1-5, where normally rating range from 2.9 to 4.0.
View 1 Replies View RelatedI have a challenge trying to get excel to recognize yearly intervals.
Let me explain further:
Interval Percentage Yr1 Yr2 Yr3 Yr4 Yr5 Yr6 Yr7 Yr8 Yr9 Yr10 Yr11 Yr12
3yrs 10%
I want excel to insert the 10% into the cells every 3yrs.
I have attached a dummy workbook detailing my issue
Interval problem 1.xlsb
I have a huge Excel spreadsheet with various worksheets and data, I want to merge some of that data into a report using word template. How can I pull simple data like the company infomation into that word report from Excel? Do I need to know VBA to accomplish this?
View 1 Replies View RelatedI have been tasked by the company I work for to come up with a simple to use interface that can be used by someone with little understanding of excel to set the autofilters to certain settings.
So here is what I have:
2 sheets (each with the same number of columns but different data which corresponds to good and no-good)
Each column has an autofilter but only two on each sheet need to be set.
One filter controls valve type (of which there are 10) and the other controls running condition (startup and normal)
Now my employer wants something that is basically idiot proof so that someone can simply open up the excel file, input the valve type and running condition, and be rewarded with only the corresponding data and charts. Now the filters are already in place, the charts already exist and the only thing left is the user interface.
create a unique scoring system on a set of given criteria that enables an even split in work for team members. so i.e. work comes in, and depending on the criteria of work its then passed to the relevant team member based on points. At the moment work is allocated A-Z which is working out unfair on team members as some are getting more/less work than others...a points system will enable a even split. so if a piece of work scores 30 points it goes to a junior member, if a piece of work scores 80 points it goes to a senior member and so on...my problem is how to link the points and criteria...Im guessing joint vlookups will be needed.
the only other way i can think a system is similar is like a fantasy football system...points based on criteria.
create an excel spreadsheet, where i can enter all my products name, unit price etc. so when i am doing an invoice for the customer, if i just type the product name price will show up automatically.
View 4 Replies View RelatedI have created the following excel attached which gives me the results I require,
However I am wondering is there any possibility I can get the results produced via VBA as it takes to long to calculate with formulas
I am trying to set up an holiday card on excel which I have the template for but I need an email sent to me, the manager, each time it is updated by my staff requesting Annual Leave. Each member of staff will have a program each.
View 1 Replies View Related1.) Create shapes (customize oval shape), I was able to create one but I think the code needs improvement to have the shape a fixed name. - see attached excel file.
2.) Move shapes into corresponding cell. Example: (Oval shape1, should be in cell g6). - see attached excel file.
Customize Heatmap creation.xlsm
The way that I was thinking about doing this would be by creating a template in word and using bookmarks. Then I would use VBA to populate those bookmarks based on the person (publisher in this case) i was invoicing.
I'm having a couple of issues logistically though. I'm not sure how to attach the sample invoice, so i'll do my best to write them out and if i figure out how to attach a doc by the end of this i will include a sample so you see what I'm talking about.
Issue 1: Each Invoice form has the publishers Name and Address listed at the top of the form. The problem is, the information i'm pulling the number of sales (and money we owe them) is from a different spreadsheet every month and wouldn't contain this address information on it as it is an aggregate spreadsheet of ALL publishers numbers. Would it be possible to create an initial template for each publisher and then have the rest of the information be populated with the data from the CSV that has their sale information. I could create a seperate database in excel with each publishers address and name but then it might get difficult to match these up. how to automate that, as we have 100's of publishers and invoices are done every month.
Issue 2: Bookmarks seem like a nice way to use VBA to replace their values with excel data (in theory, i've only read about it and never attemped)... However, in this particular invoice form, I have to create a seperate listing in the description field for each product a publisher sold (including how many they sold and how much money they are owed). Some publishers may have sold 5-10 different products, while some may have only sold 1 or 2. How do i get word to insert a new bookmark (or something) based on the number of products a person has sold.
I have a column of the date of sales. (several hundred lines long) and each line has the name of the item sold. I need to complete a report showing how many sales of each item per date. Date of sale in one column and the name of the product in another.
View 3 Replies View RelatedHow do you create a reference number to be posted in a userform2 that is opened from an earlier userform1 where you have entered some initialisation data and generated a source reference number. ie set of data has reference X and there will be y items in that set want references in form X01 to Xy (y unlikely to exceed 20). Want to put references 'X01' into the userform2 and cycle through data entry in userform2 from source reference X01 to Xy. (I'm having problems with the transfer from 1 to 2!)
View 2 Replies View RelatedIn MS Excel 2011 for Macintosh can I assign a macro to an object, such that if the user clicks the object it runs the macro? That is creating a button on the spreadsheet that will execute a macro.
View 2 Replies View RelatedIm trying to write a code in vba in Excel 2010 that would incorporate the vlookup function in excel.
My Data Looks like this:
List 1Weight 1List 2Weight 2List 3Weight 3List 4Weight 4a2.00%j20.00%a14.00%p2.00%b4.00%k32.00%d2.00%y3.00%
c7.50%e10.00%g14.00%u6.00%d8.00%d15.00%h20.00%h7.00%e9.00%q13.00%y45.00%f8.00%f20.00%r5.00%q5.00%
d9.00%g35.00%n5.00%t10.00%h10.00%r14.00%i4.50%w15.00%b0.18Z0.04S0.04Total100.00%Total100.00%Total100.00%100.00%
Where I have X number of Lists, each composed of two columns. The 1st column has the name of each item in each list, and the 2nd column has the value for that item.
What I'd like to do is create a function that would let me choose two lists, and tell me the amount of items in List X and what their values are in List Y, and then total them. Also, I would like it to work the opposite way, and tell me the amount of items in List Y and what their values are in List X, and then total them.
So for example, If I wanted to look at lists 1 and 2, the function would calculate that for List 1, Items D & E are found in List 2 and have a total value of 25%. For List 2, Items D&E are found in List 1 and have a total value of 17%. For all items not in both lists, it would return values of 0.
The code I came up with so far looks like this:
Function AK_Overlap_Go(x, y)
Dim Temp(1 To 2, 2 To 1)
Dim x As Integer
[Code]...
One of the problems I'm having is that the lists contain a different # of items, and so I think I need to loop the vlookup for each row. However, I'm not sure how to do that and get the cumulative values for each list.
I would like to create a sound alert if the answer to an "if" statement is false. I am using Excel 10. Can it be done, and if so, how?
View 5 Replies View Related