Distributing Add-ins
Apr 10, 2007I've written an add-in that I need to give to about 30 people in my office. What's the best way to get the add-in saved in everyone's Windows Add-Ins folder?
View 4 Replies
ADVERTISEMENT
Distributing VBA Code Changes Via VBA
Apr 26, 2006I have a number of identical workbooks used for data capture within the organisation, and need to continue development as time goes on.
Whenever I make a change to the core Excel functions of the workbooks I simply use a VBA procedure to conduct this change within each of the production workbooks, however I am stumped as to how I can achieve this for changes to the VBA code.
I have made some changes to the code held within one of the modules, and have also modified the form slightly. What I want to be able to do is run a VBA procedure that either updates the production workbooks from a central source, or by importing previously exported code / forms.
Distributing Excel Macros
Jun 9, 2007I have a number of sheets that have sheet macros that are identical.... i am changing the sheet macro in 1 and want to see if there is an automatic way to distribute it to the other sheets automatically.
View 9 Replies View RelatedDistributing Numbers In A Pattern
Dec 21, 2008I am trying to come up with a formula that will distribute the numbers as shown in this diagram:
To get the value of each number divide 42,000 by the last number in the pattern. For example the fifth column from the left would be 42,000/18. That means that each number would have a value of 2,333.33. By the time you reach the half way mark, nine in that example, you should have around 21,000, and the other 21,000 should be distributed between the last half (block 10 thru 18). The formulas would have to work on all of the patterns. Can anyone think of a way to match the pattern shown? It doesn't have to be exactly the same pattern just as long as the number of blocks remains the same for each half, and they total 21,000 for each half without going over 42,000 all together. There has to be 11 rows from top to bottom.
Distributing Dollars Per Conditional Formatting?
May 10, 2009I am using conditional formating to show dates as a bar graph (nice little template I got from Vertex 42). I have fee dollars in another column that I would like to distribute according to those dates. I have posted a snapshot of the image here:
[URL]
how I can get the dollars to populate the cells according to the dates.
Distributing Days In A Range Between Years
Oct 31, 2013I have 2 dates and I'm looking to distribute the days between in the correct 'year' column (See below). my problem is with the units that have days that span +2 years.
I've tried nested 'If(and...)' formula......
Distributing Data Over Sheets Tabs
Feb 25, 2008I have a master spreadsheet with names and addresses and action dates all in one sheet tab.
I want to be able to get all the data that pertains to action dates in March 08, for example, onto a sheet tab in the same spreadsheet called march 08, and then all the data from action dates in april 08 to go to a sheet tab called april 08 etc etc
What would be the best way to do this?
Distributing Column Data Across A Worksheet
May 15, 2006I have a sheet with 5 columns in use at the moment.
Col: A - E . Col C has a Score and Col D has Game #
I'll like some code to look at each cell in col D and based on the Game# copy the value from the corresponding Col C to the Game column that is set up for that Game. ( I can set these up manually )
Col D can contain both numbers or text
Something like
IF D2 = 23, C2 = H2
IF D2 = 29, C2 = M2
IF D2 = "HOME", C2 = W2
etc etc
Col D can contain up to 20 possible numeric values & 8 possible text values
Also: Since I know all the 28 possible values that Col D can contain, how can I also get those columns set up automatically using VBA and SUM those columns that are set up with the numeric values at the last row.
Distributing Information From One Cell Into Multiple Cells?
Apr 22, 2009I imported a CSV file into Excel, and the data from the CSV file all ligned up into one column. For example: I have (date, price) both in one column. I need to separate these values into two respective columns.
View 2 Replies View RelatedDistributing List Of Numbers In One Column To Several Columns
Jul 23, 2013I'm working with a dataset from a survey that has recently taken place. The original structure of certain questions in the survey were multiple choice. The ideal structure for these questions, in terms of variables, is that each possible option for the question (A,B,C,D... etc) have a separate value, with a 1 for yes (reported) and 0 for no (not reported). In other words, if Question1 has multiple possible answers (A,B,C...), then there should not be one variable created from this question, but rather, there should be a variable for each possible response: Question1_A, Question1_B, Question1_C, and so on. And within each of these variables, should be a 1 or 0 depending on if that option was reported or not.
The format I received the data in, though, was a single variable with a list of letters, (e.g. B,D,F) for each option reported.
Variable: Question1
Row 1 A, B, C
Row 2 B, E, F
Row 3 B, D, E
The data I have right now is housed in Excel prior to exporting to SPSS and/or STATA. I need to find a way to distribute these values into separate columns (variables). The tricky part, is that if I simply use "text to columns", it distributes the letters to new columns, but doesn't take into account that the first value reported might not be A. Is there a way to take the list of values in the single columns, and distribute them to assigned newly created columns?