I have a worksheet, with a "cost" column, and a date column. I have another sheet with dates pre-written, and a cost column as well. I'd like to know how to make the cost from worksheet 1 go to worksheet 2 under cost, but also add up any costs that are on the same date.
View 9 RepliesI am currently working on a workbook to have employees fill in data on what tasks they compelted for the day, and how long it took. There are 5 colums (for this purpose) Task, Description, Time, Required to complete, Completed. The tasks are predefined and listed out in each row. There is also a space for employees to select the date they are entering the data for.
I would like to have a macro that is linked to a submit button and when pressed populates this data into a database on another sheet. This database is split into two sheets (1 with time and one with tasks required/compelted). Each sheet has the list of tasks going down a cloum on the left, and dates along a row on the top. When the employee presses submit I would like this data to popuplate in the coresponding date and task fields and then reset the form on sheet 1 to all 0's.
Attached is an example of what I am trying to do.
I am looking to transfer the sums for a calendar month in one column to cells in another location for each month.
I put some notes in the sample attached, I appreicate any help getting this to work.
I need to create a simple code that will allow me to fill out the userform and then use a cmdbtn within the userform to transfer the information from the userform to specific cell in my excel spreadsheet.
I am putting together a register of information and it is broken up over a number of sheets i.e. LOG1, LOG2 etc.
I have a master sheet in which I want information to automatically populate based on whether a certain column has the words yes or no.
Ie Column I in LOG1 or LOG2 etc can either be yes or no. Is there a way to populate the Master sheet only with the information of a row in which column I is yes?
I know it would have to be a formula in the master sheet which checks all the sheets and then somehow populates the master sheet downwards if anything is yes but then removes it once that yes becomes a no....
I am trying to create a formula that will change the cell color in a range of cells in the row. I want the color to change based on the information in a particular cell appearing on a different sheet. What sheet the information is on determines the color the cells change to.
Example: I have 4 sheets I am working with. We will call them A; B; C; and D. I would like the color of cells A5-I5 on sheet D to change to red when the information in cell A5 from Sheet D shows up in any cell in column A on sheet A. If the information from cell A5 sheet D appears in any cell in column A from Sheet B then the color will be yellow, etc.
Solve this issue for transfer value from master sheet ( Daily Report) to corresponding sheet and add value according to its Date. E.g. :
Master Sheet : Daily Report
Manpower : 35
I want to transfer the value of manpower to sheet ( D_manpower) and insert value 35 to according to month & date ( C5 & G5) shown in master sheet ( Daily Report )
Like this all data need to insert according to its corresponding sheet according to month and date
File attached : Report 2014.xlsx
I'm trying to get values to transfer from one cell to another based on whether the date in an adjacent cell is equivalent to the current date or not. I've tried using "Now" and "Date", but can only get my code to respond if the two are "<" or ">", I'm basically looking for a response for "=".
View 2 Replies View RelatedWhat 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.
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.
I have a spreadsheet where raw data is entered ("RAW_DATA") for each month it is collected. There are 7 questions that are tallied and each of those responses are transfered to a separate data table for analysis (7 individual tabs within the spreadsheet). I'm currently manually data entering the values from the raw data tab to the other seven tabs.
I would like to have VBA code that could transfer the data from one month ("RAW_DATA") onto the other 7 tabs based on the date and facility identified in the raw data tab. I have not attempted the VBA since I do not know where to start with searching on two variables.
I have a workbook which contains information that I would like to transfer to a new spreadsheet.
If column I (in the exsisting workbook) contains the words 'New Business' I would like the entire row (all values) to transfer to the new spreadsheet. I need the information from the entire workbook (containing 12 worksheets) to transfer over to the new spreadsheet if column I states 'New Business'.
I have tried many things, most recently VLOOKUP, but with no luck at all.
I understand that a macro is the best option, however my excel skills are nowhere near advanced enough to know where to begin
I hope someone can help me with this, Ive attached a copy of an example spreadsheet that has the same requirement i need for another one i am creating.
Sheet 1 has the user input area, where the user enters the data they want stored.
All i need is to be able to transfer the data into the correct area on the grid on sheet 3,
I have a Sheet1 that contains 900 rows of information 14 columns wide (C7:P7 are headers). Column M has an important date. The information is constantly changing.
On Sheet2, I want to display the upcoming dates, in numerical order for each row that's within 5 days of today's date. After the date has passed, it no longer needs to display on Sheet2.
I'm trying to find the coding to be able to do the following.
If Manufacture = Dimond in Cell C3 then in C5 show list from database Worksheet, of A4-A9, if C3= Steel & Tube then show list for A13-A18
Cell C3 is a Data Validation List
I keep getting name errors etc.
I have a list of names on a spreadsheet (tab 1). First name in column "A" and last name in column "B". The number of names is an unspecified amount. The number can and will change as I put in new names. On another Tab(2) in the spreadsheet I have another list of names. First name in column "A" and last name in column "B". The number is an unspecified amount that will not be the same number of names that are on the first tab(1). I need to compare the names in the 2 tabs. I need all the names from tab one that are not on tab two to be on tab 3 with all of the corresponding informtion that is on tab 1.
View 1 Replies View RelatedI have filled up my ComboBox1 with the sheets I want to add information to. My problem now is how to place the info in the correct sheet when I click CommandButton1.
I've been working on this for a few hours now. I got this to work on the first code I found but it didn't work afterward. I just deleted the whole thing and started again.
I have a file with the following columns:
ID Number - Name - Email - Comments
Is there a way that for each row and email is sent with the ID number, name and comments?
I want to make things easier for myself when filling in my worksheets by having certain cells autofill based on a product number.
So I have my main worksheet and I have my product information sheet. When I type in the product number in cell 13C, I want it to auto fill cell 13B with the product name which is located in collumn A on the product info sheet, but dependent upon that product number. Collumn B in my product info sheet has all of the product numbers. From there I would need 13G on my main worksheet to fill in with Collumn D from the product sheet, but again dependent upon that product number.
There are more that need to fill yet, but I can figure out what to do once I have a starting point with the above I believe.
I have a userform with many textboxes that I am using to collect data which is transferred to a worksheet using a command button on the userform. All data is correctly transferred to the worksheet except for the text box I am using for the date.
The date is transferred from the userform to the spreadsheet but the date is left justified implying that it is text but dates that I have manually entered into the spreadsheet cell are right justified. This may seem picky but I am using a 'count' function within the spreadsheet to determine how many rows contain the date.
I am using the following code which I am entering in the format of dd/mm/yyyy, to to transfer the date to Cell A1 the worksheet 'Results'.
Private Sub CommandButton1_Click()
Worksheets("Results").Cells(1, 1) = UserForm1.Textbox1
End Sub
how to transfer the date to the cell so that it right justified, hence treated as a number within the cell.
Currently have
Code:
ThisWorkbook.Sheets("Sheet1").Range("B8:G8").Copy
Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial Paste:=xlPasteValues
B8 contains a date and on sheet2 i have lots of columns, what i was wondering is If I had lots of Tabs Jan Feb Mar etc would it be possible to transfer the Cells B8:G8 to the tab based on B8
i.e. =if(month(Sheet1!B8)=1, copy B8:G8 and paste in 1st available row on the Jan Tab
or =if(month(Sheet1!B8)=2, copy B8:G8 and paste in 1st available row on the Feb Tab
What I have is an output of about 30 worksheets of individual stock data in a workbook, all with the same column headings, laid out like the following (so that the Column Headings are stock data as recorded on the Date in Column A):
<Stock Name>
<Date> <Price> <Price to Book> <etc.>
with the stock titles also as the names of the worksheet.
What I want to do is create a macro that outputs to a single worksheet where I can input the stock name and a certain date for the stock, and then have it insert the appropriate row from the stock's worksheet underneath.
So, if I say I want the data for Stock A on March 24, 2007, I can input those two and have it output the appropriate rows from the worksheet.
Or, more generally, I can create a list of stock names and dates, and have the macro output that data underneath.
I am trying to auto format some merged cells within a sheet based on the information in them. how to reference the information within theses cells?
View 5 Replies View RelatedI'm trying to get certain Excel cells (varies by column and row) to populate different areas in a Word document. I've tried using both Word bookmarks and form fields and have defined the Excel names with the Word bookmark names as well as using Word's generic terms (Field1, Field2, etc.) with no luck. The VBA code I'm using now is for word forms and will open the Word document but seems to delete the form fields. I don't know if I'm not coding the cells correctly or what.
Sub CreateProposal()
Dim wdApp As Word.Application
Dim wdDoc As Word.Document
Set wdApp = CreateObject("Word.Application")
' Open word document
[Code] ........
I am wanting to transfer data from one sheet to another depending on cell input
Example:
If I enter "2" in sheet1 cell B1, then I want a macro to take A1 to sheet2 but place it in A1 & A2.
Then say I enter "1" in sheet1 cell B2 goto sheet2 and put A2 into A3 and so on.
Depending on the number entered on sheet1 column B, the Macro duplicates the info from Column A in that row into column A on sheet2. ??
I have a workbook with several sheets containing prices of products. One column has the product number and a second column has the price. We just received new prices. Can a macro read the product number from the new sheet, find the same product number on the old workbook and transfer the new price. and than change the price so I know it was updated.
View 2 Replies View RelatedI thought I had finished my project but I keep getting errors, the latest one being that I have 2 comboboxes on userform "timekeeping". When I press the commandbutton "Submit", I want the values in the textboxes on that form to be placed in the spreadsheet, depending on what the selections the user has made in the comboboxes but I keep getting an error saying that the macro doesnot exist in the workbook even though it does!
The file is too big to upload here so it is found on rapidshare
[url]
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
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] ......
I have excel from windows 8 and I am trying to copy the information on one cell on a sheet to multiple sheets. I tried the click on one tab hold shift and click on the last tab and type the information or press F2 or paste the information. Well, nothing works.
View 5 Replies View Related