I have a workbook that contains a sheet where I record income and a sheet where I record expenses.
My goal is is to have the infomation that I record on these sheets automatically be filled in on the next available row on the Bank Account sheet.
I have an example workbook attached. It is color coded with an explanation at the top of the Income sheet.
I have 2 sheets, A & B. When I type something into sheet A, it goes to Sheet B, but if I change the cell color on Sheet A, I would like that to automatically color the same thing in Sheet B. How can I do this?
View 4 Replies View RelatedI'm trying to figure out how to create a database on Sheet 2 by filling in the info in a template created on Sheet 1. I have seen it done with the addition of a button within the Excel sheet itself, and you simply click it to send your information to the database page. I am thinking it is along the lines of OLAP or recording macros
View 8 Replies View RelatedI'm looking to build a macro which will automatically transfer a line of text from one worksheet to another within the same workbook. Once the macro has been run, the text in the original sheet should disappear and re-appear in the other worksheet. It should appear in the same column, but different line from the original.
i need a little help. I have a workbook with 2 sheets. I need rows to transfer to the first sheet automatcily if the record dose not already exsist on the first sheet based on if a vaule in a certin cell is below a certin number.
View 9 Replies View RelatedI work for an insulation company and we have all of our jobs, completed and in progress, on a master worksheet.
Currently there are 437 rows of data (but will increase), and columns A to N with various bits of data.
Row A is a location field - there are 5 locations currently.
I would like to be able to add a new line at the bottom of the master sheet, and then this automatically identifies the location from column A and which worksheet is it to be copied to and then copies the data from that new row to the bottom of the relevant location sheet.
I would also like to be able to update the data in the existing entries (e.g. when a job has been assessed initially, and then completed, I need to put the dates in) and for this to update on the relevant worksheet.
Each worksheet has the same format (columns A to N have the same headings in row 1, then data to begin in row 2).
I wouldn't say I'm an advanced Excel user (otherwise I wouldn't be asking this question), but I do have a fairly good working knowledge of it. Currently using Excel 2010. Would ideally like to be able to do it without VBA as it needs to be uploaded to Google Docs and for others in the company to access online.
I am trying to automatically transfer data from nonadjacent cells (C1, B5,B10,B16,B22,B28) from multiple workbooks in a masterworkbook folder from A2:F2. I am a novice at VBA. I am not able to copy as Range("C1,B5,B10,B16,B22,B28") and the way it currently is coded only the last copied range (B28) is pasted to the master workbook. The data pastes to A2 in the master workbook instead of F2 where I want it. I need copying the cells from the workbooks into row 2 in the master bookbook. Here is what I currently have:
Sub LoopThroughDirectory()
Dim MyFile As String
Dim erow
MyFile = Dir("C:ToolFolderWorkObjectives")
[Code].....
I remember years ago that I made a couple formulas that on sheet one would transfer to another sheet when I enter in sheet one.
View 5 Replies View RelatedI would like to take the data from worksheet1 and put into worksheet2 but limit the length of a list (the real spread sheet has over 100 rows and i would like them in 4 sets of 25 versus the example I provided). Is there an array or macro that would make this work (keeping the formatting)..
Excel 2007
B
C
3
Name
Company
[Code].....
Once a job is complete on a sales tracking sheet I created, it needs to transfer automatically once I click on a "completed" section of my work sheet.
View 1 Replies View Relatedin my worksheet if i have in any cell of clomun k eg.rnage (k1:k50) the word "fail" i want to transfer all of the data in this row to the fist empty row =to the end of the used rows
I have an excel sheet that contains different values in data cells for example: A10, A22, A45 etc.
I want to have a button which when clicked, should create a word document from a template and the values at these cells should go into the template file. Thats it.
So say when the button is clicked, the newly created document should be something like this:
The award goes to Mr. Value in cell A10 living at Value at cell A22 of amount Value at A45
I have an attached workbook, and looking to find out how I can copy from one sheet to another.
What I'm looking to do is this,
On Sheet StaffRota I want to take the Name, Service, Date, Days, and then Start & Finish and copy onto the ExportRota Sheet as shown.
How would this be possible?
I am wanting a macro that will open an existing workbook (book2) and transfer information from the already open spreadsheet (book1) to the newly opened one.
So far I have
Code:
Sub email_sheet_and_save()
'ChDir "\sbscompanyfolder1"
' Workbooks.Open Filename:="\sbscompanyfolder1QUOTE LOG.xls"
Dim iRow As Long
[Code] ....
I cannot figure out the code to make the actual transfer eg cell C2 on book1 should transfer to (irow, 1) of book2.
Need Code to transfer text from a textbox to the next available row in a sheet. The sheet does not have a name as its populated at the same time you click the add button
View 9 Replies View RelatedI have a spread with five tabs. Each tab is a person's job responsibilties for numerous properties. Each person works with a property called Orange Avenue. I want to create a tab for JUST Orange Avenue items but want it to automatically pull any and all info from each tab where that person's Ornage Avenue duties are.
cells(a,b):cells(a+4,b) have 1,9,9,0,5
cells(a,b+3):clells(a+4,b+3) have 1,9,0,emtpy,empty.
how to fill 9,5 to empty cells.
I am trying to transfer information for the 'Master CCO CCB Document List' tab into one of the other tabs ('In Progress' and 'Complete') based off of the status. If the status is Complete, Approved, Declined will transfer to the 'Complete (Approved or Declined)' Tab. If the status says 'On Hold, Pending, 1st & 2nd Session Review needed will transfer to the 'In Progress (On Hold-Pending)' Tab.
I want the master list to house all of the entries, so when the status changes it is just copied to the other sheet and not cut and pasted.
On the 'In Progress' tab, once the status changes to Complete, Approved or Declined I would like for the item to be cut and pasted into the 'Complete' tab,
I'm stumped and really not sure if this will work properly. I've tried everything and now I can''t figure out how to add the contents from the form to the master list tab.
I'm trying to convert this code so it transfers the data without the input box being needed.
Dim response As Long
Dim strLastRow As String
Dim rngC As Range
Dim strToFind As Variant, FirstAddress As String
Dim wSht As Worksheet
Dim rngtest As String
Application.ScreenUpdating = False
Set wSht = Worksheets("Transfer Sheet")
strToFind = Application.InputBox("Enter Your Initials")
If strToFind = False Or strToFind = "" Then Exit Sub
With ActiveSheet.Range("H2:H5000")
Set rngC = .Find(what:=strToFind, LookAt:=xlWhole)
If Not rngC Is Nothing Then
FirstAddress = rngC.Address
Do
strLastRow = Worksheets("Transfer Sheet").Range("A" & Rows.Count).End(xlUp).Row + 1
rngC.EntireRow.Copy wSht.Cells(strLastRow, 1)
Set rngC = .FindNext(rngC)
Loop While Not rngC Is Nothing And rngC.Address <> FirstAddress
End If
End With
Im trying to take information and have it copy to a different worsheet when a certain selection or type is put into a column.
Example:
On worksheet "Alpha"...
Column "A" will have "Maintenance, Supplies, or Payroll" in it.
Column "B" will have a currency.
On Worksheet "Bravo"...
I would like to have everything from Column "B" on "Alpha" to be placed here that has "Maintenance" in Column "A"
On Worksheet "Charlie"...
I would like to have everything from Column "B" on "Alpha" to be placed here that has "Supplies" in Column "A"
Etc...
I have to workbooks and I want to populate one of them with data from the other. The receiving document has the fields Account and SubAccount which I need to match up with the account and subaccounts in the other workbook.
However, in the other workbook, the line looks like "1000 Wages 000001" (which is account, name, subaccount). I can't find out how to have my receiving document scanning the providing document and when it finds an account and subaccount (in the above string) that matches the account and subaccount in the receiving document, to bring over the data.
If i have a basic formula that reads a6=(a2*a3*a4)/a5
i need a5 to be entered as one value but be equal to another. Such as 12=6530 and 10=10380 ...
From the attached spreadsheet I need to transfer all the rows where the issue status in column T is either ongoing or open. Now I know how to transfer them over if row 1,2,3 etc was going into row 1,2,3 etc into the new spreadsheet but as not all rows from this sheet is going over I need to now how to transfer data so in the new spreadsheet it just follows down rather than have spaces in it. i.e. if on this sheet I need to transfer data from rows 1, 5, 10, 15 on the new one they go into row 1,2,3,etc
View 7 Replies View RelatedThere’s one “master table”. Two columns in master table are titled “Name-1” and “Name-2”, and all columns in front of it carry “Properties” corresponding to these names.
In a “second” table, when we choose/type the Name-1 and Name-2, corresponding properties should automatically be picked up from the master table. Is that possible?
Is there a way to transfer an Excel table into Microsoft Word and tilt its orientation.
For eg, if I have a long table in Excel that is probably in 'Landscape' mode, can I move the table into Word and tilt it to 'Portrait' mode?
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 have a sheet with 1250 data. All are in Column "A" I want to print them out and therefore would like the data also in Column "B" and "D" in order to save printing paper and make it easier to search. Since the data is alphabetical sorted, doing it manually is a big job.
View 6 Replies View RelatedI am trying to transfer a set of values from a column on sheet1 into cells on sheet2. Sheet2 contains labels I made up so the cells I want the values transferred to are not in column format. Is there a way to write a formula so that it will transfer the values indirectly? By indirectly I mean that I want sheet1 a1 to go to sheet2 a1 then I want sheet1 a2 to go to sheet2 a32.
View 5 Replies View RelatedI have a new spreadsheet that I made to give us the break down of each invoice we create. what we want is to see each job that is done (by code), the amount we charge per each, the cost of goods per each, and the profit margin. In this spreadsheet I have two tabs. in tab one it has the form I made that has a place to input the data that will change with each invoice as well as a section that is broken down into columns. In these columns I have it listed this way. CA=Job code, CB=Job Description, CC=how many, CD=Charge ea., CE=rate total, CF=COGS ea., CG= COGS total, CH=profit
I have the formula done for all of the math the get the totals. My idea was to make a second tab. In tab 2 I have everything listed in columns that will go into tab one. It is broken down like this. CA=Job Code list, CB=Job Description list, CC= charge ea. CD= COGS ea.
What I want to be able to do is when I type in the job code in the first cell under the column A on tab one, it will bring over all of the info from tab 2 and put it in the right spot for that code. So if I typed in say TT001 in that cell it would bring over the description matching that code and put it in the cell under B, along with the charge in column D, and the COGS under column F. And I want it to be that way for each code I type in and it will be different each time I fill this out. How do I explain this part? Ok so I a new invoice made its # 22. I take this spread sheet and do what I want and get all the totals so I print it out. I then want to be able to clear all the info and or just type in a new set of codes that will be on invoice # 23 and then #24 etc.
So what I am saying is the codes will be different each time I fill it out. that's why I have them listed on a different tab and will just put them in tab one long enough to get the total and print it out. Is that clear as mud? I will stop here and wait and see what questions I get back.
I am setting up a few spreadsheets for a restaurant I work at and I am stuck on an excel matter. I am trying to have an ordered number transfer to a new spreadsheet that will apply that ordered amount to a monetary value. So all my cooks would do is put the prep list on dropbox and it would take the ordered amount by the recipe cost to get an invoice for that day.
Example:
1st Sheet 2nd Sheet 3rd Sheet
Prep List: Recipe Costings: Daily Invoice:
Sausage - 2 x Batch Sausage - $229.03 $458.06
Pesto - 3 x Batch Pesto - $74.04 $222.12
