Inputbox To Pull Over Information From Another Sheet To Be Reviewed
May 30, 2008
I am using an inputbox to pull over information from another sheet to be reviewed. The problem is that I can't get the cancel button to work. I am not having a problem with the ok button though.
Sub test()
Dim pull As String
pull = InputBox("How many would you like to retrieve.", "Retrieve", vbOKCancel)
If pull = vbOK Then
MsgBox "ok " & pull
Else
MsgBox "Cancel"
End If
End Sub
View 9 Replies
ADVERTISEMENT
May 26, 2006
I need a formula that will take info from sheet A column K only if sheet A
column E is equal to sheet B column E. I need it to paste into Sheet
B column K exactly as shown in sheet A column K.
I tried using a Vlookup formula but I got #N/A and I am not sure if that is
because there is text as opposed to numbers or if I am using the wrong
function entirely.
View 10 Replies
View Related
Mar 1, 2013
I am trying to create a summary sheet from the matrix to do further analysis. I want to pick out the welds done everyday with weld inches as you will see in the summary sheet. How can summary sheet be automatically updated when I enter the inspection date rather than copying and pasting? I can use vlookup to get the weld dia once I get the weld numbers on that date. I have attached the file.
View 3 Replies
View Related
Aug 17, 2007
I'm trying to do is create a macro that will autopopulate information from a source sheet. What I have is a different route sheet for 25 or so technicians within my company on one worksheet.
I want to be able to have a source sheet that I can change daily and have it autopopulate the information needed into the appropriate cells/sheets from this one source sheet.
I am pretty sure there is a way to do this, but I'm not familiar enough with creating macros to do this myself, although if I had an example of one cell and a simple explanation of how to fit this to the information needed I think I could do this on my own.
View 9 Replies
View Related
Apr 18, 2008
I have created a spread sheet that uses the LOOKUP function to pull information from elsewhere in the sheet and automatically fill in a cell so that I can save time.
The spreadsheet has several columns with a single word or number but the column used for the lookup contains 2 words, 1 number and a “#” sign. I have used the “CONCATENATE” function to create a column that has all the words, the number and symbol and then my formula says to LOOKUP the value in the created column and return the number associated with that LOOKUP value. The problem is it will not give me the correct value. All cells with the formula return a value from the same row in the LOOKUP table no matter what the LOOKUP value..
I have used this exact same formula (copied and pasted it) in another place in the table with the LOOKUP information added by hand, not generated with the “CONCATENATE” function, and it works fine.
View 9 Replies
View Related
Oct 5, 2012
I have spread sheet with 2 tabs (MASTER LIST & CYCLE COUNTS), on each tab I have 2 columns(LOCATION1 & DATE1 and LOCATION2 & DATE2) I need to verify if I any cell from LOCATION1 is repetead on LOCATION2 and copy the informacion from DATE2 to DATE1. then if I update the CYCLE COUNTS sheet I want the MASTER LIST update by it self.
This is the formula that Im using but Im having problems with the range..... =if('Master list'!$A2$:$A$15000='Cycle counts'!$A2:$A$15000, 'Cycle counts'$B&2:&B&15000,0)
View 1 Replies
View Related
Dec 9, 2009
I am trying to put together a macro to pull data from one tab to another. The key here is that I want it to take the entire row.
Basically it will look something like this:
As someone goes down the rows of the checklist putting x's in the boxes that need one (there is a column set aside for that), that box will turn red.
That part is easy and done.
What I cant figure out how to do next is to automatically have a copy made of the row with the red cell and send them to another document.
View 13 Replies
View Related
Jul 1, 2012
Any way to pull in information from a particular website directly to excel? For example if I have the URL or the specific web page can I then locate specific pieces of information that are contained in specific areas of the webpage and pull it into excel?
View 5 Replies
View Related
Jul 16, 2012
Is it possible to pull only certain information out of a cell?
I have in cell A1 (As of 6-30-12 and 5-31-12) i would like to put a formula in cell b1 to pull just (6-30-12 and 5-31-12) so that everything i change A1 B1 will also change.
View 4 Replies
View Related
Aug 12, 2009
I want to setup an excel spreadsheet that will list employees and when exams were completed on them. The exams need to be completed once a year. I want the excel spreadsheet to send out an email to their corresponding supervisors when is within one month or so of an exam needing to be completed so their exam can be scheduled accordingly.
I have searched this forum and read through some of the other posts regarding exporting data from excel to outlook. This seems like what I need to do but I wanted to see if anyone has an advice on what way is better than the other?
Also, if excel is setup to push the data to outlook, does the excel file need to be open? In other words if Jimmy comes within one month of his exam but no one opens the excel file will it send out the email to outlook?
Is it a better option/ or possibility to have Outlook pull/check to see if the condition exists where an employee is within a month of his exam and then let the supervisor know?
View 2 Replies
View Related
Dec 9, 2009
I'm using a v-lookup to pull information from one worksheet to another. I know that each of the cells has a match on the second sheet, but the calcuation is resulting in a Value Not Available error. The only way I've figured out to get past the error is to go into each cell, hit F2 and then enter.
View 2 Replies
View Related
Apr 26, 2012
I need building a formula to pull information from a database file. The purpose is to try to interpret the data so that I can analyze a time period along with it's content. I don't know how best to explain it. Basically I have a table and I want it to pull information based on 3 criteria: time, type, and total. I would like for the formula to identify a time frame, then identify a type, and then take the totals and add them together.
Time / Type / Total
11:31 /1 / 4
11:43 / 1 / 6
12:04 / 2 / 1
12:31 / 1 / 3
Time / Type / Total
11:30 - 12:00 / 1 / 10
12:00 - 12:30 / 1 / 3
The top is the database and the bottom is basically what I want to happen on the other table. Pretend the / and dividers for each column.
View 9 Replies
View Related
Jul 30, 2014
OK,I have a spreadsheet that prints receiving labels based on received purchase orders that pulls information from an SQL server. The problem is that it is pulling almost 40,000 lines of data to sort and pull at most 30 lines. One of steps is that the purchase order receipt register has a barcode that is scanned into a text box on a userform. Can I use this information to filter the SQL data pull to only grab that PO number? I'm at a loss on where to begin with this. Below is my SQL statement from the Query builder with an example of a PO number input(PO-rma100613).
[Code] ....
View 5 Replies
View Related
Jul 1, 2008
how to reference cells in 1 page from another and understand basic formula's, and would appreciate any input on how or if i can acheive what i'm trying to accomplish.
I have a worksheet with say 100 rows of information, it is a list of materials to go into a construction job. the columns to the right of the description calculate volume/quantity etc and produce a cost for the item. what i want to do is have a summary page that only lists the items that are being used, not all 100 items are in every job and i dont want to have to print the whole list with a bunch of empty values, which will just waste paper and ink. I'd like to enter a value in a cell or setup a check box or something that i could somehow use to then list that row or a part of that row of information on a seperate sheet, for a nice concise, easy to read list of job materials. i would like to do produce 1 sheet with the cost associated with the item, and one without cost.
View 9 Replies
View Related
Oct 24, 2008
I need to be able to pull information from a "master database" into seperate worksheets. Here is my problem. When I use a vlookup and my identifer is say "office property" then the vlookup will only pull the first "office property" and not retrieve any of the remaining "office property" rows.
View 9 Replies
View Related
Feb 11, 2010
I have created a userform that allows input of information and then deposits the information on a specific sheet. I am looking for a way to have that information not only deposited on the specific sheet it is already set to but also to another sheet based on a selection made from a combo box.
here is my current
View 5 Replies
View Related
Apr 6, 2013
Basically I am trying to create a worksheet in which everytime I input information into Sheet 1, it is copied into Sheet 2. I want to have each entry in succession on Sheet 2 such that my first entry would be on Row 2, second on Row 3, third on Row 4, etc. However, everytime I put something new in Sheet 1, it just overrides the information in Sheet 2.
Basically I type in ticket sales in sheet 1, it calculates the prices and keeps a transaction log in sheet 2. But everytime I do a new ticket sale, it just overwrites the previous transaction witht he new transaction information. I've pasted my VBA below:
Sheet 1 VBA:
Code:
Option Explicit
'Form level variables - used in more than one event
Dim intAdult As Integer
Dim intStudentSenior As Integer
Dim intBalcony As Integer
Dim intChild As Integer
Dim sngAmountDue As Single
[Code] .......
Sheet 2 code:
Private Sub cmdSummary_Click()
'Declare Variables
Dim intCount As Integer
Dim i As Integer
Dim intAdult As Integer
Dim intStudentSenior As Integer
[Code] ......
View 3 Replies
View Related
Jun 30, 2009
I have the inputbox so i can set a string value,
When the inputbox Cancle button is pressed i want to exit sub,
If the inputbox value is nothink and ok button, I want the msgbox displayed then goto newname.
If the inputbox has a value do >>>>>>That>>>>>
View 6 Replies
View Related
Jun 5, 2014
i have a close workbook with path ("Z:42766Jan 2 Dec 2014Tally.ERP9GrpSum.xls") from another open workbook i want to popup a inputbox to select the sheet and run the macro on selected sheet.
e.g
i put 2 in inputbox than run the macro on sheet2
View 2 Replies
View Related
Oct 14, 2008
I have a quick question that'll hopefully have a quick answer. Part of my workbook requires an input box to appear. When you type the name of one of the worksheets into the box and hit enter I want a VLOOKUP formula I've written to compare to that worksheet. Heres what I mean, with some descriptions of what i would like:
View 8 Replies
View Related
Sep 10, 2008
I am having some trouble conceptualizing how to write code for the following situation: When the macro starts, the user types in a job title into the box and the macro then searches for this value throughout the whole worksheet. I want to return a msgbox that says if the job title was found and if so, what the cell address is and for that to be stored in a variable. If the job title is not found, then I want to return a msgbox that says the job title was not found.
View 2 Replies
View Related
Mar 4, 2010
I created with code to copy a template, hide that template, and pop up a box to rename the copy, I noticed she clicked "Cancel" on the InputBox. When she did, she received an error (400). What I would like to do is when the "Cancel" button is clicked, the newly created copy would be deleted. Is this possible?
Here is the code for my full "Create New Project" sheet procedure:
Sub CreateNewProject()
'This code will copy the Project Data sheet, hide it and then
'rename the new copy to the MSA number. Code also prompts user for
'MSA Number and fills that in on the form.
Dim RenameSheet As String
Dim oSheet As Worksheet
With Sheets("Project Data")
.Visible = -1
.Copy After:=Sheets("FHWA Quarterly Report")
End With...............
View 9 Replies
View Related
Aug 28, 2013
I want vba code to pull data from two sheet in workbook, code has to pull all data from first sheet , then pull data from second sheet and paste some particular column only below first column sheet
e.g i pull data from two sheet(ONSITE&CCI)
SHEET-1ONSITE CONTAINS HAVE 57 COLUMN
SHEET-2 CCI CONTAINS ONLY 19 COLUMN
FIRST I PULL 57 COLUMN DATA ONCE FINISH MOVE TO SECOND SHEET CCI CONTAINS 19 COLUMN BUT ITS HAS TO PASTE DATA BELOW DATA OF ONSITE TO PARTICULAR ASSIGNED COLUMN'S ONLY BUT COLUMN NAMES IN BOTH SHEET IS TOTALLY DIFFERENT
View 1 Replies
View Related
Sep 13, 2012
I need a Macro which pulls the data from different sheets of excel (which is not formatted properly) to Main Sheet. Also some of the columns will not have the same names, so macro should handle this exception as well.
View 8 Replies
View Related
Jul 31, 2009
I have an excel workbook with two sheets. Sheet 1 has a list of people names, rank, address, and phone numbers. Sheet 2 has boxes where a user can select a last name from all last names in sheet1. What I want to happen after the user selects the last name in sheet 2 is for it to automatically fill in the rest of the data (ie Rank, First Name, Address, city, Home phone number, Cell Phone number). What do I need to do in order for this to work?. Attached is a very small example of my much larger project.
View 3 Replies
View Related
Jan 26, 2009
I need to create a macro that will scan a spreadsheet for the number of sheets and then pull data from the same places on each sheet in order to create a summary sheet. Let me try to explain a little better.
The spreadsheet I'm working with has a separate sheet for each new deal our company makes. Each of these sheets is in the same format - we use a template and fill in the data based on that whenever a new deal emerges. The sheets contain basic info about the deal in the first few rows and columns, then some narratives with dates describing the progress of the deal, and then a list of issues and whether or not they have been resolved. The problem is, each of these sheets contains too much info for a quick, high-level overview with the bosses so they've asked me to create something that will pull the basic info, the most recent narrative, and any unresolved issues from each sheet. This way, each time there's an overview scheduled with the bosses, the macro can be run and it will create a new sheet with data from each sheet in the workbook.
View 9 Replies
View Related
May 14, 2014
I'm trying to get the data from Receipt log (sheet 1) to automatically populate into the Print Receipt (sheet 2) and to automatically filter and go to the Activity by account (sheet 3). I am so new to this and totally lost.
See attached sample : Student fees.xlsm
View 12 Replies
View Related
May 14, 2014
What I have is a sheet that is copied periodically from some source sheet, and on this sheet is a table. This sheet is called "Onsite Checklist Template" and it's table is titled "Checklist". I also have another sheet called "Loggers and Initial Notes" which has a tabled titled "Record", and then finally a title sheet call "Proj Details".
To clear this intro up - The sheets, in their order, is: "Proj Details", "Loggers and Initial Notes", "Onsite Checklist Template". The tables: "Record" on "Loggers..." and "Checklist" on "Onsite..."
When the user wants to make a new site visit, he/she fills in the requested date and then selects a button on "Proj...". When this button is selected, it copies the table data on "Record" and puts it on "Checklist", then inserts a new worksheet tab, always in the 3rd position (the title is based on the site visit date in which the user entered), which is a copy of "Onsite...". Now we have another sheet with a table called "Checklist1", and upon another new site visit, there will be another worksheet with "Checklist2", and so on.
On the "Onsite..." worksheet, there is a button on it which also gets copied with the worksheet so that every new worksheet has this copied "Checklist ???" and this button. I'm looking for a macro that, when the button is selected, will bounce the active sheet's table "Checklist ???" off of "Record" and make changes as needed.
"Checklist ???" data range is B11:M20 (the header is on row 10); "Record" data range is B29:Q78 (the header is on row 28); Column headers are titled the same, just that "Record" has 4 extra columns, 3 in the middle and 1 on the end. "Checklist ???" columns 1-12 to "Record" columns 1-7, 10-12, 14-15. The search criteria is the 4th column in both tables ("Trk #").
I need the macro to do the following:If it finds a match, then update "Record" as needed with data from "Checklist ???", changing whatever cell is different in the row that contains the matching "Trk #", so long as the cell on "Checklist ???" is populated (i.e, if a cell on the target row of "Record" has a value, but it's blank on "Checklist ???", then "Record" wins; if it's blank on "Record", but populated on "Checklist ???", the Checklist wins. If both populated but different, then Checklist wins.If a "Trk #" exists on "Checklist ???" but is not on "Record" then add the line to "Record" (the 1st empty row, table size remains)I see no need for any "delete" at this time.
My concerns: The last column on record (column #16) is the filtering column for the worksheet copy event and needs to be left alone (it's formulated to produce a "Yes" or "No")I would like the ability to adjust table sizes if needed without modifying the macroThe table rows on "Checklist ???" will not be changed, deleted, or altered in any way by the macro.
View 2 Replies
View Related
Jun 1, 2009
I've got a bit of a quandary here that my novice programming skills can't seem to solve.
Here is the scenario. I work for a photographic library. We have a spreadsheet that contains 5 or so columns, and a couple of thousand rows. Essentially each row contains an imagine code (the number we use to file away the imagine, ie. US_NY_NYC_1 ) in the first cell, and the image information in the following cells (ie metadata, keywords, photographer, date, etc).
so a typical row would look as follows:
Filename | Keywords | Photographer | Metadata | Location |
all the keyword, photographer, metadata, and location information can only be tied to the one image code whose cell begins the row.
Now, here is my dilemma. This sheet (lets call it the master sheet) contains all the images we have in a given batch. However, when a client orders images, we will send them most images in that batch, but not all, and we may send a few additional. So I have a separate sheet that contains only those image codes that the client requested. What I need to do is essentially take a code from the second sheet, find that same code in the master sheet, and copy over all the cells associated with that code's row. If the number does not exist in the master sheet, simply leave that row with only the code in the first cell, and the rest blank, and move on.
so for example, in my second sheet lets say I have the following A_B_C . I would like for excel to find that same code in the master sheet, and then copy over the metadata, photographer, date, etc, associated with that code, and paste it into the second sheet, so that that row in the second sheet now looks identical to the row with the same image code in the master sheet . If A_B_C does not exist in the master spreadsheet, then I would like excel to simply leave that code in its own row, leave the rest of the row blank, and move on to the next code.
View 12 Replies
View Related
May 4, 2013
Create a macro button in 'Spreadsheet 2' that searches 'Spreadsheet 1' for updated information specific to a certain criteria and adds it to a new row in 'Spreadsheet 2.'
There are three sheets
Prospects (where all original data is entered)
Actions -Bob (Bob's new Prospects are added to this sheet)
Actions -Frank (Frank's new Prospects are added to this sheet)
So in this example Row 6 in Prospects (Constituents, Rating, Manager and Solicitor would be added to ACTION - Bob's sheet on Row 5
and
Row 8 in Prospects (Constituents, its Rating, Manager and Solicitor would be added to ACTIONS - Frank sheet on Row 5
Here is the example spreadsheet - Prospects and Actions.xlsx
View 3 Replies
View Related
