Excel 2002 :: Updating Separate Sheets

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


ADVERTISEMENT

Excel 2013 :: Updating Links To Separate Workbooks

Sep 12, 2013

I'm linking some data from 2 workbooks in the same folder (using excel 2013)

I have a main rota that works great, called "Main Rota.xlsm" I then have a separate basic file called Email Rota.xlsx without all of the bells and whistles of the Main Rota, purley made to email out to staff.

I store both files in the same folder "Site Rota" and it works fine.... until I rename the folder or move the folder to my laptop.

The link in the Email Rota looks like so to start (calling cell A3 from the Main Rota) ='[Main Rota.xlsm]Planning Rota'!A3

As I said it works fine until I move the folder onto my laptop the link then changes to

='D:DesktopSite Rota[Main Rota.xlsm]Planning Rota'!A3

And I have to keep updating the link, I have read online that it isn't supposed to work like this and its supposed to read the file "cleverly" in the same folder ?

I would ideally like to keep both files in the same folder and to update from visa versa without having to update the links if I move it from PC to laptop with I do daily .

View 1 Replies View Related

Using 2002 To Send Emails Via Outlook 2002

Feb 20, 2009

I am trying to send emails using a table in Xl2002 via outlook2002.

The code below is from Walkenbach's VBA Bible for Excel 2003 and I am getting "Uesr-type not defined" error with the 1st Dim statement.

Do I need a different statement such as set OutObj = blahblah or similar?? I have searche dthe net hi & lo for a solution to this problem & I do have JW's excel VBA bible.

Sub SendEmail()
'Uses early binding
'Requires a reference to the Outlook Object Library
Dim OutlookApp As Outlook.Application
Dim MItem As Outlook.MailItem
Dim cell As Range
Dim Subj As String
Dim EmailAddr As String
Dim Recipient As String
Dim Bonus As String
Dim Msg As String

View 9 Replies View Related

Pull Data From Multiple Excel Into Separate Sheets?

Mar 26, 2014

As part of report consolidation I need a Macro that can read through all the files in a particular location(Say a folder path) Pull the data for each unique products into separate sheet

In the example below : All the rows with "Chocolates to sheet 1" , Drink to Sheet 2 and so on Since the products in column 3 can vary the unique sheets need to be created at run time based on the source data

Workbook1
WEST
100
Chocolates

[Code]....

View 2 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

Excel 2002 :: Limitations In Shared Workbook

Jul 20, 2013

I am using excel 2002 and I have found that when the workbook is shared and getting 2 or more users to open the workbook around the same time brings up a read only type prompt box for the 2nd ( and 3rd) user when the book hasn't fully opened for the 1st user/is still fully opening. Is this a limitation within excel or is there a way around this for example via vb code.

I know the more data a workbook has can cause it open a lot slower but is this the same for shared mode.

View 5 Replies View Related

Excel 2002 :: Formula To Display All Errors?

May 27, 2012

In a worksheet the data (text or numerical) from five columns are compared using the following formula.

=IF($A10$G10,"1ERROR",IF($B10$H10,"2ERROR",IF($C10$I10,"3ERROR",IF($D10$J10,"4ERROR",IF($E10$K10,"5ERROR","-")))))

The formula is working well. The problem is I get the result for the first column of error even if the error is in more than one column. I want the result should display all the errors with the column number 1, 2, 3 (or with column name A, B, C etc). The total number of error is not required. The exact columns which have the error should be displayed. For example if the error exists in 3, 4 and 5 columns, I should get the result as "345Error" or "CDEError".I use excel 2002.

View 6 Replies View Related

Excel 2002 :: Conditional Formatting And Formulas?

Jun 11, 2013

I'm currently trying to set up a spreadsheet on excel, when certain documents need updating. Basically I have a column with the dates in that each document was last updated, I want the cells to turn red (fill colour) if the document has not been updated within the last 6 months and orange (fill colour) if the document has not been updated in the last 4 months. How do I do this?

I am currently using Excel 2002 and am on a Windows XP computer.

View 1 Replies View Related

Excel 2002 :: VBA Looping Copy / Paste Special For Each Row

Jan 25, 2012

Excel 2002.I have data in columns A and B on sheet 3, starting at row 100. The total number of rows of data is variable (max is 50 rows). I want to take the values in A100:B100 and copy them from Sheet3 and paste values transposed to SheetTL Range C1:C2. I have started to write the following code but as you can see I will have to repeat the code upwards of 50 times. It seems I should be able to do a COUNT function to see how many rows of data exist and then somehow loop the code to copy the data from each subsequent row that many times, but how to put that together.

Sheets("Sheet3").Range("A100:B100").Copy
Sheets("TL").Range("C1").PasteSpecial Paste:=xlPasteValues, Transpose:=True
ActiveSheet.PrintOut
If Sheets("Sheet3").Range("A101") = "" Then

[Code] .........

View 5 Replies View Related

Excel 2002 :: Binding Fill Color To A Cell

Jan 26, 2012

I have a workbook in which there is a sheet containing a table.

Excel 2002ABC123Specific Gravity6 Volt ValuesSOC40.0000.000Dead
51.1345.97010%61.1485.99020%71.1626.02030%81.1766.06040%91.1906.10050%101.1976.12055%
111.2046.14060%121.2116.16065%131.2186.18070%141.2256.20075%151.2336.23080%161.2416.26085%
171.2496.31290%181.2576.32095%191.2656.350100%SOC Chart

From another sheet I query this table using the LOOKUP function to obtain values from column C such as 25% 60% and so on. A typical query formula looks like this:

=LOOKUP(B2,'SOC Chart'!B4:'SOC Chart'!C19)

It would be nice if the fill color came along with the value.

View 3 Replies View Related

Excel 2002 :: Activate Macro By Clicking A Shape

Feb 3, 2013

I found in an old file that i triggered the macro by clicking a button! I would post a pic but i don't know how. How do I activate a macro by clicking a shape on the excel 2002 page?

View 7 Replies View Related

Excel 2002 :: Running Total With Dropdown Lists?

Sep 10, 2013

Basically, I have an excel spreadsheet with different valued items for example,

TV Essential l £15
TV Essential extra l £20

Broadband Essential l £ 8
Broadband Extra l £12

I have options for TV, Broadband and Phone. At the bottom of the spreadsheet I want three drop down lists to pick what TV, Broadband and Phone package I want. For example: TV Essential, Broadband Extra and Phone Weekend. I can create the lists but I was wondering if there was anyway where, as you select the option on each of the lists, a running total will be created. So when TV Essential is selected £15 is added to a cell, say F20. Then when Broadband Extra is selected another £12 is added to cell F20. And as you select different ones in each list the total in F20 changes.

I'm using Excel 2002.

View 1 Replies View Related

Excel 2002 :: Does Saving File As Unicode Save It In UTF-8 Or UTF-16 Format

Jan 14, 2011

what format is used when you save an excel file as "unicode." I am using excel 2002 on XP.

I have been asked to provide a UTF-8 formatted unicode file for use by another program but I am not sure which formatting excel uses.

View 3 Replies View Related

Excel 2002 :: Setting Variable To Select All Worksheets In Workbook

Jan 20, 2012

I've got some code which some one posted me a link to on here which set up a pivot table on more that 1 sheets (using excel 2002).

I inserted this code into a rountine I do daily which works fine.

The problem Im having is that Im getting more and more info which I need to pivot over more than one sheet. So I was going to amend the rountine so It picked what ever sheets are in the work book to pivot.

At the moment I have to go into the code and name the sheets to pivot. Is there some code which can work out how many sheets that need pivoting and just do it with out naming them? and also just add a new sheet with the pivot on rather than having to name the destination?

I've posted the code i got given below and have highlighted the bit where I have to name the sheets.

Code:
'---------------------------------------------------------------------------------------
' Procedure : CreateConnection
' Author : KL (Kirill Lapin)
' Date : 18/08/2009

[Code]....

View 8 Replies View Related

Excel 2002 :: Modify Formula To Merge Numerical With Text

Apr 21, 2012

I am using the following formula to find out the No. of "HH" in the range given and I am getting the results simply with numerical value as 2, 3 etc. I want the result should be displayed as 2HH, 3HH depending upon the No. of "HH" available in the given range. The result should be displayed as (the No. added with the text "HH").

=IF(AND(DJ10="HH"),COUNTIF(DF10:DJ10,"HH"),"-")

I use excel 2002.

View 2 Replies View Related

Excel 2002 :: Conditional Formatting Based On Date In Adjacent Cell

May 22, 2012

I have columns of figures with times like 5:52:54 and next to them cells with values that i wish to format based on the time.
that is if the time on the adjacent cell is before 8AM then make the value cell have a red border it does not have to be conditional formatting - Excel 2002 in win7/64

View 9 Replies View Related

Excel 2002 :: Conditional Formatting - If All Cells Match Background In One Cell To Change To Green

Apr 7, 2014

Excel 2002

I have a simple spreadsheet and am trying to get some Conditional Formatting to work.

Cell1 = Name
Cell2 = 1
Cell3 = 2
Cell4 = 3

If cells 2, 3, and 4 all match I want the background in cell 1 to change to green.

I've tried (Formula Is =B1=C1=D1 green) with no luck.

View 5 Replies View Related

Updating Values On Three Sheets

Jul 1, 2013

I have three sheets of data which require different values. What I'm looking for is for the other two sheets to be updated when I change the values in the field 'Option_Group_IDs' in the productdata-army-to-merge.csv file.

The two fields in the other two sheets to update are the optGrpID filed in the optiongroup-data-army.csv and the optGroup field in the optiondata-army.csv

productdata-army-to-merge

*
A
B
C

1
Remove_Product
Additional_Section_IDs
Option_Group_IDs

[Code] ..........

View 1 Replies View Related

Hide Sheets While Updating Records

Dec 3, 2011

I have these following codes. when i click button then it updates the records, like pulling data from sheets and putting it into one. thats working fine. only things is, when it update the records, then it shows whats going on behind, all updating sheets get visiable. is it possible can i just hide whats going on in the back? when i click the button msg box comes up that please wait its updating the record.

Dim Response As Integer
MsgStr = "ARE YOU SURE YOU WANT TO UPLOAD NOW?, PLEASE CONSIDER RE-CHECKING YOU INPUT!!"
TitleStr = "USER MESSAGE"
If MsgBox(MsgStr, vbYesNo, TitleStr) = vbYes Then

Sheets("Employee Data Input").Select

[Code] ...........

View 4 Replies View Related

Automatically Updating Multiple Sheets

Jun 22, 2007

I would like to make my stock sheet able to copy entres to another sheet within the same work book. (avoiding using VB as I can't do that)

If data is entered in sheet2, it is automatically copied onto sheet1.

The reason is that each storage device will have its own sheet and all entries will automatically be copied to the master sheet. This will make things easy for the people who need to use this system for updating and seaching it.

I have seen a similare problem that seems much more complex here @ Copy Data From Multiple Closed Spreadsheets

View 6 Replies View Related

Excel 2002 :: Files Corrupted - No Cells Just A Grey Space Where Cells Should Be?

Mar 9, 2012

I am using Excel 2002 and have had a couple of files that seem to have become corrupted recently. When I try to open the files there is nothing there, no cells just a grey space where the cells should be. When I try to close Excel it asks me if I want to save changes when no changes have been made.

I had not made any changes to the sheets prior to this happening so am struggling to work out what is going on.

View 2 Replies View Related

Prevent Formula From Updating When Deleting Cells / Sheets

Nov 5, 2008

I've got a workbook that I'm currently designing and I've just realised that I need to delete a few sheets, paste in some new template sheets and rename them. The problem is, I've already completed my summary sheets and I don't want to have to redo the values. Essentially, I just want to (temporarily) turn off auto-updating of formulas when cells / sheets are changed/moved/deleted.

For practical purposes: I need to delete the sheet named "Jan", paste in a new sheet "MonthTemp", rename "MonthTemp" to "Jan" and have all my formulas not updated (e.g. still referencing "Jan" instead of "#REF!")

View 13 Replies View Related

Updating Master Sheet With Data From Multiple Sheets

Oct 10, 2013

I have multiple data sheets with tables and I want to create a master sheet table that automaticly will update when now rows/data is added in to the sheets in any of the data sheets.

Master sheet will look like this (the first 3 letters is the data sheet name), this is just the first column there a a lot more columns to be added

AAB08
AAB09
AAB10
AAB11
AAB12

[Code] .......

So when let's say in sheet AAB I add another row AAD13 I want the master sheet to update automaticly so it looks like this

AAB08
AAB09
AAB10
AAB11
AAB12

[Code] ......

Is this possible?

View 1 Replies View Related

Updating VData List In All Sheets By Changing DynRange

Jul 13, 2006

I have a raw_data sheet with a list that is linked through
Insert> Name>Define. This list is used for Validation Data List drop
down menus in other sheets. I would like to update a
list element in my raw_data sheet and have the corresponding element in
other sheets also update. Is this possible or is there another way to
do this?

View 9 Replies View Related

Lookup Values From Separate Sheets?

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

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 View Related

Highlight Duplicates Within 2 Separate Sheets

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

Sort Raw Data Into Separate Sheets

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

Splitting Data Onto Separate Sheets?

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

VB Code To Email Separate Sheets

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







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