Transferring Cost From One Sheet To Another
Feb 24, 2009
I am trying to figure out how to update cost from a manufacturers price sheet in excel. I have one worksheet that has the manufacturer's part number and my current cost. A=item number B= current cost. on the second sheet is the same setup but my price list has roughly 3500 rows and the vendor price sheet is 23000 rows. Is there a way to automate the cost replacement by comparing item number and if they are the same replacing cost on sheet one with cost on sheet two?
View 6 Replies
ADVERTISEMENT
Feb 20, 2009
The job cost controller is not exactly what I need, so I have been trying to create my own. So far my progress has got me to be able to separate each laborer for each job.
Here is my query: I have a drop down menu that lists ten different tasks(i.e. carpentry, painting, demo, etc.) and I want each of the ten tasks to separate themselves. Is this a vlookup function? How do I make excel listen?
View 9 Replies
View Related
Mar 15, 2013
So I have a spreadsheet with a list of item codes and a subsequent excel sheet with corresponding item codes. I would like to match up the item codes and enter everything found between column E to L.
View 3 Replies
View Related
Dec 17, 2009
I wanted to : when i write data on one cell (sheet A), i want to see the same i wrote into another cell (sheet B), thts very simple, i know, but when its in blank (Sheet A), in sheet B appears a zero.
I dont want to have zero, i want to remain blank as in sheet A.
i did in sheet B "='sheet A'!A117".
i am a noob in VBA, just beginning, and i am loving....
View 9 Replies
View Related
Sep 7, 2009
I'm entering some sales data on a worksheet named 'Sales'. Some items are sold on a 'sale or return' basis, and others are not.
What I would like to do is to have all items that are sold on a sale or return basis copied automatically into another worksheet named 'Sale or Return', along with some other data related to that sale. The data transferred would have to be: Date, Agent, Item, Units, Date of return. I would like the data to be transfered into consecutive rows in the 'Sale or Return' sheet. After some Googling I'm vaguely aware this may have something to do with VLOOKUP.
The challenge I'm having is that there may be one sale or return entry for every ten rows of data on 'Sales' yet I would like them to appear consecutively in 'Sale or Return'.
View 9 Replies
View Related
Jan 24, 2009
I need to calculate data from one sheet 'Promotions' and paste/drag the formula onto the 'Summary Sheet'.
The paste/drag is important to include all data.
Trying to multiply [on sheet Promotions] 'NumberOfPromos' times (*) 'ProfitPerOffer' (using rows 1-8, let's say).
Then paste/drag it in its place on the 'Summary Sheet' in the 'Total Receipts' column.
I've been playing with =Promotions!$E$2:$E$8 * $J$2:$J$8 = 'Summary Sheet'!$F2
and things but cannot get it to work (I know I am WAY off base).
I've been working with Access and trying to duplicate a simple database in Excel.
Attaching a simple project example.
View 10 Replies
View Related
Jun 19, 2013
I have a database that has been created in Excel.
It has columns such as Permit #, Permit Date, Project Name, Contact Name.
I have to call on each of these projects, and I am trying to create a Lead Sheet that will make it much easier as opposed to having to go to the database, and handwrite the information into a lead sheet.
Such as there being one lead sheet per project. That way, I can just use the lead sheets as opposed to using the excel database.
I've seen it done with excel and word used together where each heading (permit #, permit date, etc.) was copied into a lead sheet essentially doing all of the writing for me automatically.
View 4 Replies
View Related
Jul 17, 2013
We have database (attached here). I want to copy the name of candidates base on their Status to their designated tab. example Diana Longoria name will be copy to "Waiting" Tab and if I change the status to "Rejected" it will be copied to "Rejected" tab and remove name from "Waiting" tab.
View 12 Replies
View Related
Jan 15, 2014
I'm not sure that this is possible without VBA, but here goes.. My sample workbook has 3 sheets. 'Master' Sheet A contains fields that are to be completed manually as our sales people talk to prospective customers. Once that information has been input, I'm trying to find a way to have the contact information (columns B - L) to copy automatically to either (in this example) to sheets B or C depending upon the chosen category in Column A, Sheet A. An example is that the sales adviser inputs the information into sheet A and then gives each row of information a category, say B, which then copies the required fields into Sheet B, at the next available row.
View 4 Replies
View Related
Feb 27, 2014
I have a user form set up and the codes to transfer the data. However, when I select to transfer, the transfer happens ok but I am getting the following error message
"Could not set the value property. Type Mismatch"
When I "debug" the code is highlighted
View 4 Replies
View Related
Apr 8, 2009
I am attaching a workbook with two sheets 'PO' & 'Quote'
The data in Quote is not in right order. I need a macro to put the data in PO in appropriate fields. I am interested only in Unit, Unit Price, Par Description, part no. if any otherwise blank.
View 7 Replies
View Related
Sep 8, 2009
I need some sort of function which will automatically retrieve task data from one sheet and place under a heading in another based upon the month selected. But the complication to this is that i need is that i require the tasks project heading to be retrieved aswell.
View 14 Replies
View Related
Nov 29, 2011
Any way to transfer the sheet protection from one worksheet to another worksheet via VBA.
Currently, the user selects a name from a drop down list, it unhides a workbook of the same name, copies from that workbook, and places the copied information in an area of the sheet with the drop down list. I would like the protection settings (in this case, selectivly unlocked cells to allow users to easily tab through and not make changes to data that should not be changed) to be copied with this information. Is this possible?
View 2 Replies
View Related
Nov 28, 2012
I am looking for the formula to auto copy data from Sheet 1 into Sheet 2 should it meet certain criteria. In this case the criteria would simply be a student name. I am looking to have different sheets automatically transfer different student's data to other sheets.
For example:
I have a first name column, last name column, and then 3 questions answered in sheet 1.
In sheet 2 I want it to look for any row with Daniel as the first name for example and copy his data over to sheet 2.
Is this possible?
Is it possible to transfer this data to a SEPARATE excel document? Just another sheet in the same document? Or not at all?
I am also running into an issue with google forms. I am trying to auto transfer incoming data from the google from spreadsheet into Sheet 2 automatically where I have it set up to auto sort the data the way I want. But the formula I am using is not auto updating as new data is added to the form sheet.
View 6 Replies
View Related
Jan 30, 2014
Looking for the formula needed to transfer data from one tab to another just by adding a meal count. On the attached file for example:
When I add a meal count in D1 on the Fry Prep Board I would like column B to populate with the associated columns from the Fry Pars.
I just need the formula for one cell and I should be able to complete the rest, I believe it would be a VLOOKUP formula?
View 3 Replies
View Related
Sep 21, 2009
I'm loving these new formulas that i'm learning here and applying them to whatever sheets i come across to make my life easier at work...
So now i've created another worksheet, this one is to help my colleague who wastes atleast an hour everyday to generate a consolidated report of our bank accounts...
Now i've sorted out half of the report where he can give an overview of the position of cash flow on a daily basis.
Theres however 1 more addition i wanted to make to make this workbook absolutely perfect!
On sheet 2 (which is my consolidated report sheet) I want to add all the transactions that occur on a particular date from all the different bank accounts (Each account having a seperate worksheet)
I'm not sure if advanced filters can achieve this or not or even easier/short macros... Any tips/hints as to how i can achieve this would be awsome..
I've attached a sample workbook which has sheet1 for a bank account and sheet2 for report generation...
I want to add all the rows having "Clearing date" (column A) in Sheet1 to report date in Sheet2
..And this for all the account sheets i can add...
View 10 Replies
View Related
May 25, 2006
I am trying to find an automatic way to create a finished report format that draws information from a different sheet within the same workbook. The trouble I'm running into is:
The raw data consists of some lines without any data, and some lines with data. The purpose of the final report is to display only those rows with data in them.
I have a sample spreadsheet attached, with the first sheet containing raw data, and the second containing a rough Idea of what I'd like the final infomation to look like. Somehow this seems like it should be really simple, maybe doable with an if statement, but I can't figure out how to get it to just ignore the empty rows without skipping a row in the final doc.
View 2 Replies
View Related
Dec 27, 2012
it has been eye opening to say the least. I have a question however, I am in the process of creating a workbook of different things for my construction company and I am stuck. Is there a way that I can pull a cost code from a drop down and have whatever data is inputted into the cell to the right automatically transfered to a budget report (another sheet)? Example - Inputting time for my crews - select a code from the drop down list say for "concrete" Then I input the crews hours per day in subsequent columns and then sum it up at the final column. Can the sum of the hours worked doing "concrete" then automatically be transposed to the budget in the "concrete" section?
View 9 Replies
View Related
Mar 8, 2013
Currently I have 15 Prepaid schedule sheets that get pulled together as lines in a detail sheet. The way I have the detail sheet set up currently is that I have designated 200 rows for each prepaid schedule sheet, and then I manually changed the sheet reference in the formulas every 200 lines or so, for each prepaid schedule account. One such formula looks like this:
=IF(OR(H11="",H11=0),"",IF(OR(LEFT('Prepaid Gnrl Ins'!A11,8)="Balances",'Prepaid Gnrl Ins'!A11="Variance"),"",CONCATENATE('Prepaid Gnrl Ins'!A11," - ",'Prepaid Gnrl Ins'!B11," - For month ending ",TEXT(Menu!$I$4,"mm/dd/yy"))))
The result of that formula is this: Beecher Carlson - 11/1/11 - 4/1/13 - For month ending 02/28/2013
The detail sheet also includes a formula to find values to be expensed. that formula is:
=IFERROR(IF(HLOOKUP(Menu!$I$4,'Prepaid Gnrl Ins'!$I$10:$T$110,A11,FALSE)=0,"",IF(F11="","",HLOOKUP(Menu!$I$4,'Prepaid Gnrl Ins'!$I$10:$T$110,A11,FALSE))),"")
I'm trying to shrink down the over all size of this detail sheet and I would like to be able to write code with the syntax:
IF {HLOOKUP of value in menu sheet, find in column 10 of active sheet and offset by 1 (row 11)} contains a value THEN run all formulas (examples above) and paste into detail page UNTIL value in column A contains "Balances".
After finding the word "Balances" the macro would move on to the next prepaid sheet and do the same thing.
View 1 Replies
View Related
Jun 18, 2014
I have tried to make a sheet which has
Resource, Task, Rate (I'd like this to be on another sheet, as there is a lot of repetition) Also, right now the columns for hours are based on weeks, but i'd like to do it by days and then collapse by weeks, and months and get totals by weeks and months too. Then, I'd like to multiply the rate by the hours to find the total number of hours, however the way it is done right now is not very intelligent and very time consuming when creating the formula, which looks something like this :
=SUM(H4*$C$4,H5*$C$5,H6*$C$6,H8*$C$8,H9*$C$9,H10*$C$10,H11*$C$11,H13*$C$13,H14*$C$14,H15*$C$15,H16*$C$16)
what can be done to make this a bit better?
View 2 Replies
View Related
Aug 18, 2014
Excel (2007) user however I'm not very well versed with VBAs and Macros.
I have three sheets and on each sheet the first 5 columns (A - E) have the same title (all in row 1, frozen top row and with filters) there are other columns but I only need A -E to auto transfer.
Sheet 1 is named "Total"
Sheet 2 is named "Management Referral"
Sheet 3 is named "Health Assessments"
What I'd like is for any entry that goes into any row in both sheet 2 and 3 to automatically transfer to sheet 1, but only the information from columns A - E.
There will be dates (dd/mm/yyyy) in column A in each sheet and when transferred to sheet 1 they must be listed chronologically oldest to newest.
I also need all the information in columns A - E that transfer to sheet 1 to stay in their respective sheets.
View 3 Replies
View Related
Oct 18, 2012
I have 3 forms(3 sheets) with the same layout (fields) for data collection. I want to transfer the data from the 3 forms to a consolidated database worksheet. Every form needs to have its own rows of data. For example, if there are three forms for three divisions laid out as below:
BegBal Additions Subtractions Adjustments End Bal
xxxx xxxx xxxx xxxx xxxx
The resulting database worksheet should look as follows:
Division Beg Bal Additions Subtractions Adjustments End Bal
A xxxx xxxx xxxx xxxx xxxx
B xxxx xxxx xxxx xxxx xxxx
C xxxx xxxx xxxx xxxx xxxx
Sub MoveRecord()
Dim WSF1 As Worksheet ' Form 1 worksheet
Dim WSF2 As Worksheet ' Form 2 worksheet
Dim WSF3 As Worksheet ' Form 3 worksheet
[Code].....
View 2 Replies
View Related
Apr 23, 2007
I am writing a UserForm and only one of my comboboxes is correctly outputting to the assigned worksheet. All of the textboxes, radio buttons, and checkboxes are working properly. It is my first time designing a UserForm. Attached is the code - maybe someone can see the error that is allowing only cboq4d to be transferred to the worksheet (named DataBase).
Private Sub cmdClear_Click()
Call UserForm_Initialize
End Sub
Private Sub cmdOK_Click()
Call UserForm_Initialize
ActiveWorkbook.Sheets("DataBase").Activate
Range("A1").Select
Do
If IsEmpty(ActiveCell) = False Then
ActiveCell.Offset(1, 0).Select................
View 3 Replies
View Related
Mar 15, 2007
In a financial environment we have a calculator which uses iteration to allow for a cost being added to loan amount where the cost is based on the total loan amount. Iteration is set to 100 iterations with max change .001
On one PC the first time the calculator is opened it gives a particular (incorrect) result. If the input cells are cleared and the data re-entered, it gives the correct result. This only happens on one particular PC. Is there some other setting , other than the iteration setting, that would cause this?
View 5 Replies
View Related
Jul 8, 2014
I am currently dealing with an excel sheet that I am using to track people that I have contacted over the phone.
I created a drop down box for a column titled "Contacted". Under this drop down I have included: "Yes" - I reached them; "YES/CB" - I reached them, but need to call back; "NO/LVM" - I did not reach them, but I left a voicemail; and "NO/NVM" - I did not reach them and I was unable to leave a voicemail.
My goal is to have several Sheets in this 1 workbook.
Question: How do I get the WHOLE row of data to transferred to a new sheet(s) depending on the selection I make, i.e. "Yes/CB" or "NO/NVM" ??? Make note: I would like the data to disappear from the original sheet when it is transferred to its new home.
View 14 Replies
View Related
Oct 25, 2007
I'm trying to make a worksheet where I can calculate the cost of a mobile postpaid subscription. It is charged per minute and the cost differs depending on which of the 2 available networks the customer is calling to. The first 20 minutes are free, not depending on network.
Edit:
Charges to network A is 1,79,- per minute after the first 20 minutes are spent.
Charges to network B is 2,29,- per minute after the first 20 minutes are spent.
To sum up:
1. The customer makes a call.
2. If there there are available free minutes, these should be spent first.
3. The customer is charged per minute, depending on network called.
View 14 Replies
View Related
Apr 17, 2009
Problem - billing spreadsheet for prisoner fee.
1 - 8 hrs = $55
9 - 24 hrs = $55 + $65 or $120
Anything over 24 hrs - $65 for each additional (24 hrs) ($185)
So if you were locked up for 6 hrs it is $55. If you were locked up for 18 hrs it is $120. If you were locked up for 28 hrs it is $185. And if you were locked up for 49 hrs it is $250. Cell F5 contains number of hours locked up - I would like cell I5 to calculate the cost of the stay. I am proud of myself for figuring out the date and time subtraction - but this part has me stumped.
View 5 Replies
View Related
Mar 6, 2014
I have an excel table that among other fields it has a [product Charge] field.. what im trying to do is to get a cost per row based on the [Product Charge] field.. so example if I have 10,000 rows and the total for that field is 1,000,000 the cost should be 100 ( [Product Charge] / total rows).... I then want to be able to use it in a pivot table...
View 1 Replies
View Related
Aug 3, 2009
im working on a VoIP company, and having a hard time to figure out a result on a little time.
the problem is finding a "least cost routing" wherein you will find the cheaper to higher price, and putting the results on a designated columns:
I am including an image, sorry if the image seems to be heavy and large:
as you can see: Column C contains the sale rate for the client, while Columns D to I, are the buy rates from our source carriers.
While the columns K to P, are the columns where should one source carrier should be fitted base on the buy rates, that is best fitted to the sale rate.
Red marks=are not suitable or non-profitable buy rate for the sale rate.
Sorry for the bad english, but i hope you get what i mean. this is only a sample from our Internal data.
View 9 Replies
View Related
Jan 25, 2009
I'm wondering how to display the following cost model on a graph (this is a piecewise-linear cost model for some production company):
Cost per unit for 0-10 units: $1
Cost per unit for 11-20 units: $3
Cost per unit for 21-30 units: $5
Cost per unit for 31-40 units: $8
Fixed cost: $100 (this is regardless of the number of units produced)
Basically I'm looking to construct a cost vs units graph.
View 11 Replies
View Related
