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 already transfer my data from database (excel.xlsm) to an old worksheet (excel.xlsx) with a table by using VBA. Now I want to make this old worksheet become a new file with new file name like yyyy/mm/dd/where. Is that possible?
View 4 Replies View RelatedI 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 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 just wanted to know if there was a way to add the information contained within an excel form into an access database using a macro? What I am looking to do is automatically have the data added when I press a button, or when I close a worksheet.
View 14 Replies View RelatedI 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.
Are there any good website for a beginner on how to set up and store information in excel as a database? I have mutliple sheets that I use everyweek for payroll and I would like to store the previous weeks data in a seperate sheet so I dont have to save each weeks sheets.
View 9 Replies View RelatedI 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 Replies View RelatedI 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.
I'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 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.
I used to use Excel many many years ago for all my basic business databases and pivot table reports (so was at a basic competency level) and want to use it again but it has been quite a while and I can't remember how to do the following.....
I want to build a database of sales and purchase info in say 'sheet 1' - let's say 30 different headed columns and then many lines of different information under each column.
In 'sheet 2' I want to create an invoice template of my own design (I can do easily) for printing.
This template will need to extract say 10 bits of information from a particular row and then put them in a certain place on this sheet.
How can I type in one piece of information in a cell on sheet 2 (say the invoice or line number of the database) and that will then trigger all the other needed information from that particular line in sheet one onto this template?
I know it can be done but for life of me can not remember the formulas to use for these other cells in sheet 2 based on the info put in that one 'trigger' cell
transferring data from a worksheet (Passdown Report) to another worksheet (Data Base) located in the same workbook. In the source worksheet (Passdown Report) there are 2 cells (B2 and D2) in which I would like the data to be transferred along with the data from B4 to AQ33. All the cells contain a formula which I want to stay after the information is transferred to the target worksheet (Data Base). This will be a daily transfer to the target worksheet (Data Base), so the macros should also identify the next available open row to transfer the data to.
View 1 Replies View RelatedI receive a monthly download of individuals call-logs in one "Master File." For internal reasons, I need to separate every person's monthly call-log into individual worksheets. Unfortunately, the file is very large and copy/paste is very time consuming. I am operating on MS Excel 2007.
View 9 Replies View RelatedI would like to automatically update a 'yearly' database file with info from a file that is changed on a daily basis.
The daily file that i use has info like date, truck number, delivery stops, weight.
the database file has the similar headings.
at the end of each day this daily file is saved. I would like to have the info that is entered into the daily file automatically plugged into the yearly database file into the next available group of cells with respect to the salesperson.
This is kind of a generalization but i'm hoping to just get pointed in the right direction. If something like this involves vba then it will be beyond my ability and i'll have to do it manually, which is fine
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 3 worksheets- Sheet 1 and Sheet 2 will have data from the customer that I need to transfer in Sheet 3 as a summary. So if 5 rows are filled in Sheet 1 and 6 rows in sheet 2, VBA code that can transfer data from sheet 1 and sheet 2 to sheet 3 all one after other (i.e. have 11 rows total). The current code formula i have just replaces data that was filled in from sheet 1 to sheet 2.
View 7 Replies View RelatedHow can I move every row data to another sheet, when the print(moving) button will shown i every row. Problem is that i need write a code and insert button for every row, how to automate this proces. So the main key is that, i can chouse wich row i want to transfer to another sheet.
View 1 Replies View RelatedI have 71 checkboxes that I want to transfer the Checkbox Caption if true. If the checkbox is false I want to transfer a value of "0". The captions are being transferred to a different worksheet. Below are a few entries if I was to enter them all separately, but I assume there is a way to do all at once?
View 4 Replies View RelatedI have the following "if" statement
=IF('Audit Blank'!H53=2,SUM('Audit Blank'!I12:M12),"")
but it is not doing what i want and think i need some vba coding which i am not up to speed with. Basically i have an excel workbook containing a number of worksheets and what i want to do is enter data on the 1st worksheet which then populates the summed data into a second worksheet into a specific column dependant on the week no. that appears in a cell on the 1st worksheet. eg. the week number will appear in cell H53 the details in the sum of H12:L12 would then appear in cell I4 under the column heading Week 1 in the second worksheet, the sum of H13:L13 would then appear in cell I5 and so on. Where my "if" statement falls down is when the week number changes to "2" all the data under the column heading week 1 disappears but i need it to remain and the data for week 2 to be placed under the column heading week 2 in the second worksheet.
I'm having trouble with this macro I'm trying to write. I have a worksheet that's subtotaled like this:
Cash 100,000
Land 65,000
Equipment 104,000
Kroger Foods Total 269,000
Cash 200,000
Buildings 25,000
Equipment 25,000
Prepaid Rent 50,000
Whole Foods Total 300,000
The data is obviously just an example, but that's how it's set up (a subtotaled worksheet with three columns). My issue is that I need to write a macro to copy these numbers in column 2 (ex. land - $65,000) and paste them in a cell in another worksheet that finds the particular cell to paste it in based off column 1 and column 2.
For instance:
Cash Equipment Land Prepaid Rent
Whole Foods
Kroger
Essentially, I'm trying to find a way to copy the totals in column three and paste them into a cell in a certain row (based on column 1), and column (based on column 2). I'm pretty lost, and I just need some guidance as to how to tackle this. So far my code sets column 1 and 2 as strings and sets the columns in the second worksheet to these strings, and from there I'm lost
I Currently have some VBA sourced through here which adds to the end of the first instance of a value in column A the values in column's B and C and repeats adding values in new cells for B and C until the value in column A changes.
Now I need to transfer this sorted data to another worksheet (destination.xls) and add it by the reference number in column A to the end of the row with the same reference number.
I have experimented with vlookup with limited success and am looking for a more robust solution.
The data from the spreadsheet called source.xls appears starting in column EE. This will be the same starting position for all rows I have coloured the data for ease of recognition purposes only.
I have attached 2 sheets as examples of what I am trying to achieve.
My goal is to create a tracker for my work. This tracker would have the data collection in a seperate excel worksheet using forms (embedded), where all of the information initially goes, then with the click of an "Add" button, it formats the information in the cells in the appropriate worksheet (ie: good data goes to the worksheet called "Good" and vice versa for "Bad"), clearing the data from the forms, and preparing for the next bit of information.
Date
Time
Name
Notes
Type (2 radio buttons that categorize the )
Completed tasks (checkboxes stating "Did I do this", "Did I do that", etc.)
I have this worksheet (see attached file). what i want to ask is how to fill the HS CODE on Sheet 1 based on database ? can i use vlookup?? or there is another formula ?
MAPPING PIB NEW 2013 4.xls
I need a temporary database. What I need to do is to transfer data from each tab to a Masterfile tab. For example. I have Jan 1, Jan 2, Jan 3 tabs I need this to automatic transfer to Masterfile tab. I know I can copy/paste this BUT I have a LOT of data's like way back to June 2013 to present so I really need a way to do this easier.
View 6 Replies View RelatedI have a table with 150 or so Job Titles down the first column. Across the top row, I have 25 or so courses listed. There are Xs in the table indicating which courses are required for each job title.
This worksheet is intended to be used by individuals who will look up their job title to see which courses they must take. My goal is to simplify this process. I would like to create a worksheet in this workbook which has a drop down list of job titles. When the title is selected the data will transfer to a table on this new worksheet.
I've attached the spreadsheet I have and it's pretty self explanatory.
I have uploaded a worksheet that has a macro attached to button 4,
I want the macro to search the header in "All Data" worksheet and transfer the data under them to under the same headers in "Quote" worksheet.
The data in "All Data" could be upto 60 rows of data.
quote test 1.xlsx
I have a large data ... my problem is that I want the data is segregated automatically without manual filtering. in my data there are approximately 1000 individual name data, i need information about one person automatically segregated in one worksheet
A
B
C
D
[Code]....
for example; in the table we can see the red colour font in column D, that is the name person, what i want is data for one person automatically transfer to another sheet..example : Annamalai data to Sheet2, Koh Che Kuan to Sheet 3, Rashidah to Sheet 4..etc
I want to transfer the data of one worksheet (to be added everyday) to multiple sheets.
View 4 Replies View Related