I've just been asked to do a new Quality Control project for my boss. What I'm looking to do is be able to input the thickness values of our product in one worksheet, and have it recorded in another, as well as have the data separated by the model number
The main problem I'm having is figuring out how to enter data in the 1 worksheet as a template, and have the data consecutively stored, one after the other
Are there any functions that will allow me to do this?
What I am looking to do is pull all the data of clients with assets under $2million into another tab. How can I do this without copying and pasting? I am looking for either a macro or some kind of formula that will search the entire data dump and pull in just the clients I need without leaving any rows blank.
It is a small program for learning new words of a foreign language. By means of a userform one can add new words to the program which will be stored on a sheet called "data" each new data entry will get a subsequent number.
On the main-sheet "werkblad" one can by giving 2 numbers from between which to collect the data retrieve the words they want to learn.
For example. If on the mainsheet in cell B3 the number 3 will be entered and in cell C3 the number 12, only those words will be shown with a number between 3 and 12.
However sometimes I would like these words to show up in randomized order. So I made a new collumn on the "data" sheet with the following formula =rand() and sorted it, but unfortunately the formulas on the "werkblad"-sheet don't present the given numbers [3 till 12] in randomized order.
The formula I use for collecting the data from the "data"-sheet is the following:
As per attached sheet, I have the date distributed in two three cell and want to transfer data to single cell. I don't know which formula has to use to collect it together.
I have several sheets which give me results, e.g. "dummy1", "dummy3" and "dummy5" out of a list of all possible dummies 1 to 10. It is possible that there are any number of "dummy5" (or any other dummy) outcomes.
I just want Excel to make a list of all the possible outcomes.
In this case, I want Excel to make a List that says: "dummy1" "dummy3" "dummy5"
This means Excel shall search the respective Columns and just check, is this dummy there or is it not.
I'm inputting data in E3 and after I hit enter I want B2 to be selected. But only for E3 and only in one worksheet. And possibly a further step... Sometimes the formula in B2 has picked up data from another place depending on what value was entered in E3. If it's done this then I won't need to go to B2, I'd want to go to A8 after E3 instead of B2.
I need a code to select sheets with pages less than 15 to print out. Also, a code to print out just the first 5 and last 5 pages if its more than 15 pages.
I've tried this so far but no success:
For X = 1 To Worksheets.Count
If Y Is Nothing Then Set Y = Sheets(X) Else If ExecuteExcel4Macro("Get.Document(50)") < 10 Then Set Y = Union(Y, Sheets(X))
i have wordlists which i would like to enhance through texts. For that purpose i need a macro which reads a text and splitts it into words and put the words into three columns. Lets assume the column where the words are supposed to be put is columns A,C and E. The column A should contain single words containing no spaces from Text, column C should contain compound words which have one space between them and in column E those compounds which have two spaces. Now i will put my existing wordlist in column G before i start splitting texts. The macro should put only those words from text into column A,C and E which dont already exist in columns A,B,C,D,E,F and G. In Column B i will place the corrected or checked words from column A. In column D i will type the corrections and checked versions of those compunds existing in column C. And the column F will contain the compound words which are corrected and checked from Column E.
Column A--> single words splitted from text through macro (containing no spaces) Column B--> corrected and checked versions of words from column A through user Column C--> compound words containing one space splitted from text through macro (for example:"etwas möchten" or "do something") Column D-->corrected version of C through user Column E-->compound words containing two space splitted from text through macro (for example:"sich uerberzeugen lassen" or "down in dumps") Column F-->corrected E Column G--> existing dictionary wordlist through user
Signes like ".", ":",";", "/" or quotation signe itself should be seen as seperator. And the words or compounds splitted from the text should not contain these signs.
The text will be put in another sheet in the same excel file. Lets call that sheet "text". The macro should search for words through whole sheet ignoring empty cells or columns.
None of the columns should be filtered or ordered. The columns shound not be deleted as well. That way the user wont have to correct the same word each time cus the corrected as well as the original words will be there.
A thread with similar purpose was made sent by AdamDay as well, where rylo has posted a good solution already.
I gather two lists of serial numbers (i.e.) from two different sources; one populated in sheet1, A:A (with variable row numbers) and the other in sheet2 B:B (again with varying number of rows)
I am trying to gather a master list of unique serial numbers in sheet3, C:C.
So far I have tried advanced filter, union.range, etc. but couldn't figure work it. I guess some of these columns need to have names assigned to it and have a header.
I would like to create a menu representing "tasks" where an amount of "time" can be designated per option for my employees to select and fill. I would like this information to then be tallied elsewhere so I can keep track of our efficiency.
So far, I've created a table where a "time" input is nested beside each "task" drop down menu, I would like these inputs to be added up underneath the same category on the budget tab.
For example: If I work Monday, Tuesday and Wednesday doing tiling.. I would like the budget to reflect those accumulated hours (throughout the week) nested under "tiling".
Here's the file, what I'm trying to accomplish [URL] ............
I have a question to ask, and not sure what you would call it. I am looking to input a 'Check Box' into a cell so you could have for example... two (2) choices - Yes - No - you would have an empty circle in front of each, and you select the one (1) you wish which would make it filled.
Is there a way to do this in excel? If there is, could someone possibly turn me in the right direction (or assistance) with inputting this?
I discovered this sample database sheet (attached) on the forum I wanted to ask if a picture can be linked included? i.e. when entering a new record a picture (stored in a directory) can be added and linked to that record. Then when reviewing the records the picture is then displayed.
I have some code that works fine below. It deletes an entire row based on the value in column J.
Ideally I would like to give the user the option to choose which column to base the deletion on. i.e. some kind of drop down box or input parameter where they could choose a different column "A", "B", "C" etc...
Private Sub CommandButton1_Click() 'Removes values less than 0 Dim rng As Range, cell As Range, del As Range Set rng = Intersect(Range("J1:J1000"), ActiveSheet.UsedRange) For Each cell In rng If (cell.Value)
I have a sheet with a number of different columns, is there a way that when data is input into a cell in the first column that it time stamps the last column on the same row, and this time stamp is fixed. Then when data is input into the cell below the same thing happens, so i can have a time stamp for each entry.
I have a worksheet with 500 rows. Coulmn A is all the dates of the items. Is it possible to somehow havea userform or something that I input a start date and a finish date and it only shows me that info.?
i m making a very small calculator. It's a little hard to describe, but I need to look like the following Let's say the individual got here on 1 Jan
Phase 1 is for days 1-14 last for 14 days Phase 2 is for Day 15-35 last for 21 days Phase 3 is day 36+
This is what I need it to look like: All the phase information will compute automatically after inputting the date arrived. In addition I would also like to be able to change one of the phase dates and the remainder of the phases compensate according to the newly entered date.
Date Arrived = 01 Jan 09 Phase 1 = 01jan09 Phase 2 = 04Feb09 Phase 3 = 05 Feb09
i have 1 - 9 number buttons, the +, - , * , / , and a C for clear, as well as an exit button. the display is a label. i have to click add after inputting the digits just to have it added to he variable, which i just add up at the end... terrible.
Option Compare Database Option Explicit Dim var1 As String Dim var2 As String Dim first As String Dim second As String Dim sign As String ' on load Private Sub form_load() Form.Caption = "this calculator lab sucks." Me.lbDisplay.Caption = "" End Sub ' on clear Private Sub cmdClear_Click() Me.lbDisplay.Caption = "" var1 = "" var2 = "" End Sub.............
I am looking for Macro code preferably to get list of dates with Saturday / Sunday in a separate columns which falls Saturday and Sunday on imputing the year.
Excel 2007. At the bottom of a column of data I'm trying to reference the cell $AG4. There are 340 total columns. Each additional column to the right needs to reference the next cell in column AG. So I'm trying to drag and copy horizontally from $AG4 to $AG340. When I try just the single column it just copies $AG4 into everything to the right. When I have to columns ($AG4 and $AG5) and grab both to try to copy horizontally the numbers increasing it just does $AG4, $AG5, $AG4, $AG5, etc.
Is it possible to create a drop down menu where additional information can be added then tallied up in a separate table?
I would like to create a menu representing "tasks" where an amount of "time" can be designated per menu for my employees to select and fill. I would like this information to then be tallied elsewhere so I can keep track of our efficiency.
I've attached the excel file to give a better idea of what I'm trying to accomplish.
I have a worksheet in which i am asking a user to enter manually a number in cell E3. Suppose the user starts with 100, then the next time he is entering in E3 he shoudnt be able to enter 100 nor any number less than 100. I dont have a range for the numbers that the user is going to enter.Therefore countif function does not work. Is there any way that i an store the number taht the user enters first in cell E3 and then use that database to avoid the user from entering the same or a number lesser than that number.????
I'm trying to create an array formula that returns all the cities in a given state by imputing the state's abb in cell K2. The returned cities go into column J. California has the most cities(430) and the cities are 5000 rows deep.
