Linked Up Sheets In Separate Spreadsheet?
Jun 12, 2014
I created 14 spreadsheets for each of my call center agents to monitor their metrics. I password protected all then placed the originals on the network. The 14 sheets have 1 cell within them that are linked up to their relevant agent cell in a separate spreadsheet. This spreadsheet is located on the network and automatically updates every hour.
I have monitored the the spreadsheets and updates etc for a while now and everything seemed to be working perfect. So I decided to slowly roll it out by placing a shortcut on 3 agents desktops. I quickly discovered that they were not seeing any updates as I had seen prior to the roll out. I go to the folder within the network and check all spreadsheets and I see all spreadsheets working and updating successfully.
So I thought maybe it was because they were password protected. I removed the protection and the 3 agents saw their spreadsheets update successfully on their computers, the next hour as I had hoped BUT the hour following however they did not see a further update again.
View 8 Replies
ADVERTISEMENT
Sep 5, 2007
I have copied and then pasted & linked numerous cells from one sheet to another within the same workbook. When I copy the 2 sheets (Edit>Move or Copy Sheet>Create Copy) the linked cells on the duplicates remain linked to the original sheet. How can I copy the 2 sheets and have the cells on the copied sheet be linked to the copied sheets and not the original?
View 4 Replies
View Related
Apr 24, 2014
I am trying to set up a spreadsheet with linked dynamic drop down lists, based on a table.Using the OFFSET function, I have managed to get this to work if the table is on the SAME sheet at the drop down lists. But I want to be able to put the drop down lists onto a different sheet, so that I can lock and hide the table.
I don't want to use the 'name based on the previous column' idea, as the table is large and will change weekly. the drop downs show all values, even duplicates, which I would like to get rid of.
View 2 Replies
View Related
Sep 29, 2009
I have two worksheets, 'monthly budget' and 'summary sheet'.
Summary sheet has been set up so that any additional records added to 'Monthly Budget' will be copied using the formula below (kindly provided by Cheeky Charlie yesterday):-
=IF(ISBLANK(INDEX('Monthly Budget'!$A:$G,ROWS($1:1),COLUMNS($A:A))),"",INDEX('Monthly Budget'!$A:$G,ROWS($1:1),COLUMNS($A:A)))
I have set up a unique entry count on 'summary sheet' which is currently showing 5. If I add a new name 'Jim' to the 'Monthly budget' sheet, this is copied on the 'summary sheet' however the unique entry count remains at 5.
View 5 Replies
View Related
Oct 10, 2013
I have a userform with a textbox and would like the user to type inside the textbox which in turn send the text typed to a cell on my spread sheet say sheet 1 cell ref A1. I am writing the following into the control source Sheet1!A1 but the control source does not except this. I am using excel 2007 .
View 2 Replies
View Related
Apr 9, 2014
I'm working in one workbook with 2 sheets.
sheet 1 have simple values, for example
cell A1:5
Cell A3: 10
Cell A5:15
Cell A7:20
Cell A9:25
Cell A11:30
Cell A13:35
Cell A15:40
In sheet 2 i have the following formulas:
Sheet 2 Cell A1: =Sheet1!A1+Sheet1!A3
Sheet 2 Cell A2: =Sheet1!A5+Sheet1!A7
I need to respect this sequence when copying these 2 formulas in the same sheet 2 cell A3, however when I do that I get the following formula: =Sheet1!A3+Sheet1!A5. While i need it to sum up A9 and A11. i.e respect the order of the first 2 formulas.
View 3 Replies
View Related
Feb 5, 2014
So under one tab labeled "scores" I have data that looks like this:
12/16/13 ETF-J
12/9/13 ETF-F
12/2/13 ETF-G
and in a separate tab I have data that looks like this:
ETF-J ETF-F ETF-G
1 yr Returns
12/16/13 .87 .67 .45
12/9/13 .05 .35 .04
12/2/13 .67 .23 .24
what I am looking to do is write a formula that would return the number associated with the given ETF and date so the first tab labeled "scores" would look like this:
12/16/13 ETF-J .87
12/9/13 ETF-F .35
12/2/13 ETF-G .24
View 9 Replies
View Related
Feb 5, 2014
So under one tab labeled "scores" I have data that looks like this:
12/16/13 ETF-J
12/9/13 ETF-F
12/2/13 ETF-G
and in a separate tab I have data that looks like this:
ETF-J ETF-F ETF-G
1 yr Returns
12/16/13 .87 .67 .45
12/9/13 .05 .35 .04
12/2/13 .67 .23 .24
what I am looking to do is write a formula that would return the number associated with the given ETF and date so the first tab labeled "scores" would look like this:
12/16/13 ETF-J .87
12/9/13 ETF-F .35
12/2/13 ETF-G .24
View 1 Replies
View Related
Sep 13, 2009
I'm creating an excel sheet that is linked to several others. Basically my salesmen will enter their new prospects into their own sales sheets and that will transfer via a link to my main one. The problem I'm having is mainly with my sort.
When the information is transferred, I need the sheet to auto sort the Company names alphabetically and move any blank cells to the bottom.
View 2 Replies
View Related
Sep 7, 2009
I'm using links to pull our sales prospects from our salesmen's individual sheets into one master sheet for reference. Once the prospect information arrives in the sheet, I need it to sort alphabetically by customer name so that we can see which customers have been visited and don't visit the same customer twice.
So far in VB, I've been working on this
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A5:L" & Cells(Rows.Count, "L").End(x1Down).Row).Sort Key1:=Range("B6"), Order1:=xlAscending, Header:= _
xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
End Sub
But it's not sorting the way that I need to. All I really need is for the sheet to sort automatically by Company Name and for all of the 0's to go to the bottom. They are 'blank' data that will eventually be imported from the salesmen's individual sheets as they encounter new customers.
View 9 Replies
View Related
Jan 31, 2014
I usually use INDIRECT to link to a separate spreadsheet. Is there a way i can use this without opening the separate spreadsheet
This is a sample of the formula =VLOOKUP($F$14,INDIRECT('Data Files'!$C$17 & "$A:$Z"),5,0)
View 1 Replies
View Related
Mar 29, 2007
I am trying to take a spreadsheet and have each row print on a seperate page - without having to do the print area thing on each row. Is there a way to automate this process?
View 2 Replies
View Related
Feb 2, 2010
Hi everyone,
I've got several Excel files that need to be edited separately.
Once they have been edited, I need to paste the content of each file in a single separate Excel file.
Is there a way to retrieve the content from all the files in a folder, and merge it in a single file?
For example:
3 separate files > File1, File2, File3
Merged file, sheet1
File1
File2
File3
View 14 Replies
View Related
Jun 16, 2009
I have a very long Excel spreadsheet (>2500 rows by approx 20 columns) that consists of >400 customer statements. At the top of each invoice, in colun B, is the text "Service Requestor Contract Number", and 5 rows down is the respective contract number. Further down (and the number of rows differ for each contract as each has its own unique level of detail) , again in column B is the text "Current Month Charges", and on the same row, in columns K and O, the current month number of items sold and $ charges respectfully. The spreadsheet is NOT paginated for each respective statement.
What I need to do on a separate spreadsheet is sum, by contract, both the number of widgets sold, as well as the amounts due.
View 9 Replies
View Related
Dec 5, 2008
I am trying to count the # of rows in a spreadsheet in which there is non-blank text data in 2 separate columns. For instance, if the spreadsheet looked like the one below (dashes just for formatting purposes):
NAMES-------THIS-------------THAT
Mary-------some text--------some more text
John-------<blanks>---------just text here
Sue--------just some here-----<blanks>
Dave-------something--------something else
Adam------<blanks>-----------<blanks>
The total # of rows with something in both the "THIS" and "THAT" columns above would therefore be 2.
View 4 Replies
View Related
Jun 3, 2014
I am in the process of creating a Phone Roster for my unit. On Sheet1 is their administrative data (Name, Position, Phone Number, etc.). What I am attempting to do is use a formula to find the persons name for that position and place it in the appropriate position and then their phone number below.
Admin!H:H contains the positions
Admin!B:B contains their name
Admin!N:N contains their phone number
I believe the following is what I need =LOOKUP("Operations NCO",Admin!$H:$H,Admin!$B:$B) and it works, but only for the first person on Sheet 2. After that it is random. If there a different formula I need to use to make this work?
When I get the phone number I used =LOOKUP("Operations CO",Admin!$H:$H,Admin!$N:$N) and the same thing happens. It works for the first person and everything else is incorrect.
A problem is the Admin sheet is listed alphabetically, not by position, so I cant use a specific cell to copy the data. I need the formula to find the position, then find the name and phone number of the person in said position.
View 5 Replies
View Related
Nov 7, 2013
Is there a way of getting excel to highlight duplicates within 2 separate sheets, one beside the other on screen?
View 14 Replies
View Related
Feb 10, 2012
I have a raw data worksheet with 54000 lines, in the format of six columns
In Column A is the USER Name
What I would like with if possible is code that will move the six columns of data from each individual USER into separate sheets, using Column A as the basis of the new sheets, ie the last row for each user is when the user name changes to the next one.
View 2 Replies
View Related
Mar 6, 2014
I'm currently using the following code (that I found online) to take a list of data and copy it to specific sheets based on the values in Column C (there are only 4 columns in my data set). The issue I have with it is that it's meant to create the sheets from scratch every time. What I could like, however, is for it to copy the data to preexisting tabs that are already named with the sames values that are found in Column C. This macro will actually perform that but the down side is it wipes out everything that's on those sheets but I cant have it do that. Is there a way to either modify this sheet so it only copies the four columns and only pastes the four columns onto the sheets?
Sub SplitData()
Const NameCol = "C"
Const HeaderRow = 2
[Code]....
View 5 Replies
View Related
Jun 26, 2008
below is a VB code to email separate sheets based on sheet anme and email address on a sheet called " mail".
Code seems to fail at the last line " Next a" any ideas why this is not working
Sub Mail_sheets()
Dim MyArr As Variant
Dim last As Long
Dim shname As Long
Dim a As Integer
Dim Arr() As String
Dim N As Integer
Dim strdate As String
For a = 1 To 253 Step 3
If ThisWorkbook.Sheets("mail").Cells(1, a).Value = "" Then
Exit Sub
View 9 Replies
View Related
Aug 8, 2008
I have information in range(p10:Q10) on sheet DEMO! that I want to paste the Values only into a Separate sheet "LIST!" in columns(W:X). The row will vary and will be based on the cell: "DEMO!A3" and will match a cell in column A of "List!"
View 9 Replies
View Related
Jul 4, 2007
What I want is one sheet that has all of the fomulas, then 4 other sheets that take those formulas and calculate the output based on the formulas and one column of input.
So essentially, I want to be able to change the formula once, and have it applied to all of the other sheets, resulting in a new output for each one.
View 4 Replies
View Related
Jun 9, 2014
In the attached sheet, i have data in 2 sheets in the same fromat. Both the sheets are seperate reports.
Coloumn A is the list of Team Ids, Coloumn B is the Ids of people who are assigned in the team. Sheet 2 also have the same details with changes in the people ID.
i am trying to find if the people IDs in report 1 is the same in report 2. i need a formula that will check if the people ID is matching to the same team ID as in report 1.. If its not the same, the formula should be able to show that.
eg :
In report 1, "197595" in coloumn B is against "4011-11341" in Coloumn A.
I need to check if "197595" is against "4011-11341" or some other number in report 2. If "197595" is not against "4011-11341" in report 2, it should show me " Miss match". if "197595" is is against "4011-11341" in report 2 as well, it should show me "match"Project match.xlsx
View 3 Replies
View Related
Feb 1, 2013
I need to take the data out of one column from sheet A and compare it to the data on another column sheet B.
Real life example:
I have a very large list of contacts with multiple columns of data. On a separate spreadsheet, I have a list email addresses that I need to remove from the larger list of contacts. How can I compare them against one another to detect any matched email addresses for deletion?
List of contacts is appx 130mb
List of email addresses is appx 4mb
View 2 Replies
View Related
Jan 9, 2014
I have two spreadsheets, one is a Log Sheet for invoices that we have been printing out and filling in my hand throughout the day as our field technicians complete their work. The second spreadsheet has a sheet for each technician where we manually input the technician's invoice numbers and payroll for each job completed on that day.
What I'd like is a way to combine these spreadsheets so that instead of printing and filling in the first sheet by hand, I could input the invoice data and have it automatically populate the cells for the appropriate technician.
This is the running log we keep throughout the day:
2rp76ky.png
Then at the end of the day, we painstakingly transcribe the data for invoice number and payroll onto this sheet for each technician:
4vg6dk.png
What I want is for Excel to automatically fill in each technician's payroll log with invoice number and payroll time as we fill in the running log throughout the day, is this a doable thing?
View 1 Replies
View Related
Jan 9, 2014
I have an Excel file with multiple sheets (over 100). I want to save them each as an individual PDF, with different (but similar format) names.
As an example, I want each PDF to be be called "Date Name" (i.e. "1-8-2014 Sarah", and next one will be "1-8-2014 Beth", etc.)
Is there a way to do this all at once, instead of my having to manually save each one? Is there a way for me to set it so that the title lists the date and then, for example, whatever is listed in A1 (which will be the name)?
One other question is that because I get this report from someone else who generates it, the way the file is formatted on my computer is that the print area is set at too small, so if I convert immediately to PDF, everything gets messed up. I have to manually make the print area bigger so that the PDF version encompasses everything on one page. Right now I've been manually adjusting the print area page by page - any way to do this all at once?
View 1 Replies
View Related
Jan 16, 2014
I'm working with several sheets, each containing databases of customers that bought different products. I'm trying to do a cross reference so I know which customers has already bought multiple products.
English is not my first language and I might not be able to clearly express what my problem is, so I included a worksheet example.
In the example, you can see that Lea bought an apartment coded with APRT-001 from the first sheet. Lea also bought a condo coded with COND-002. What I'm trying to do is to put a note beside the her entry in the apartment that she has bought COND-002. And vice versa on the COND-002 entry on the second sheet.
What I usually do is combine all the data in one sheet, use Conditional Formatting to point out the duplicate name entries, and work through the whole thing manually. The thing is, there are thousands of names and I need to update the list regularly
View 5 Replies
View Related
Feb 27, 2014
I have a code that will create separate sheets from “SDL_Calendar” sheet for each team and its working fine. Modify the code to create sheets for each Team BY YEAR based on user selection in Cells “H6”, “H7” and “H8” in “P6_Report” sheet. For filtering BY YEAR Column "D" Can be Used in “SDL_Calendar” sheet.
I have attached the work book of what I am trying to accomplish :
[Code] ......
CreateSheetsByYear_new.xlsm
View 14 Replies
View Related
Jul 16, 2009
If the name in Column F of "Sheet1" is found in "DataPEs" in Column B, then copy the block of 6 cells of data below it in column Q to column D of "Sheet1" in their relative rows. Additionally, if column Q has data then copy it, if not then copy the data only in column M. Finally, the number of matching names will vary in Sheet1 but will stay mostly the same in the DataPEs sheet. I've highlighted one block of data in green as an example.
View 13 Replies
View Related
Oct 8, 2012
I've got Excel 2002. I am devising a sheet for checking work (sheet A) which feeds onto a separate sheet (sheet B). If I wanted to delete info from sheet A can I retain the info on sheet B? I want sheet A to be used repeatedly for each case but the info for every case to be recorded row by row on sheet B.
View 4 Replies
View Related
