I work as an alternative health practitioner and am making reference lists to use for working with various conditions. So far I've been using MS word and manually typing out everything into lists, but since that document is becoming hugely ungainly to work with (60+ double columned pages) I thought maybe there is an easier way to do this?
So my question is, can I use excel (or another program?) to do these things? And how would I go about doing them?
"Tag" various procedures with symptoms to alleviate. For example, can I tag Scalene trigger points (technique) with the symptoms brachial neuritis, extremity numbness, neck pain, elbow pain, wrist pain, shoulder pain, upper back pain, etc (some techniques will need 25+ symptom tags). Because of the large amount of "tags" I'll need to add, being able to quickly add them (for example, maybe typing them all in one cell separated by commas) is crucial Sort the data by symptom i.e "neck pain" and have all techniques tagged with "neck pain" show up in list form. Transfer all the data I already have sorted into the excel spreadsheet - for example I have a list of 100+ techniques for "neck pain", so I would need to be able to paste that list into excel and tag it with "neck pain" so it would show up along with anything added in excel. Be able to copy/paste the compiled list of techniques for each symptom into a document that I can print out and use as a reference at work. So for instance, be able to search "neck pain" copy the list of techniques for neck pain without including any extraneous data (such as all the tags) and paste it into ms word as text, not a table.
I am having trouble delete a drop down list inspite of selecting clear all from the data validation tab in excel 2007. When I hit Alt + Down Arrow, I still see picklist options. I didnt set up the spreadsheet, hence I am not sure how to begin troubleshooting.
i have a fingerprint time recorder that provides me time log ins and log outs of employees which i use for the computation of their salaries every end of the week (saturday). here is a sample of the file i get from the fingerprint scanner program.
[URL]
now what i want to do is for it to consolidate all the names in 1 column, total number of days in another column, total basic gross pay in the next column and total deductions base on undertimeNAME Total number of work days total basic gross pay total number of hours deducted total deductions base on undertime
here is the table for salary deductions tardiness 08:01 - 08:30 am - 30 minutes salary deduction 08-31 - 09:00 am - 1 hour salary deduction 09:01 - 09:15 am - 1 hour and 30 minutes salary deductions 09:16 - onwards - considered as half day
undertime 03:35 pm = half day salary deduction 03:36 pm = one hour and a hlaf salary deduction 04:00 pm = one hour salary deduction 04:30 pm = 30 minutes salary deduction
I'm using Excel 2007 and am trying to set up 3 columns of drop-down lists each dependent on the choice selected in the previous column's selection. It seems like it would be easy to figure out but I can't seem to do it.
I've already set up the arrays for the lists and "named" them but can't get the cell to be formatted automatically according to the previous columns selection.
What I am looking to do is this... (using Excel 2007)
I need to have more dependent lists based on the selection in Column A. (My column B is already set up and works perfectly using INDIRECT)
For example: Column F would be a dependent list of colors based on the sales rep chosen in Column A Column I would be a dependent list of managers based on the sales rep chosen in Column A Column M would be a dependent list of part numbers based on the rep chosen in column A
without using VBA? (If I HAD to - okay, the other person maintaining the sheet would be lost....) I haven't been able to find anything close to what I want to do online - maybe I am just not using the correct terms.
I have a worksheet with 2256 rows. I'm working with Student's total enrollments per grade level and I need totals from some of those rows stacked neatly into columns for distribution.
In my attachments, the starting workbook screenshot is what I am starting with, and the desired end result screenshot is what I need it to look like as the final result.
im having trouble trying to figure out how to organize the following data. It concernc cycling races that has its own data like type of race, country, number of mountain stages etc. but also for each race i need a subcatagorie wich holds the data of all riders that participate in it. like;
Race: Categorie race: Number of mountain stages: etc.....: Tour de france Grand tour 8 ... Giro d.italie Grand tour 19 ...
but also for each race:
Race: Teams (wich will need up To twenty names): Riders (For Each team up To 9 riders: Tour de France Gerolsteiner Totschnig, Zberg, etc... Tour de France Discovery Channel Armstrong, Beltran, etc...
How would you organize information like that, the trouble is it must be able to use all the excel functions AND be able to update the list trough an webquery and VBA code.
I have list of county roads and would like to organize them by odd number and pair. Macro that can change the pair number first then the odd number here is an example
ORIGINAL LIST COUNTY ROAD 32 & COUNTY ROAD 55 COUNTY ROAD 36 & COUNTY ROAD 55 COUNTY ROAD 51 & COUNTY ROAD 48 COUNTY ROAD 48 & COUNTY ROAD 35
I did a survey of what kind of clothes people like to wear and why. So there are two things that people have to write down. ex) jeans and cus they're comfortable / shirts and cus they look good
The data that I received was organized as followed
I just put in random things just so you can get the idea of whats what
Id jeans shirts cardigans
[Code].....
Okay so what I want to know is how I can get the responses from the data spreadsheet I showed you before into this organized data table above.
I have raw data converted from pdf into excel Workbook spanning into many sheets.Each sheet having 5 sets of records. It is highly disoriented.Some times it is in 4 columns and some times in three columns having 30 unique Records which I Want to put in rows neatly in a single sheet .Raw Data is like in table below.In some Columns There are only 20 Records.I want them in rows organized under headers.
Name: Aa bb Fax:*5555 Team:United Actor:Arnold
[Code]....
Problem is that in some columns there are only 10 fields present,eg: name field is there Add,state,Country is not.Also in some columns many fields are in a single cell,eg: Tel,fax,Email in a single cell.
Each Record That Needed to extract starts after : Also I can Replace all required fields like name ,add, city, to 1,2,3 if that is going to work.
I would like to automate, due to how long it would take to manually organize the data myself. I have all of the raw data needed organized into 3 columns. The problem is that some of the related data is divided up into multiple rows, based on ID number. What I would like to do is take the related CPT codes and respective descriptions, from the same ID number, and place them on the same row. I am going to include some pics and even a small chunk of the source data. Here is a pic of the raw data:
And here is the first 3 already done:
The number of CPT codes per ID number range from 2 - 5 I believe, maybe 6. Not sure if this has any bearing on how it is done.
how to do this, but I know it can be done.... I want to use one drop down list created via the Data Validation 'List' Criteria to then lookup data based on the selection made in this list...... this will require a number of reiterations to get to the final result......
So:
Drop Down No:
1. List: Department Function:
2. List: Sub Function List Based on Selection from 1.
3. List: Job Code, Title and Pay Grade based on Selection from step 2
how to ensure that we are able to minimise the overall workbook size due to the complexity that is required here as this is just the basics.... this will need to applicable further once this basic requirement has been fulfilled.
I am working on a project that has 5 worksheets. I have been able to figure out everything else I need to do but this has me stumped. I have data in Sheet1 A6, that i want to place in Sheet2 A6, Sheet3 A6, Sheet4 A6 and Sheet5 A6 and keep data and formatting(BOLD AND UNDERLINE). So I change Sheet1 A6 and the other 4 sheets change also. I'm using Microsoft Excel 2007.
I want to be able to run a macro that will export some of the data from a worksheet called Generated Report into another worksheet called Matrix. The data will be taken Generated REport and grouped into sections of the worksheet. These sections will be defined by the BRID value.
The Data that i want to export will be from the first 5 columns within the Generated Report(note there are other columns which data is not required from).
The following columns will be exported from Generated Report -
BRID,Requirement, Bug Description, Bug ID and Alt Bug ID.
BRIDRequirement Bug DescriptionBUG ID Alt Bug ID PQ115 PQ115-Login Bug Description text xihllloloj43712 123 PQ116PQ116-Landing Bug Description text ghghghgoot 43713 126
For Matrix
The data will be imported into Matrix worksheet into the following columns as part of the row headings
- Requirement, Description, Bug ID and VF Bug ID.There will also be other columns (outlined below) which i will use to manually enter data
The data will be grouped and imported into the relevant section by its BRID eg PQ115, PQ116 etc.
I want each section (marked by BRID number)to be separated by row headings.
These row headings are to be generated after populating all data within each BRID number.
When the data has been populated in each row there is a column called 'Status' which contains drop down list boxes which can be assigned.
The default status will be set to 'To Do'. The complete row headings are displayed with Output from Generated Report underneath
BRID Priority Requirment Description BugID Alt Bug ID PC UpdateNotes Actual Result Type of DEfect Test Status Tested by PQ115 PQ115-Login Bug Description text xihllloloj43712 123 To Do
BRID Priority Requirment Description BugID Alt Bug ID QC UpdateNotes Actual Result Type of DEfect Test Status Tested by PQ116 PQ116-Landing Bug Description text ghghghgoot43713 126 To Do
So far the macro that i have been using allows me to locate the data for each specific BRID in Generated Report and copy into the corresponding BRID section within the Matrix. I have to repeat this step for each new BRID and i want to be able to whole automate this process.
I have a simple reporting sheet where the data for orders place is in one sheet and on the other sheet is an imput box for 'date' and it filters through and presents a table of data and two graphs for the date chosen.
I give a daily report (contents of this sheet) but I also need to leave this sheet available for anyone to open and change to another date.
I want to copy the repor sheet into a new one and email but I want the graphs to remain, not go blank when anyone changes the original sheet.
I have a 5000 line table I am filtering by a few columns, and I'd like to calculate an exponential trendline value.
=INDEX(LINEST(LN(R1059:R1167),W1059:W1167),1)
But I actually don't want all the values from R1059 to R1167 - I want to select only the displayed values (R1059, R1068, R1077, etc). Is there a way to select only display values to use in a formula? The problem is it would be a lot of manual work to select them all - there are 50 or so instances I would have to select 13 manual values.
I am building a rather good size userform. It is getting really lengthy code-wise because I want certain things to be enabled and disabled on the form as they click on certain options.
I know I can hard code the lines but so I am trying to come up with some coding elements where I will not have to add 20+ lines of code for everytime I want to add a new feature.
Here is one of the functions that I have, There is going to be several of these:
Private Sub chkMore2_Click() If chkMore2 = True Then cboProtocol2.BackStyle = fmBackStyleOpaque cboApplication2.BackStyle = fmBackStyleOpaque txtLowPort2.BackStyle = fmBackStyleOpaque [Code] .......
So If I click chkMore2 ... all of the 2nd elements will be editable. If I click chkMore3 ... then all of the 3rd elements will be editable, etc. etc.
So I tried to play with this code example:
Private Sub CheckBox1_Click() If CheckBox1 = True Then Call Changeit(1, "yes") Else Call Changeit(1, "no")
[Code] ........
Excel 2007 does not like the .concatenate element.
I am looking for VBA code to extract data from each tab into master tab based on data.
I have 3 tabs (inputs)
Tab1 (Dept A-NAME) (RANGE B4:I7)
SL NO ID Date Customer Start Time End Time Trucks Supervisor
1 A 2/25/2014 Customer 1 10 1 3 ABC
[Code] .....
Tab 2 (Dept B-NAME) (RANGE B4:I11)
SL NO ID Date Customer Start Time End Time Trucks Supervisor
1 B 2/25/2014 Customer 3 10 1 3 RTY
[Code] .......
Tab 3 (Dept C-NAME) (RANGE B4:I7)
Is it possible to run vba code to get below result in new tab
SL NO ID Date Customer Start Time End Time Trucks Supervisor Result
1 A 2/25/2014 Customer 1 10 1 3 ABC Dept A
[Code] ......
Condition here is date 2/25/2014, is possible when running code message box pops up to ask date, when we give conditional date it extracts those dates.
I have a workbook (excel07) that I use to import data onto our purpose built database. I have some macros to sort the data and send it to the correct columns however the one stage I still have to do manually is assign each row its own unique sorting Code (in a bespoke column "B2:B999").
These are objectives and the code should contain three seperate parts (part 1a and b do not need to be seperated);
1a. The characters "PO" should be the first in the code (for sorting purposes)
1b. The persons initials (first letter of the first name and last name) found in column J2:J999. [They are sorted by name so It would also be good to add a number after the initials seperated by a space incase of multiple objectives however I could defintly live with typing these in manually]
e.g. "Joe Blogs" second objective = JB02
2. The numerical part of the stategic objective they have selected found in column H2:H999. [incase you need this these range from 1.1-1.4, 2.1-2.5,3.1-3.6 and 4.1-4.5 all with a short text strings after which shouldnt be included in the code]
e.g. "1.1 We are Committed to being nice" = 1.1
3. The year they are applicable for which will all be "12/13" however I will need to change this next March.
Therefore the final code should appear as "POJB02 3.1 12/13"
There is a 16 Character limit on these codes but all of that information is needed for sorting, filtering and report generation, the spaces could be replaced by "_" if that makes things easier.
I'm currently working on a spreadsheet for my husbands work in a school environment. All was going well until I hit a wall with the alphanumeric data of the current uk stats system. Is there any way of getting my 4c...4b...4a...etc. to chart?
I have a table with names of employees in Column A, the data for each employee is written in columns B, C and D.
I'd like to be able to type in this data in cells E12-E14 and have Excel bring up all of the names in the table that are associated with this data, and preferably separate them with commas.
I'm working with Excel 2007, without VBA/Marcros.
Please see the example file: find_name_example.xlsx
I have a table in Excel 2007, one set of data in a column contains cells with data such as = AA701 DIS34 5283000, Z00IS0750 Now these AA codes DIS codes 5283 codes and Z00 codes can all be different!! and they are all within the same cell.
What I need to be able to do is find out which AA code which DIS code which 5283 code and which Z00 code is reported within each cell on each row?
So could I split them out into different cells via VBA? or can I do some kind of lookup that picks up a AA code (for example) ?
The constraints I have is this is downloading from a web query, I do not have the ability to alter the way the original data is coming across, I can only alter it once I have received it - refresh and then alter it again.
I have some data in a Excel 2007 workbook in the range a1:d100 and I want to sort the data according to "A" column, which is the first column of the range and when I am giving data sort it is prompting to select the column, where as in 2003 it will prompt to select the column but by default it will take the first column of the range, so if we want the first column the we can hit enter key otherwise need to change the column name which will save time.
My question is that whether there is any setting I can make at the time of sorting data and by default it will take the first column of the range.
I want to make this code more efficient by searching for either 1kp, 2kp or 3kp in one process & 'doing the same thing' at one time. How do I achieve this?
Explained slightly differently, the code should look something like this:- Find 1kp or 2kp or 3kp. Then do something with the found results.
1. Main (where I have a button and I intent to write code and paste the data)
2. Data (where I have data to be copied)
My code so far
Code: Sub copy() Dim wbData As Workbook Dim wbMain As Workbook Set wbData = Workbooks.Open("path") Set wbMain = Workbooks.Open("path") wbData.Sheets(1).Range("A1:A5").copy wbMain.Sheets(1).Range("A1:A5").PasteSpecial wbData.Close End Sub
In the above code the problem is that the file wbMain is already open and when I try to re-open it gives an error and program crashes and if I do not open the file then it gives me the error and says sub or function not defined as wbMain variable is not set.
Second problem:When an error is thrown or I close my files, I lose all the VBA code and module? strange ! how to save modules permanently? using Excel 2007
