Updating Info In 2 Worksheets Simultaneously

Aug 9, 2006

I am installing over 1000 phones for a business. I was provided a list created in excel (not by me) of all of the phones with their locations and phone numbers. Upon successful installation I simply search the spreadsheet for the phone number and place an "X" in the completed column. I do know how to filter the spreadsheet to print only those with an "X" that I submit weekly to show progress.

Now I am given a separate list of specific phones that someone wants completed by a certain date. I have copied this list to " Sheet 2" of the spread sheet. Is there anyway I can have exel mark and "X" in the completed column on Sheet 2 when I update Sheet 1? Can I update the list on sheet 2 with those that are already "X"ed as complete on Sheet 1?

View 5 Replies


Updating All Validation Drop Down Lists On All Worksheets Simultaneously

Nov 26, 2009

I have a workbook with 20 worksheets. All tabs are identical in format and layout. On B3, I have a drop down list (this may be irrelevant, but it's to select one month of the year) using simple data validation. Now, I initially had a formula in B3 equal to B3 of the first sheet, so that if I changed the month in the first sheet it will change on all sheets, it will do it the first time without touching the drop down lists on the subsequent sheets.

However, if I changed the date on any other sheet other than the first sheet, it will erase my formula and replace with the value I selected from the drop down list.

Can you guys please help me to device a way (code or formula; open to anything) where if I select, say September, on ANY sheet, it will change all the others to that selection (September) as well?

PS: B3 is actually a merged set of cell merging cells B3:D3. I know this is important because code and merged cell don't really mix.

View 9 Replies View Related

Multiple Users Updating Same Sheet Simultaneously?

Jul 17, 2013

I have a workbook with a list of drawing numbers (with customer, date, author etc.). New drawing numbers and their associated row of information are entered onto the sheet...

..HOWEVER, multiple users can be at least viewing and potentially entering information simultaneously.

I have written code where multiple people can view the same read only file, but not edit it and it be updated.

It seems quite unlikely, but is there anyway of 'live' updating a workbook whilst multiple people are viewing it? Or at least notifying other users when the sheet has been updated?

View 2 Replies View Related

View Two Worksheets Simultaneously.

Nov 11, 2008

I use a two monitor setup driven from a Radeon 9550 graphics card, but the problem I have occurs on a single monitor as well. When I open multiple workbooks or worksheets I can only view one at a time the other remains embedded behind the open window. Nothing I know of will let me view both at the same time.

If there are two open worksheets full size on the screen and I minimize one they both minimize. If I decide to close one workbook/sheet down all open workbooks/sheets close down as well. Can I view two workbooks at the same time? Can I close one down while keeping one open?

View 4 Replies View Related

Updating Info On Ribbon

Mar 13, 2014

I am using this code to show met the amount of sheets listed.

[Code] ...

I use a commandbutton on a userform to add sheets regulary, is there a command that can then update the ribbon to the new count.

View 7 Replies View Related

Splitting Screen Within Workbook To See Two Worksheets Simultaneously

Jan 18, 2006

I am working on a document at work with multiple worksheets. It would be most useful for me to be able to split the screen so that I can work on both worksheets at the same time without (a) having to switch back and forth, (b) modifying the workbook so that everything is on one sheet, or (c) opening the file twice and sizing the windows to my screen.

My goal is to be able to see the information on each sheet while modifying one sheet or the other.

View 9 Replies View Related

Enter Data On Multiple Worksheets Simultaneously

Nov 2, 2006

See the file attached (there are the same columns on all sheets, apart from on "BLANK"). The "Sort" sheets 1-4 contain rows that are repeated various times on the "Raw data" sheets. The "Sort" sheets are mutually exclusive; there is no repetition of rows among them. When I make an entry into an "ACTION" or "REASON" cell on any of the "Sort" sheets, I want that entry to be replicated on all identical rows throughout the "Raw data" sheets. Matching of the rows is to be via Criteria 1 and 2. I would preferably like the replication to be as I make the entries.

I am currently looking into writing a private sub for each "Source" worksheet. This would activate when a change was made to that sheet's ACTION and/or REASON cells, group that sheet with the three "Raw data" ones and change the relevant cells/rows (assuming that finding the relevant cells/rows within this function is possible). Or the macro could just loop through the rows of the three "Raw data" sheets and copy IF, but this would be long. Does this sound like the way forward or am I barking up the wrong tree? Should I be looking into VLOOKUP or pivot tables? Or is my data structured badly in the workbook from the outset? How straightforward will this macro be? Has anyone any pointers, magic routines in their libraries or links to relevant info?

View 5 Replies View Related

Vlookup Multiple Info From Different Worksheets

Oct 24, 2008

I have 3 different sheets of information.
Each sheet has a column of text. With the column of text I have a number associated with it.

I want to ceate a column for each number and have it look at all three sheets for info corresponding with that number.

Ex: 1st Sheet
Excellent condition 20
Like New 20
Poor condition 21

2nd Sheet
No work has been done. 20
Needs Work. 20

3rd Sheet
March 20
December 21

The formula needs to lookup the first number and place the text in the first row, then the next row either go to the next number or if there is not one then the next sheet.

I would like a column that reads something like this:
Sheet 21
in first row - poor condition
second row - december

View 9 Replies View Related

Sorting Info From A WS To Multiple Worksheets

Sep 30, 2009

Here's the issue: I have a spreadsheet with 12,000 contacts in it (name, email, phone number, country, industry, etc etc). The sheet is kind of messy, and I want to clean it up. One way thing I want to do is organize it. I want to sort the Master sheet into other worksheets, and I would like to do this Industry.

Is there a way to make excel register when a contact is in a certain industry, and then subsequently move that contact into a sheet? I tried playing around with If/Then functions, but I think this is a job for a macro/VB expert.

View 9 Replies View Related

Extracting Info From Multiple Worksheets To Summarize

Oct 9, 2007

I have a workbook that we use for our internal customers to use to place orders for equipment. There are five worksheets within that file that outline the different products. The requestor will indicate what items they want by putting a number in the quantity cell that is appropriate for the product. This could be using a combination of all five worksheets for the one request.

What I want to do is to create a summary page that only extracts the information from the other worksheets that has a value marked in the quantity spot only.

View 9 Replies View Related

Automatically Updating Cells Across Worksheets?

Jun 7, 2013

I currently have three worksheets and I'm trying to keep the data the identical throughout all three worksheets in cells B6-B9. I need to automatically update the same cell on the other two pages with the data from the edited one. Meaning if cell B7 is updated on sheet 2, that same data would be updated in cell B7 in the other two sheets, or if cell B9 is updated on sheet 3, that cells B9 on sheets one and two would have that same data.

View 11 Replies View Related

Updating Cells In Two Separate Worksheets

May 14, 2014

I need to find a way of updating cells in two separate worksheets. The cell address can vary.

Right now I am using a "button" which when clicked updates the cell value by an increment.

View 3 Replies View Related

Links Are Not Automatically Updating On My Worksheets

Mar 4, 2009

My links are not automatically updating on my worksheets. I was recently working on a sheet that linked to a different sheet in the same workbook. I deleted some cells by dragging other cells onto them, but when I went to the sheet that was linked to this sheet, the old information remained. When I clicked the cells that should have said "#Ref", they said =Sheet1!#REf but still had the old information showing until after I hit F9.

View 2 Replies View Related

Fill Info In Sheet One And Have Same Info Appear In All Sheets That Follow

May 12, 2014

I would like to fill in a a form on page /sheet one and have the same info on every sheet that follows is it possible?

View 3 Replies View Related

How To Fill Vertical Columns With Info From Horizontal Info

Aug 22, 2014

I have attached a spreadsheet and I am trying to capture the info in lines 2,7,12,17 and return the info into column d,e,f,g

The info in these columns at present has been manually entered but I am sure it could be automated.

OOL Roster Final 18-31Aug14.xlsx

View 1 Replies View Related

To Do More Than One Search Simultaneously

Oct 26, 2007

Is it possible to do more than one search simultaneously. Let me elaborate. I have a data of 40,000 students in DATA A and searches each student in DATA B which is also around 40,000 students. Instead of doing a For Next Statement, searching one student at a time, is it possible for it to search all the students simulatenosly because searching 40,000 students in a data base of 40,000 students takes FOREVER?

View 9 Replies View Related

Changing Defined Name Simultaneously?

Dec 31, 2013

I have approx. 50 Defined Name and which were divided into 2 parts, i.e "name.2012" & "name.2013" means each files had ".2012" or ".2013" but the issue is I want to change or replace ".2012" or ".2013" with any other name or number in simultaneously. Just like inside excel sheets, Find and Replace method.

View 2 Replies View Related

Sort Two Columns Simultaneously

Apr 8, 2009

I'm trying to sort selected rows by two columns, but simultaneously instead of sorting by "Column A and THEN Column B". In my case, this is numerical data where there is ONLY data in one column or the other, never both.

For example:
5 _
10 _
_ 1
_ 6
_ 4

Should sort to:
_ 1
_ 4
5 _
_ 6
10 _

View 9 Replies View Related

Freezing Several Columns And Rows Simultaneously

Mar 1, 2012

freezing columns and rows it does not seem possible to freeze MULTIPLE rows AND MULTIPLE columns simultaneously in the same spreadsheet.

In my spreadsheet I would like to freeze columns A, B, C as well as rows 1 - 8.

View 5 Replies View Related

Linking Charts So They Change Simultaneously

Jan 10, 2014

Is it possible to make a copy of a chart that is edited simultaneously as when you edit the original chart...somewhere else in the same workbook.

View 1 Replies View Related

Running A Loop On A Few Columns Simultaneously

Feb 13, 2010

I am trying to run a loop on a few columns simultaneously, from the last row to the top (well, until the 2nd row).

So I have a few columns of data, A through I, and the number of rows they populate changes all the time.

So how would I run a loop that will check for the following:

If a certain row in Column F is greater than the previous row in column F by 1.5times, then in that same row, if number in Column B is greater than number in E, the code should put the the value of E in a new column, lets say M (in the same row)

I know that sounds very confusing, but is that even possible? I am playing with loops, and I can only do very simple loops where I define a range, like

View 14 Replies View Related

Monthly Totals To Display Simultaneously

Apr 10, 2007

Spreadsheet is made up of Col A - Col AK:

Col A = Purchase Date

The info is continuous:

Row1 12/1/06
Row2 1/2/06
Row3 3/5/07

I need monthly totals to display simultaneously. Do not want to use Subtotals option.

View 9 Replies View Related

Scroll & Zoom Sheets Simultaneously

Dec 8, 2006

I have a workbook of 6 Sheets, what i want is that if i scrolled or zoomed one of the sheets i want all other sheets to be scrolled and zoomed accordingly identically.

to explain more: say I'm on "sheet1" and I scrolled down so i'm seeing range(K225:X250), now if i switched to any of the other sheets i want them all scrolled to the same range. so whatever sheets i choose i want to see range(K225:X250) in the same viewing properties "zooming".

View 9 Replies View Related

Automatically Sort Columns Simultaneously

Apr 21, 2008

there are two colums, one for product name (unique names) and other one is for their prices (may be same for more then one product). I want to arrange these columns by the their price vlaues in assesnding/desending order and to have their unique corresponding product names in respective columns. Provide me any solution, probably using any excel formulas. presently i have tried this using Large and Vlookup funstions...but it fails.. when there are same price is available for two product names, then it takes only first one. I WANT TO GET THIS DONE AUTOMATICALLY, AS THIS IS TO BE POPULATED ON SOME OTHER SHEET AS A PARETO. waiting for your vlauable responces ASAP.

View 2 Replies View Related

Apply Freeze Pane To All 31 Sheets Simultaneously?

Feb 22, 2014

I have 31 identical spreadsheets in one workbook. Is there a way to apply Freeze Pane to all 31 sheets simultaneously?

View 4 Replies View Related

Prevent Custom Functions From Running Simultaneously?

Jul 31, 2014

I have this excel file with some functions inside a Pivot Table, which use a year value as filter (the value comes from a report filter field) and data from a different spreadsheet to calculate a percentile value ... I created custom functions to replace the excel functions, passing the values as parameters.. The problem is now that when we refresh the connection (Refresh All button under DATA tab) the cells that contain the values returned by the custom function lose those values (go blank) In order to get the values I need to select the filter value again, while when I was using the normal PERCENTILE function the values would always refresh normally

Now... I think the problem might be related to the fact that the spreadsheet in question calls 5 different custom functions at the same time.... and, those 5 function call another at least two more helper functions... so, maybe this recurrence in calling the functions is causing the thing to break up

Is there a way I can prevent this from happening? Maybe put some flag or something that will cause the functions to be executed one by one, and not all at the same time?

View 2 Replies View Related

Edit Multiple Excel Files Simultaneously?

Jul 6, 2011

I need to copy information from one excel file and paste it into the same location (A1-A1, B6-B6, etc) in many other files all at once. Essentially I have several thousand files that need to be updated right now. I need to copy and paste both the cell contents and the formatting.

View 1 Replies View Related

Nested For Each Loops Moving To Next Cell On Both Simultaneously?

Jan 29, 2014

I am trying to run 2 for each loops inside another loop, and I was wondering if there is a way to move to the next value for all loops at the same time.

So when it reaches "Next starting, final, scal", all ranges move to the next cell before performing the formula.

View 2 Replies View Related

Macro To Press F2 Key For Multiple Cells Simultaneously

Nov 2, 2011

I am trying to use Vlookup and match on a large volume of data. The Vlookup true function was having trouble when an exact match occurred. I changed the table to allow for all options (sizes in this case) but the Vlookup with false came up with #N/A. The Vlookup key was the result of a formula. I then typed the same data and the formula was successful. I then copied and pasted Value the entire contents of the cell. I still received the #N/A. I then pressed [F2] to edit the cell and then pressed enter and this was successful. I have over 60,000 cells to edit and can not do manually. Any macro run the [F2] function on a range of cells or another way.

View 9 Replies View Related

A Code To Run GoalSeek For A Range Of Cells Simultaneously

May 18, 2007

I am posting this thread as a follow up to the previously posted thread entitled "IF Function and circular Reference". The reason I am changing the title because the topic we ended up talking about was not reflecting the previous title. My problem is that I got a range of independant cells (M7:M70) and the same number of dependant cells (BA7:BA70) as can be seen in the attached file. What I am trying to do is to make solver to find the value in the independant cell (e.g. M7) that makes the value in the adjacent (i.e. same row) dependant cell (e.g. BA7) equals 0. I can use solver for one row at a time but not for the whole range of cells. The question now is how can I use solver to do this task for the whole range M7:M70 simultaneously?

View 5 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved