Remove Data From Custom For Fast And Keep The Needed Data?

Apr 7, 2014

We have our system set up with 2 folders one with blank forms and the other with these forms filled out and completed (records), is their a trick to removing the data from a completed form fast with out removing tables and text used to make the forms questions? If I could do this it would save time from opening in the blank forms folder then saving in the records folder.

View 4 Replies


ADVERTISEMENT

Data Dump Of Charted Data Needed

Jun 22, 2009

I have an interactive moving average model (which has an adjustable moving average feature) which successfully charts the moving averages of the data on the chart. I have coded this with VBA. However, I would like to get a data dump of the individual moving average data points. That is, I would like to see the individual data points (that are plotted on the chart). Would anyone be able to help me with this?

View 14 Replies View Related

UDF Needed To Get Correct Data

Jul 3, 2014

I need identifying correct title and corresponding company name. For this I need a UDF which looks for first occurrence of title having event or marketing or meeting word in data and if found the remove other titles and company names already separated with "/".

Sample Data
Producer, Target BTC@Periscope/Events Manager, Recognition Events@Minneapolis Park & Recreation Board/Event Producer@Events by JLS

Required Result
Events Manager, Recognition Events@Minneapolis Park & Recreation Board

Sample Data 2
Sales Associate@Teavana/Event Assistant@City of Saint Paul

Required Result 2
Event Assistant@City of Saint Paul

Sample Data 3
Sales and Catering Manager@Bunker Hills Golf Course at Town & Country Caterers/Marketing Coordinator@Town & Country Caterers

Required Result 3
Marketing Coordinator@Town & Country Caterers

View 3 Replies View Related

How To Make A Custom Conversion Program / Formula Between Custom Data

Feb 15, 2014

I'm trying to make a converter between about 8 various types of values. These are not units like Km or miles or something like that, but rather numbers that represent a specific "hardness value" on a variety of scales (to name a few: HRC, HRA, K)

What I've been doing so far is plotting the two types against eachother and then getting the best trendline I can so that I can use that formula to convert between the two with relative certainty. (for example, when plotting HV vs HRC my fourth order polynomial trendline with an Rsquared of 1 is y=0.0001x4 - 0.0188x3 + 1.0768x2 - 20.709x + 350.69)

My questions comes up where I was hoping to make a window or box of some sort allowing the user to input a numeric value, then selecting the Input units and the hopeful output calculated units, and have the box spit back to the user the conversion.

View 9 Replies View Related

Calculator Needed For Data Between Ranges

Jul 9, 2014

See the screen shot I have attached: ramp rate.jpg

Basically I have to trawl through tonnes of data every day and I would like an automatic way to do it for me. I am calculating the ramp up rate on an Autoclave oven so these figures are temperatures.

I have various ranges for each section of a cure cycle so I will use this one example.....

I need to calcuate the ramp up rate between 115°C and 140°C

I need to find the min and max between 115°c and 140°c then count the cells within the min and max, minus the min from the max then divide by how many cells there are inbetween

(MAX-MIN)/CELL COUNT BETWEEN THE TWO

Is this possible?

View 3 Replies View Related

Array (delete Un-needed Data)

Sep 24, 2009

Is there a way to delete this un-needed data while it is still in an array (effectively resizing the array - removing specific columns and rows) and then writing the array back to the worksheet?

Example:
(5X5) Array with the following data

View 3 Replies View Related

How To Hide Data Validation Lists When Not Needed

Jan 7, 2012

I have a need to use data validation for user selection of dependent lists, but dependent upon what the user picks from a previous list I need some selections to disappear or become hiden somhow.

For example, let's say I want to first pick from a list of Countries, then States, then Cities, but some of the Countries do not have States, just Cities and some have both. When a Country does not have any States I need the States data validation drop down box to disappear and the cell to become blank so that the user knows there is no selection needed.

I know how to make the dependent data validation lists, but I do not know how to make one of these drop down lists disappear based upon a previous selection in dependent lists.

View 4 Replies View Related

Formula Needed To Count Cells With Data

Jul 12, 2007

formula to calculate how many cells in a column contain data of any kind. The data might be a number, a word, or even a symbol, such as "):>:)" for example. The range will change from time to time. For example, one day it might be a2:a4956. A few days from now I might delete a few rows from the top, such as rows 2 through 26, so then the range would be a2:a4931. Then I might add rows at the bottom with data that I need to be counted. I dont want to have to change the formula evertime I add or delete rows with data. I do not want the formula to count a blank space created by the space bar as "data." One formula I used sorta worked, but if the cell appeared empty, but had been cleard out by pressing the space bar instead of the delete key, the formula counted it as a cell with data.

View 9 Replies View Related

Create New Sheet For Each Group & Copy Needed Data To Each

Mar 11, 2009

I have just inherited an Excel spreadhseet that displays job titles and what types of documents each one should be trained on. What I am trying to achieve is a formula, or something to that sort, that will look at each job individually and tell me only those documents that they need to be trained on and list it on a seperate sheet.

If you look at the attached document you will see that the first 2 columns contain a document number and description. Across the top you see each of our job descriptions. In the middle you see an X that indicates that person should be trained on that document.

So once more, I would like to take each Job Description (seperately) and list only the documents that have an "x" in their column on another sheet. I already have the sheets created, I just need to know if there is some kind of formula or macro that can do this for me.

View 4 Replies View Related

Formula Needed To Copy Same Set Of Data From Cells And INDEX Into A List

Nov 27, 2012

I have a list of data in columns Q R S and i need to in between each line insert the data from columns D E F underneath and then underneath that the data from G H I

so bascially i have a list at the moment like this

Q
R
S

[Code]....

There is 2 sheets in total , 1 i need to inc 1-1 draw as above and the other sheet to be exc the 1-1 draw . I have attached an example of what i am trying to achieve . can offer as i have had this on excelforum.com with over 150 views and no solution

View 2 Replies View Related

Link Excel To Another Program - Only Showing Data / Information When Needed

Jul 3, 2014

However, I have got an Excel file which contains a lot of information. There are four sheets with large Pivot Tables.

But the thing is, the plan is to do the tables much larger, create tables which more specifically shows information. When doing so, the tables will show much more information, and therefore be much larger. It will be difficult to read and understand the tables because of the large amount of information.

What I want is to store information in, for example, another program such as Microsoft Access. There, I can put a huge amount of information and then link it to Excel, so that in Excel I only see the Access stored information when I "search" for it with y created slicers. Like, when I use my slicers and click on one category it sort out and shows me the information i want, even though it's stored in Access. It only shows it in Excel when I "ask" for it. This is what I have thought.

View 6 Replies View Related

Vb Code Macro Needed To Transpose Data From Columns To Rows

Oct 14, 2008

i have the following spreadsheet with dummy data however, there is a before and after scenario i have posted is this possible with a macro ...

View 9 Replies View Related

VBA Code To Extract Data And Remove Unwanted Data In Row

Dec 15, 2013

I have a workbook that has ben imported into excel and I need to extract the Cabinet sizes (red text) from ColumnC On Sheet2 leaving out the rest of the info. I have a button on the home sheet that has the code that I am running to generate this report it will do most of what I want but I am stuck at extracting the cabinet sizes.

The data is coming from the SheetComponetListing worksheet and going to Sheet2. I have manually created the end result that I am looking for on the CabinetSize worksheet. [URL]....

View 3 Replies View Related

Custom Data Presentation From Raw Data

Oct 2, 2013

Is there any add-in/tool that present data in a custom format?I have the following data:

A
B
C
D

1
Shipment
Driver
Customer
Order

2
S1
D1
C1
O1

[Code] .......

The desired output is:

Shipment
Driver

S1
D1

Customer
Order

[Code] ......

View 1 Replies View Related

How To Remove Data Connection But Preserve Data

Jul 24, 2013

If I run this vba it removes the external data connection to the pivot table:

ActiveWorkbook.Connections("EXAMPLE").Delete

When I attempt to drill down into the pivot table it states the data connection was removed.

Is there a way to remove the data connection but preserve the data in the pivot cache?

It's probably possible to store the data somewhere else in the document and link the pivot table up to it but that seems cumbersome.

View 4 Replies View Related

Macro Remove Custom Number Format

Apr 24, 2014

i am looking macro code to fixing value/number from custom number format (with dot mark criteria) as my data and will be as displayed fixing (what you see if what you get)....

2004.09.000907 (custom format) --------- 2004.09.000907 (after using macro)
1998.08.000001 (custom format)----------1998.08.000001 (after using macro)

if you press F2 in the sample number will be not visible dot (.) mark..

how to make/do that the number look like using custom number but fixed (remove custom number format)..

it's possible using macro?

View 2 Replies View Related

Custom Data Validation

May 11, 2009

I am trying to apply custom data validation for two cells. The first is data validation in cell B6. The only valid entries should be in mulitples of 100 (e.g. 100, 200, 300, .... etc). The second cell is B12. The only valid enteries should be any number above 100 and not = 100, 200, 300, .... etc). I tried using following formula in data validation for cell B6 but no luck. Couldn't figure out what to use for cell B12 =mod(B6,100)

View 5 Replies View Related

Custom Data Point

Apr 24, 2007

If I check the box labeled catagory name on the intial creation or within chart options on the right click menu each data point gets labeled with the name of the catagory.

I would like to label a significant event at one of these data points does anyone know how to do this? If this isn't a built in feature does anyone have a work around that would look good?

View 9 Replies View Related

Add/Remove Custom Control To Chart Drop-Down Menu

Sep 1, 2007

I want to add a control under Chart on the menu bar. This line of code errors with "Invalid Procedure Call or Argument"

With Application. CommandBars("Worksheet menu bar").Controls("Chart")

Change "Chart" to "File" or "Edit" or "Tools" and it's fine.

The Chart item only appears when a chart is selected, but it errors even when a chart on the worksheet is selected.

View 7 Replies View Related

Creating Custom Data Bar Format

Feb 11, 2014

I'm looking at what appears to be a custom chart. It is a box divided into 4 equal quadrants. In each quadrant is a percentage with the total equaling 100%. In each of the quadrants there is fill equal to the percent that is numerically written in that quadrant. I'll post a picture with this, but if I was talking cells then....

A1 = 15% B1 = 66%
A2 = 4% B2 = 15%

The backround image behind the number is filled up by volume equal to the percentage indicated. They are also color coded with red representing the highest percentage quadrant filled.

To top that, there are little arrows along the sides of each quadrant indicating an average score.

My first question is WHAT TYPE OF CHART IS THIS THING!, and second can this be done in excel?

View 4 Replies View Related

Get Data In Custom Range From Next Element?

Feb 18, 2014

I have a custom range I'll be copying from one sheet (a single entry registration form) that I'm adding to another (an "all entries" sheet) with a button assigned to a macro.

[Code].....

I then loop through the range, copying the cell from Sheet1 to Sheet2.

[Code]....

All works perfect, but I need to manipulate the data a little. If B3 from Sheet1 equals a certain string, I want to manipulate the data From Sheet1 B6 & B7 to paste into Sheet2 Column 1, otherwise paste B3 into Sheet2 Column1.

Again, my loop and everything works if I put B3 into Column1, B6 into Column2, and B7 into Column3, but it doesn't play well with the reporting I want to do later from this sheet.

Data Example

[Code]....

What I'm trying to do is
if B3 <> "NEW TEAM" then put B3 (Joe Smith on Sparkles) into the new sheet column1
if B3 = "NEW TEAM" then put "B6 on B7" (Jane Doe on Fluffy) into the new sheet in column1 (where B6 and B7 are the strings, obviously).

I haven't figured out how, in my loop, to access the data in (myCell + 1) and (myCell + 2) while I'm on the first cell (myCell). I could do it by jumping back to the Sheet1("B6") and Sheet1("B7") but I'm trying to write reusable code, and this range might change, so I'm trying to be a little more flexible than hard coding in more cells.

View 1 Replies View Related

Excel Custom Data Validation?

Jan 17, 2014

I am trying to use Excel to create some XML output that is formatted specifically for an application that I have. The application expects to receive time data for two columns in hh:mm format, i.e. no seconds. The standard Excel data validation and also the XML time data type all expect hh:mm:ss.

In order to get around this, I have used string as the data type and I want to use data validation to check the user input conforms to hh:mm. I can't see how to write the formula directly, nor how to apply the validation formula to an entire column (as opposed to named cells or ranges), and although I could write a function using regex, I still couldn't use this because all the examples I can find relate to checking a specific named cell.

View 3 Replies View Related

Custom List To Sort Data

May 28, 2014

I am having trouble finding info on this. I am trying to create a custom list to sort data.

I only want to sort two of the letters in my first Level or Column. For instance I want to sort Column A Alphabeticaly as A, B, C, D, but once I get to E, have the rest of the list in a random order that is sorted by my next level. Is there a wildcard character that can be used to have my next sorting level take over once I get to E?

View 4 Replies View Related

Create A Custom Data Entry Form

Jan 30, 2008

I am having trouble creating a custom data entry form in excel. What steps would I need to take..

Attached is a example of the data, the Headers are in bold, the highlighted columns are to be drop boxes.

View 11 Replies View Related

How To Display Custom Tooltips On Data Points

Jun 6, 2014

I have a line chart (multiple series) in which I am trying to display custom tooltips on the data points. The source for these custom tooltips are the Notes columns in the first worksheet. The code (which I've copied from an internet site) is working to some degree but I'm not sure how to modify it to pick up the notes column as the content for the tooltips. Also, the example I took this from only had one line whereas I will have 5 when the chart is complete.

View 6 Replies View Related

Automatic Custom Filter On Dynamic Data

Nov 27, 2008

I need a function/macro that will find all rows that have a specified value in column A and extract selected columns to a new spreadsheet. More, I need it to do it for every value in column A.

I would also like it to skip creation of new worksheet if value in selected row and column is null.*

I've been trying to combat this problem with advanced filters, which helped, but due to size of the data and range of values in column A it takes an entire day to process manually. Because the data is exported to another program after it's processed, it can't stay in the same sheet, also, linking back to the original sheet doesn't work because the data changes all the time.

View 4 Replies View Related

Custom Macro To Create New File From Data

Jun 12, 2009

I'm looking to create a new file from data in my table. I don't want to even imagine having to do this manually again...I'm optimistic there is a solution. All the data needed to create the file is in the table, but i need it stacked and organized in a weird way. It's almost to hard to explain...so I color coded an attachement that basically says it all. It's pretty much the same thing repeated over and over except the last 2 lines. It's just a really messed up organization. In the real version I need the new file in a new workbook. I'm extremely grateful to anyone who can automate this thing

View 2 Replies View Related

Custom Data Validation For Alphanumeric Entry

May 18, 2009

I require a custom formula for in cell data validation of an 5 digit alphanumeric entry. The valid format is ANNNN (1 x alpha & 4 x numeric). Case of the aplha is not an issue.

View 3 Replies View Related

Create Custom Data Validation (DD/MM/YYYY HH:MM)

Nov 12, 2013

I want to add some Data Validation for a cell and want it to validate that the entered data is in the format (DD/MM/YYYY HH:MM)

I guess I need to use a custom validation formula, however cant figure it out

View 1 Replies View Related

Using Custom Objects With Existing Data Structures

Mar 16, 2008

I have an Excel worksheet that contains many data structures, each one consisting of an array of cells, say a3:z13, a14:z24, a15:z25 etc. I can code a custom object to easily access the data in the structure but only after I load the structure into the custom object in memory. What I'm looking for is a way to assign the structure to a custom object for accessing without having to load the custom object. Again I maybe headed in the wrong direction, it may be easier just to hard code it.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved