I have a `master` listing that has a list of material on it.
Lets call it test.xls
Each employee has their own work work-book with only one sheet inside the work book, lets call this test1.xls
I want users to be able to add information in test1.xls and the list test.xls automatically gets updated
I am working on Excel 2010. I want to find a way to link data from one spreadsheet to another one and whenever I update the first spreadsheet, the second one will be automatically updated?
View 2 Replies View Relatedi have 1000 lines of criteria (being updated all the time)
i have say 10 or so different jobs
i need a summary of values that is automatically updated for each job on another worksheet for a report
1) for example i have two files Master.xls and client.xls , when ever the client.xls updated with values the master should automatically updated by the same values.
If i use the link concept , once the user delete the row then master file also automatically updated. So here i want to restrict the permissions to master file.
how can we do that ?
2 - Macros) I like to filter the data as per the column value. In case of less numbers we can hardcode the values for filter criteria. (by declaring an array variable and assigning the values to the array)
But if the values are very high how can we get assign the criteria dynamically ?
I have a worksheet in my Excel wookbook that references particular cells from another sheet. I use a simple macro to alter the values in some of these cells, but for some utterly bizzare reason, the cells referencing them are not updated. The only way to update the cells is to click on the cell and press Enter!
I've never had this problem before.
Does anyone know why this is, or perhaps know of a line of VBA code that updates every cell on a particular worksheet.
I have a spreadsheet where vehicle milage is entered at the end of each month. On another sheet I have the vehicle fleet numbers and the the months along the top. What I need to happen is; when the mileage cell is updated I need the cell in the other sheet to be automatically populated, when the mileage is updated the next month I need the next cell(February)to be populated with the new milage and so on. The aim is to calculate monthly milage for each vehicle without having to enter the date at the beginning and end of the month.
Everyone I work with is completely computer illiterate and only knows how to enter the data the same way they always have(just the once at the end of the month) changing it up will only cause issues.
I am very new to using excel and I need connecting the information between two sheets. I have a weekly schedule that I want to use for my employees. I want that information to automatically be moved to a daily schedule. I need to be able to see how many openers closers and mid-shifts I have and how many hours I am consuming from my budget. I want the shifts from the schedule to be moved to the daily schedules in order in chronological order (morning shifts first, then mid-day/closers). If at all possible how I would like to have the span of their shift to be highlighted in the cells on the daily schedule.I will attach what I have so far to provide as much info as possible.
example.xlsx
way to generate automated email whenever excel file is updated by any one.
View 14 Replies View RelatedI use 2010 and I will try and I need to complete a relatively simple project that I am working on.
I have a range of cells, "D7:Q30". This range has numerical values that are updated automatically (every cell within the range has a numerical value) from an "old value" to a "new value". The refresh rate is not constant, that is the values may change at any time depending on when a value changes I think it is called "pushed" data. Once a value is updated ("new value"), it stays at that value until one of the updates changes its value (and then it becomes the "old value").
I would like a message box to display the following EACH TIME A CELL CHANGES ITS VALUE when the NEW updated value is LESS THAN the OLD value:
"B51, B52, **5, has a changed value from "old value" to "new value".
The ** above in the message box represents the following: If for example cell F23 changes, ** in the message box should be the value that is in cell F5. If Q10 changes, the ** value in the message box should be Q5. It will always be the value in Row5 but have a different column depending on where the change is detected.
B51 is the text value in B51..same for B52 (text) etc...these values change depending on what spreadsheet I have open, but will always be in those cell positions. But the values within the range D7:Q30 are always numeric.
I want to create a communication excel sheet. I want it in such a way that if any one of the team member make update and save the file, then the whole team should receive an email that the file has been updated.
View 9 Replies View RelatedI have created a spreadsheet that displays new dates in column D based on provided dates in Column B and recurrence intervals selected in column C. The dates in column D are when a training deadline occurs. I have been trying to get a macros written so that when a cell in column d is updated, an outlook appointment message is sent to the person doing the updating. The idea here is that anyone can use this without future coding (so their address would be placed in cell say A1)
So far all i have gotten is excel to send an email to me with the excel spreadsheet as an attachment, not really what I want. Again, I dont want somethign specific to my computer settings, I want to be able to send the spreadsheet out with simple instructions for the user to change their email in cell A1 and then every time a cell changes in column D, it automatically generate an appointment reminder for the new date.
I have a spreadsheet with several tabs. I am wanting to lookup data in tab "A" based on data in a list. For example:
I may have:
Tab A
Tab B
Tab C
Tab D
Tab E
I have created a validation list containing A, B C, D, E I would like to use Hlookup to look up data imported into the table in Date order.
just wanted to know of how to quickly link cells and columns from one cell to the next without using the equals function because i have about 75 individual sheets to do.
so there is a master sheet which includes operators name and #
i would like for one person to key in numbers into that master sheet ("ENTRIES")
everytime that individual enters info into that sheet, i would like it to be entered into sheet "#1"
retrieving data from financial website databases like yahoofinance.com and bloomberg.com. I'm trying to make an automatic stock analysis model to read from the website database and retrieve the data into excel sheets. For example, when opening the excel model the user gets a popup to enter the stock ticker, the user enters the ticker and gets a set of data. Is this do-able in excel?
View 2 Replies View Relatedi have a long list of what were once file names in excel that i need to retrieve data from. i have attached an example file with 2 file names which i recomend to view while reading this request.the file has 2 spreadsheets. the first one is just the file name in the format in which i recieve it. the second one is a table that i need to fill out from the data in those file names.
i have a problem with the following columns in spreadsheet 2:
1. column C: i have the command to copy the site name as it is to this column, but what i need is for the program to read if the site name is ZANUAH or ADORA and then write only Z or A. note that these two site names have a different number of charecters in them.
2. columnd D: similar problem. i need it to read the lab name and write AL if its MAGAMA, BA if its Ben-Ari and SH if its shafir. i have the command for excel to simply copy the word, but how do i make it write the letters that represent the lab name rather than the lab name itself?
3. column E: the report number is the 6 digit number in the file name. i have the command which retrieves it, but it has trouble when the length of the number changes. its important to note that sometimes the number might contain non-numerical characters like 219641-1.
4. column O:i have the command to get the data from the parentheses next to PSD in the file name into a box. what i need is to get it to copy just the letters C or NC from the file name into this column, without the number.
5. column P: same as column O, but here i need just the number, without the C or NC.
6. column T: all i need is for it to copy the last 2 letters from the file name, which i know how to do. the problem is that since the file names come with a .pdf at the end, all i get is df. so in fact i need it to copy th 6th and the 5th letters from the end of the file name, which is above my abilities.
I am trying to get the data out of a cell and put it in a textbox in my userform.
What I have is a Worksheet that has autofilter on. After the user clicks certain objectbuttons, there is only one row, that has data in it, displayed. The cell I'm after will always be in column A and be the second visible row.
I have a fairly simple matrix table that im needing help in which way to retrieve the information correctly.
Starting in row 10...
My Column A has length that i want to return
My Column B has a minimum value that i need A2 to be larger than, say 20
My Column C has a maximum value that i need A2 to be smaller than.
My Columns C & D, E & F, G & H and so on then have different sizes also available... but thats for me to work out later.
Is the best way to achieve this with a series of If statements as Vlookup only returns values to the right, and i want the value on the left, or what is my best way of tackling this problem.
I can attach a sheet that i started if the above makes no sense but my formula is useless so far...
I have the following in Column A. 01. Artist - Title
I manage to put 01 in Column B and Title in Column D
I am struggling to split between the "." and the "-" to show Artist in Column C
I am using in Column B
I want to be able to choose a country from a drop-down list, and then have the spreadsheet retrieve/return values from that country, whose input data is located in a different worksheet. E.g. I want to be able to change the input according to what country I am looking at. I was able to do this with simple IF functions,but I'm realizing that this is not good enough. I want to eventually expand the number of countries that I want to return data from, and then the formula is not dynamic enough.
Example spreadsheet attached.
To make it simple: I want to be able to return the correct values for "page views" and "high" and "low" according to what country I choose from the drop-down menu in cell C3 on the "value calculator" sheet.
Also; in cell N15 and N16 I want the alternatives to be yes and no, and they cannot be yes at the same time. H
I'm trying to retrieve data from a workbook that is currently closed. The formula below works only if the workbook containing the data is open. Is there a way to use the following formula to retrieve the data from a closed workbook?
[Code] ......
I am trying to work out a forumla that will bring through data onto a worksheet for teacher analysis. The data is being extracted from our MIS and put into the attached template. When I change the class on the analysis sheet I want to be able to the pull through the relevant learners attached to the class along with their data.
View 5 Replies View RelatedI'm trying to create a automated calculator that i can customize and adjust. start and what functions should i be using. I've looked into Vlookup/Hlookup and it does not seem the function i need to make the workbook work. Basically what I need is when I enter a item on the A column excel would retrieve the list of Ingredients to the calculator worksheet and multiply it by the amount of variable entered. Then product will be printed and added together to the "sum row".
View 14 Replies View RelatedI have a googlespreadsheet with 4 columns. date, id, name, positive/negative.
What I would like to be able to do is to call a procedure from an excel document to copy/retrieve all of the information between specified dates on the google spreadsheet and place into another worksheet in the excel document.
The spreadsheet is hosted in my googledrive and is confidential (i.e. I cannot publish it), so I am assuming I will need to add password credentials into the code, which will be an added complication.
I am working on a new budget spreadsheet that I am creating. I want to accurately calculate credit card expenses. As everyone who has a credit card knows, charges made this month are not due to be paid until next month. To make matters more complex, charges made from (for example) January 20 until February 19 are not due to be paid until March 20. With that in mind, I created a spreadsheet with a different tab for each month. Each tab has a place to put in all expenses. Here is an example:
date
Category
Expenses
Remarks
[Code].....
Obviously, The above example is from January. IN the February tab, I want to calculate everything in the "Expense" column that has a date in the "Date" Column before Jan 20 and where it says "Kohls - Frank" in the Category column. Of course, in the March tab, I would need to grab all of the "Kohls - Frank" expenses after Jan 20 from the January tab, and everything before Feb 20 from the February tab.
I figured out how to add up everything with the following formula: =SUMIF(Jan!A:A,("<="&DATE(2013,1,20)&E32),Jan!C:C) How can I filter on the Category tab?
I'm trying to solve i have multiple books but each book contains same information e.g
Book1
Sheet 1
Date
Name
Sheet 2
Location
Postcode
Book 2
Sheet 1
Date
Name
Sheet 2
Location
Postcode
etc ... there is also multiple sheets in each book all are same layout just each book is different customer.
I'm trying to do is have a Listbox that shows all customer name and link back to His/her file location. Then retrieve certain information and display on blank workbook?
Question:
Can this be done without opening workbook
Considering i have 20+ workbooks and growing is this even possible
Cannot merge workbooks into one as this info is supplied by third party
I wanted to retrieve data from horizontal cells to the combobox i created on the userform.
I tried watching some code from other progs, but its not working.
From my combobox1, I want to go read the data from the sheet "TMATERIAL", range "b3:h3"
I have two lists. One is a database (Worksheet 2) with a lot of information, and another is the list (worksheet 1) I need to fill up the data for. What I want to do is to search for the names that are in worksheet 1 in worksheet 2, and if there is a match, retrieve the missing data in those rows, and paste it back into worksheet 1. For example:
Worksheet 1: Joe
Tim 23
Matt
Worksheet 2: Alex 45
Joe 23
Mark 47
Tim 44
Matt 24
I basically want it to be able to search for the corresponding name, and then pull the number associated with it.
I would like to create a summary for the ordering history of each customers. The IT department will facilitate us to generate some raw data and I want to retrieve the data to the summary excel when I type the Ref No of the customer.
For example, I have the following raw data generated, in which the file name is "A123456":
Ref No
Name
Address
[Code]....
And I want to extract the data to the following summary. When I type "A123456" in the field "Ref Number" in this summary, it will automatically retrieve data from the corresponding raw file:
Trading Summary
Ref Number:
A123456
[Code]....
getting data externally from web and also keeping the previous data prior to the refresh.
My external table/data has 10 rows reporting values per day (10 days data table).
I can link the table to my sheet, however what I can not do is to create an offlinek, year to date table in the sheet which captures the rolling 10 days (everytime it is refreshed) without losing the prior days.
For ex:
External bank Data
Day Ratio
02/05/2014 0.15%
02/04/2014 0.13%
02/03/2014 0.14%
01-31-2014 0.23%
01-30-2014 0.16%
01-29-2014 0.16%
01-28-2014 0.18%
01-27-2014 0.19%
01-24-2014 0.19%
01-23-2014 0.21%
Above table changes on a daily basis, only reporting the last ten days.
How can I capture this data on a rolling basis, i.e. in a year to date format, so that everytime I refresh, the internal table gets updated with the new data.
I am trying to get a macro to update information from attached sheet GTS807 to the Stock sheet. The code in Module 26 works only for the first line and will be very long if I repeat it for the 20 lines of the input sheet! Basically we need to copy the new stock balance from GTS807 column AA13 to AA32 to the individual corresponding product name on the stock sheet (Column E)!
View 4 Replies View Related
