importing file into Excel
I will be exporting files from Crystal Reports and importing them into Excel.
My question is: is there a way i can remove all the Blank rows and Blank
columns in Excel in one shot or do i have to delete each line or group of
lines? If there is a way to do it in one shot how would i go about doing
that? I was thinking of doing a macro but the only problem i see is how
would i set up the marco to see if they is any data in any of the rows or
columns?
Any assistance would be greatly appreciated!
--
Thank you, Tag: Color-coded cell references Tag: 770189
Adding Row on a protected wkbk
I have several staff that use wook books (wkbk) to keep track of there
clients. The cells with the formulas are protected, because they keep
typing over them and then do not know how to put them back in.
They often add and delete rows, which I have allowed them to do while still
protecting the formula cells.
How do I get the formual to duplicate in a row that has been added with out
having the formual cell unprotected.
--
Lisa M. Tag: Color-coded cell references Tag: 770188
VBA to split contents of cell
I have huge sheet with thousands of non-standard lines of text. Some of the
lines have the following line in a cell:
ProjID=MFG-Company-DA-33 ProjType=BBAA Uplift=0 CostType=Time Mgr=Smith
I would like to understand how to write the VBA that will skip the lines
that don't match this format and then Break out the items that do. This is
what I have so far.
some sort of loop statement here
If activecell.value (left(5))="projID" then
' this is where a need the help. I want to move everything after ProjID= to
Type= to the next column then move everything after Type= to Uplift= to a
column 2 columns away and so on for the rest of the line.
else activecell.offset (-1,0)
loop
End if
Thanks for the help. I would use text to columns, but only few of the
cells follow the format listed above. Thanks Tag: Color-coded cell references Tag: 770182
Sumif with multiple columns in sum_range
Hello,
I have a set of data that has a label in column A the sales in column
B, C & D:
Column A Column B Column C
Joel 500 677
Joel 575 752
Joel 650 827
Claudia 725 902
Tarzan 800 968
I'd like to run SUMIF where the "Range" is column A, the "Criteria" is
Joel, and the "Sum_Range" is B:C but when I use SUMIF(A:A,"Joel",B:C)
I only get the sum of column B which is 1,725.
Can someone hook me up with a formula that can sum both column B & C
in this situation.
Thanks, in advance
Daniel Tag: Color-coded cell references Tag: 770174
Excel Formula
I am trying to get results for cells with dates in them. Who do get the
following results:
a2 = begining date (3/4/8)
b2 = ending date (3/5/8)
c2 = difference (1)
I do not want (zero) 0 to show up if the cells are blank
I do not want a negative number to show if b2 is blank
I do want a zero to show if the b2-a2=0
here is the current formula I am using
=IF((N73-M73<0)," ",(SUM(N73-M73)))
If the M & N are blank I get a zero in O73. I want O73 to be blank
If N73 is blank, O73 is also bank. This is OK
If N73 & M73 have the same date I get Zero in O73. This OK
--
Lisa M. Tag: Color-coded cell references Tag: 770173
Excel Hyperlink to Worksheet
I have embedded hyperlinks in various worksheets which I have then saved as
web pages. The web page links will take me to the workbooks but they ignore
the worksheet portion of the address. E.g.: this address
"MonthlyReport.xls#Summary!A1" will open "MonthlyReport.xls" but it will not
take me to the "Summary" worksheet. It seems to default to whatever
worksheet I was in the last time I saved the workbook. Has anyone had this
problem? Thanks! Tag: Color-coded cell references Tag: 770166
problem with zip codes and filter
I'm trying to sort a spreadsheet by zip code and some zips show as
"06901" and others show as "6901". When I sort for one I don't get
the other. I tried to manually put a "0" before the the "6901" code
and excel will not let me. Which is weird because it will allow it to
be imported from another program like that. Is there some way I can
format it to get the "0" to show in the column? Tag: Color-coded cell references Tag: 770162
Wrap text in merged cells VBA
I have merged cells that need to wrap text. I used the VBA code several of
you provided and it is working great for the most part. The problem I am
running into is when I have more than one set of merged cells on the same
row. I have applied text wrap to each of them. Let's say I type in several
lines of text in the first merged cell unit and it wraps the text perfectly
and auto fits the cell. However, if I type only a single line of text in the
next merged cell unit in the same row, the whole row autofits to that single
line and covers up my multiple lines of text that I just typed in the
previous merged cell unit. Any suggestions on what may be the problem? If I
need to try to explain further I will.
Much thanks! Tag: Color-coded cell references Tag: 770156
vacation excluding holidays
HI
I am trying to count the total of leave taken without the holidays and
the weekends
i have used the NETWORKDAYS but i dont know what is the formula in
order to have a total
of vacation taken excluding weekends and holidays so this is the table
that i have
i am using network days but its not working
Total =NETWORKDAYS(B17,C17)
B= from
C=To
Holidays
B C
C52 New Year 1/1/2008
C53 St Maron's Day 9/2/2008
C54 Good Friday - -
C55 Labor Day 1/5/2008
C56 Atha's Day
C57 Fitr's Day - -
C58 MondayEaster - -
C59 Independence Day 22/11/2008
C60 Christmas 25/12/2008
PLEASE ADVISE
TIA Tag: Color-coded cell references Tag: 770155
Date Formula help
I am trying to calculate the number of days in a time period excluding
Sundays,
(i.e., 2/29/08 minus 2/23/08 = 5 )
Can anyone help me?
Thanks Tag: Color-coded cell references Tag: 770153
Link a cell to a word in a sentence
I am trying to create work instructions that can easily be modified. I want
to link a cell to a word in the middle of the sentence. I have a table with
the list of parts and tools, instead of using item 1, 2 ... in the sentence I
would like to be able to link a word in the middle of the senctence to the
table down below.
Thanks Brendan Tag: Color-coded cell references Tag: 770151
Open Text Files in Excel, Changed Behavior
For years I have opened text files in Excel using the right-click
"Open With..." in Windows. The files opened without triggering the
Import Text Wizard and were imported in one column. As of yesterday
(without any apparent changes to Excel or Windows), this behavior
changed. Now when text files are opened using "Open With...", Excel
"figures out" where it thinks the columns breaks should be. (Again the
Import Text Wizard is not triggered opening files this way.)
I've searched for settings that determine how Excel opens text files
by default, but found none.
Any ideas on how to go back to right-click opening the "one-column"
text files?
Thank you,
Patrick Tag: Color-coded cell references Tag: 770147
Help w/ calculating weekly Avg
Hello,
I am not sure what formula to use to calculate the weekly average, which is
the range of the week data (Monday to Sunday). Example: date range from 2/4
to 2/10/08 week is the sum of data from 2/4 to 2/10 divided by 5 (weekday).
Below is a sample of data and results I want to achieve.
Data:
Type1 Type2 WeekAvg
Date ProdA ProdB ProdA ProdB ProdA ProdB
2/4/08 30 10 20 10 61 37
2/5/08 10 15 10 15 61 37
2/6/08 50 15 25 10 61 37
2/7/08 20 10 20 20 61 37
2/8/08 10 10 30 20 61 37
2/9/08 10 15 40 15
2/10/08 20 10 10 10
Result column: WeekAvg for ProdA = 61
(30+10+50+20+10+10+20+20+10+25+20+30+40+10) / 5
Result column: WeekAvg for ProdB = 37
(10+15+15+10+10+15+10+10+15+10+20+20+15+10) / 5
NOTE: 2/9 and 2/10 are weekend so does not need to show value. Tag: Color-coded cell references Tag: 770144
Formula Help for Duplicate Entries
I have a spreadsheet of 3000 contact names
I am trying to assign these in the most "fair" fashion to account
resps.
My thought was to create a colum called "account_rep"
I then put
account_rep_name1
account_rep_name2
account_rept_name3
In,
colum1,Row 1 account_rep_name1
colum1,row 2 account_rep_name2
colum2,row 3 account_rept_name3
colum1,row 4 account_rep_name1
colum1,row 5 account_rep_name2
colum2,row 6 account_rept_name3
the pattern continues respectively through the list to row 3000.
However, what has happened is that
there may be more than one account rep assigned to an account.
For example in the list I have.
account_rep_name1 Suzie Queen ABC Company
account_rep_name2 Suzie Queen ABC Company
account_rept_name3 Suzie Queen ABC Company
so, I want to assign unique rep to the account the first time his name
hits the account down the list.
What is the best way to do this?
Thanks,
Robert Tag: Color-coded cell references Tag: 770143
Text overlapping cell border above it
When I print from Excel, the text more and more is printing over the cell
border above it, the further down it is. How do I prevent this from happening?
K Tag: Color-coded cell references Tag: 770141
Transpose issue
I have a series of email addresses from an Outlook email. I want to use
Excel's sort feature to sort these email addreeses looking for duplicates.
I have attempted to copy , paste special, and transpose to insert this
semi-colon separated row into an Excel column. It does not work (inserts as a
row)
Ideas? Tag: Color-coded cell references Tag: 770140
Annual leave without holidays
Hi
I am working as an H.r and i am looking for a formula concerning the
annual leave
I have already found a formula that gives the total of the days
allowed without the weekends
But i do need to calculate the days taken excluding the weekends and
the holidays
A: starting date
B: Total of Days allowed
C: New Year 31/12/2008
D: Ester 24/3/2008
Etc
Please advise Tag: Color-coded cell references Tag: 770137
Excel file will not open with out opening excel.exe first
O3K
I attempt to open a file from outlook attachment, file on the desktop, and
it does not do anything
Right click and open with and it is pointed to open with excel
open excel and go file - open and it open fine
Thank you in advance Tag: Color-coded cell references Tag: 770134
Request
Hi all. I was wondering if any of you fine excel guru's would fancy taking a
look at an Excel book for me and let me know if you could change something.
I have a program in excel that creates a rota card for offshore workers.
Typically we work 2 weeks on and 2 weeks off ( some 2 on and 3 off). Our
rota will change to 2 weeks on and 3 weeks off and I would like to change the
VBA to make the program do this new rota. To me, this is an extremely
complicated VBA as I manage to muster through VBA with basics. If anyone
could or would like to help, could you email me at woody26775@yahoo.co.uk and
I can email a copy of it to you.
Apologies if i am wrong in doing this, just looking for some help. Tag: Color-coded cell references Tag: 770133
Not Enough Memory opening 2nd spreadsheet
I have 2 spreadsheets each of 24.5MB. If I have one open and try to open the
other I get "Not Enough Memory". However my C: has 63.6 GB of avialable
memory. Why is this happening and how can I overcome this. Using Office 2000
on Windows XP.
--
Regards
Pete Tag: Color-coded cell references Tag: 770129
Current bi-weekly total
In my worksheet, Column A1 has project start date and A2 to A3000 has
subsequent dates based on A1. Column B has data. After each 14 days, there is
bi-weekly total. I would like to add a row on top, which will show me
bi-weekly total for the current week. So, let's say, if project start in
January 6, 2008, and if today is March 14, I want be able to see the most
current bi-weekly total. Is there a way to do that. I was able to do "Year to
Date" total by just simply adding those biweekly total.
Since, it is a long sheet, I have scroll down to find out current bi-weekly
total. I want avoid that. So, the most current bi-weekly total always will be
in top row.
Thanks in adavance. Tag: Color-coded cell references Tag: 770127
Hiding Results of Answers for a Quiz
Hi,
Looking for some help here please.
I currently have a quiz set up, with simple questions in the A Column.
The delegate places their answer in the B Column, and the C Column then
states whether it is correct or not.
Used the following formula :
=IF(B2="A","CORRECT",IF(B2="","",IF(B2="B","INCORRECT")))
What I need, is for the formula to only be applied once the delegate
indicates that they are finished the whole test. (i.e. clicks a cell marked
as a "Finished" button).
I need to know 2 things:
1. How to set up a cell like a "finished" button for example.
2. How to get the formula not to apply until the finished button has been
selected.
Any help would be greatly appreciated!!
Thanks! Tag: Color-coded cell references Tag: 770126
Shared document will not open for user
Hi,
I have a user who is using Excel 2003 on Windows XP. She has a shared
workbook that is password-protected on a shared drive. Everyone who
has access to the spreadsheet can open it, except for her. It is only
this spreadsheet. Her password works fine on other spreadsheets and
documents. (This is Excel-level password protection, Tools >
Protection >Protect Workbook. )
There is no error message. She enters her password, and a blank
instance of Excel opens. Any ideas about how to fix this?
Thanks!
Kim Tag: Color-coded cell references Tag: 770121
auto fill rows in Excel 2007
I have a worksheet containing plant information. Each plant has a unique
code in column 1. The adjacent cells in that row contain information about
that plant (size, color, latin name, etc.)
When I create a list for a new job, I'd like to be able to input an existing
code in column 1 of a new worksheet (or even blank space in the existing
worksheet) and have Excel 2007 automatically fill in the adjacent cells.
Any help would be greatly appreciated. Tag: Color-coded cell references Tag: 770114
Delete duplicates?
I have the following code below. How can I include sheet "customers2" also in
the code?
Private Sub CommandButton99_Click()
Dim iRow As Long
Dim FirstRow As Long
Dim LastRow As Long
With Worksheets("Customers")
FirstRow = 2 'headers in row 1
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
For iRow = FirstRow To LastRow Step 1
If Application.CountIf(.Range("a1").EntireColumn, _
.Cells(iRow, "A").Value) > 1 Then
'it's a duplicate
.Rows(iRow).Delete
End If
Next iRow
End With
Unload Me
End Sub
thank you
--
kk Tag: Color-coded cell references Tag: 770112
Recording Macro
Dumb question....
If you have recorded a macro, later wish to add 1 or more steps to it, is
there a way to just add to the recording, without having to write or cut and
paste code into it? Tag: Color-coded cell references Tag: 770110
Obtain numeric from alphanumeric string
What is the easy method of obtain numeric from alphanumeric string in an
excel column:-
ab 0.25 I want 0.25
jds 0.125 I want 0.125 Tag: Color-coded cell references Tag: 770098
Cell Format on Imported Data
I have imported data from Oracle (using programing, not import). This is a
large file and it brought all numbers over as text. When I choose the column
and fomat as number nothing happens. I have to choose each cell change
format and enter. This is impossible as there are thousands of numbers to
change. HELP.... Tag: Color-coded cell references Tag: 770096
Finding files in a folder. Variable not defined error.
I am getting a variable not defined error on this line "For Each c In
lstrng.Cells" and I can't figure out what that means. Any ideas?
Set lstrng = Range("A2:A" & Range("A2").End(xlDown).Row)
Set fs = Application.FileSearch
'Use Microsoft Scripting runtime.
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFolder = objFSO.getFolder(UserForm1.txtFolder.Value)
'Check type of file in the folder and open file.
For Each c In lstrng.Cells
c.Activate
If c <> "" Then
With fs
.LookIn = f
.SearchSubFolders = True
.Filename = c.Value
If .Execute() > 0 Then
For i = 1 To .FoundFiles.Count
c.Offset(0, i + 1).Value = .FoundFiles(i)
Next i
Else
'MsgBox "There were no files found."
End If
End With
ElseIf c = "" Then
Exit For
End If
Next Tag: Color-coded cell references Tag: 770090
Formula for calculating time off
My company is going to a PTO or Paid time off program and employees
will start to ecru time bas3ed on years of service. I am having
difficulty creating a spreadsheet to do this becasue of all of the
variables involved. I was hoping maybe you woudl have some ideas here
that I could poach.
Here are the variables. It is all based on calendar years. So if a
person started in 2007 on 12-30, as of 1-1-2007 they woudl be at the
rate of 1 year since this is when their anniversary falls. Not only
are people ecruing time, but there is also a max time that they can
have. I will put in a crude table to expalin.
Years Weekly Accrual Max hrs
0 1.538461538 120
1 2.153846154 152
2 2.461538462 168
4 3.230769231 248
Then people will use time out of this banked time. I have formulas
that will put the time in, but will not change for the next years
eccrual rate.
Please Help,
Jay Tag: Color-coded cell references Tag: 770088
consecutive dates
i have a scheduling spreadsheet, and need a way of having the dates run
consecutively instead of having to manually type each one, i.e mon 03/03 tues
04/03 weds 05/03 thurs 06/03 fri 07/03 mon 10/03 tues 11/03 weds 12/03 thurs
13/03 fri 14/03 and so on and so on, thanks, marie Tag: Color-coded cell references Tag: 770083
Location of MS Query Application
I often use MS-Query 4 extracting data from closed files and run the queries.
Where can the MS-Query application be located as I want it's Icon/shortcut 2
be made?
Thanx
--
Best Regards,
FARAZ A. QURESHI Tag: Color-coded cell references Tag: 770082
Filtering in Validation
I am creating a scheduling system for an EMS service. I have a single list
of employees (AA:AB) that I can use to create a LIST via validation.
AA:AA = Employee Name
AB:AB = Certification ie P=Paramedic, I=Intermediate, B=Basic, D = Driver
I want to filter based on certification in the validation option so that
only paramedics appear for the medic shifts, etc. Is there a way to filter
within the validation or do I have to create four separate lists?
Thanks,
Les Tag: Color-coded cell references Tag: 770080
Macro - Insert column with VLookups
Hi All
I need to analyse out a transaction listing based on the account codes.
I have set up VLookup tables but I would like to have a macro that would
insert the columns with the formulas. The range will be dynamic.
E.g.
Account Number Insert 1 Insert 2 Insert 3 Amount
111 Vlookup(1) Vlookup(2) Vlookup(3)
222
Thanks in advance Tag: Color-coded cell references Tag: 770073
linking and transposing two worksheets
I am having trouble creating a link between two worksheets.
I have essentially copies of the same worksheet but one is horizontally
arranged and the other is vertically arranged. I want to be able to update
either one of the worksheets, and then excel to automatically update the
other. I have tried linking them but as in one the data is horizontally
arranged and the other is vertically arranged it doesn't work.
I have tried creating a new workbook and using this formula;
=INDEX(.....COLUMNS($A:A),ROWS(1:1)) but this only seems to coppy and I
cannot update both sheets by inputting data into another?
Does anyone have any other suggestions? Thank you!! Tag: Color-coded cell references Tag: 770071
mouse locked in "drag mode"
Here's an odd situation that I've run into in my excel '03...sometimes, not
all the time, the mouse will lock itself almost as if I'm holding down the
left button and dragging it around. I can't get it to let go of the origin
cell and wherever I move the mouse from the origin cell it "paints" the drag
pattern. Anyone ever run into this one before? Tag: Color-coded cell references Tag: 770067
Scheduleing Employee Twice
I just recently posted with a question about a formula to not be able to
schedule an Employee if they requested a day off, and it worked great. Thanks
to T. Valko.
They gave me the formula =MATCH(A3,B$5:B$23,0) to assist on my question.
I was wondering if I need to use the same basic formula for my next problem
area. I have tried using it, but to no prevail.
Question:
In cell B4:B23 I have a list of all the Employees for that DAY SHIFT and
what times they come in, as well the position they work. (a drop down menu is
in use to select employee names)
In cell H4:H23 I also have a list of all the employees for that NIGHT
SHIFT what times they come in, as well as position they work. (a drop down
menu is in use to select employee names)
I would like to know if there is a way to prevent a user from scheduleing
the same employee twice in a day in two different positions. We have had
problems in the past where the Manager scheduled an employee twice in the
same day, and we were left short handed. Of course we have some employees
work between shifts so they are oviously going to be on both shifts; as well
as splits. (no problem there is it shows that we have an employee scheduled
twice in that sense). Tag: Color-coded cell references Tag: 770066
comment (with little red triangle) appearing in pivot table
Hi, if i insert a comment in my source data (using the 'insert commment'
function with little red triangle), and then do a pivot table on that data,
is there a way to have the comment appear with the data in the pivot table??
I can understand it would be hard when data cells are summarised or totalled
etc in the pivot table, but where individual data cell infomation from the
data source is presented in the pivot table, i just thought there should be a
way to have the 'comment' to appear as well as the cell information.
I'm using excel 2003
thanks in advance
Peter Tag: Color-coded cell references Tag: 770054
macros help...
I have a vertical list of 4 digit numbers that I want to add a zero(0) to the
beginning of the number. For example a number might be 3324 and I want to
add a 0 to the left of the 4 digits to end up looing like 03324. The problem
is this: This vertical list of numbers is almost 1200 lines deep. Some of
the numbers in this list are already 5 digits, whcih is what I want. I need
every number on each line to be 5 digits long. I did create a macro to add
the 0 to the 4 digit number, then drop down to the next line, but when I run
the macro again for the next line, it changes the number on the next line to
the same number on the line above. I want to be able to start in a cell, hit
Ctrl G and have it add a 0 to the 4 digit number in that cell, then drop down
a line and allow me to hit Ctrl G to do the same thing to the 4 digit number
in that particular cell.
The left column in the spreadsheet looks like this:
2345
2365
2476
2490
And when I get through I want it to look like this:
02345
02365
02476
02490
What it is doing now is this:
02345
02345
02345
02345
It's changing each number in each row to look exactly like the number in the
first row. I would appreciate any help anyone can offer. I used to use
Lotus 123 and did not have this kind of problems. Thanks in advance for any
advise or solutions. Tag: Color-coded cell references Tag: 770049
Excell 2003 / 2007
I downloaded the test-drive version of Excell 2007. Since the expiration has
expired, all my Excell files are saved as 2007 as read-only. Does anyone
know how I can convert those files back to 2003? I read a posting that said
save them as a 2003 file. How do I do that? I appreciate any assistance. Tag: Color-coded cell references Tag: 770047
Name Conflict
I recently install Office 2007. I have Excel files created in Office 2003
that I can not open. I get a message box: "Name Conflict" "name cannot be
the same as a built-in name". Then below that message is: "old name:
Print_Titles" ,then below that a box to enter "New name:" I'be tried
everything I know.
--
Roger Tag: Color-coded cell references Tag: 770046
how to filter spreadsheet by multiple variables?
I know I can use autofilter to find certain criteria that exist in
rows within the same column. Is it possible to sort by mutiple
variables, like 2 or 10? Say I have a column with variables a-z. Is it
possible to filter all the rows with b,c, j, p and x? Tag: Color-coded cell references Tag: 770044
is there a way to make info from one cell migrate to another cell
I'm not sure how to describe this. I have a row of information and
some of the cells need to change daily. I'd like to keep a record of
the info for the past couple of weeks. Right now I'm doing the tedious
work of cutting and pasting the info in each cell before I change it.
is there a way to get the info from one cell to migrate to another
cell immediately after I type it, then the next time I type in the
cell for the info to migrate to the next successive cell? Tag: Color-coded cell references Tag: 770039
Error when opening an excel file
I get an error whenever I try to open an excel file attached to an email or
from the folder (if I open my computer or my documents). In both cases is
says the that file cannot be found. I do not have a problem opening an excel
file if I open the excel program first. Tag: Color-coded cell references Tag: 770037
How do I make ETrade's DDE addin work in Excel 2003 and Vista?
I used to use ETrade's DDE (Dynamic Data Exchange) addin with Excel 2003 on
Windows XP, but now that I have upgraded to Vista, the ETrade add-in menu no
longer loads up, even though I can see the add-in in Tools-Addins. Tag: Color-coded cell references Tag: 770034
Macro in excel/ced
I have a macro in Microsoft Excel listed below. I need for it to repeat
until xxx is entered. Any help will be appreciated.
Sub OptionExplicit()
'
' OptionExplicit Macro
' Macro recorded 3/10/2008 by Student Financial Aid
'
Dim vName As String
Dim vAddress As String
Dim vCityStateZip As String
Dim vPhoneNumber As String
Dim vEmailAddress As String
Dim vRealEstateAgentAndCompany As String
Dim vxxx As String
vName = InputBox("Please type in your name?")
If vName = "xxx" Then
Exit Sub
Else
vAddress = InputBox("Please enter your address?")
vCityStateZip = InputBox("Please enter City, State and Zip?")
vPhoneNumber = InputBox("Please enter your Phone Number?")
vEmailAddress = InputBox("Please enter your Email Address?")
vRealEstateAgentAndCompany = InputBox("Please enter your Real Estate Agent
and Company?")
Worksheets("Sheet1").Range("B1") = vName
Worksheets("Sheet1").Range("B2") = vAddress
Worksheets("Sheet1").Range("B3") = vCityStateZip
Worksheets("Sheet1").Range("B4") = vPhoneNumber
Worksheets("Sheet1").Range("B5") = vEmailAddress
Worksheets("Sheet1").Range("B6") = vRealEstateAgentAndCompany
'
Range("B1").Select
Range("B2").Select
Range("B3").Select
Range("B4").Select
Range("B5").Select
Range("B6").Select
vName = InputBox("Please type in your name?")
vAddress = InputBox("Please enter your address?")
vCityStateZip = InputBox("Please enter City, State and Zip?")
vPhoneNumber = InputBox("Please enter your Phone Number?")
vEmailAddress = InputBox("Please enter your Email Address?")
vRealEstateAgentAndCompany = InputBox("Please enter your Real Estate Agent
and Company?")
Worksheets("Sheet1").Range("B11") = vName
Worksheets("Sheet1").Range("B12") = vAddress
Worksheets("Sheet1").Range("B13") = vCityStateZip
Worksheets("Sheet1").Range("B14") = vPhoneNumber
Worksheets("Sheet1").Range("B15") = vEmailAddress
Worksheets("Sheet1").Range("B16") = vRealEstateAgentAndCompany
'
Range("B11").Select
Range("B12").Select
Range("B13").Select
Range("B14").Select
Range("B15").Select
Range("B16").Select
End If
Application.Goto Reference:="OptionExplicit"
End Sub Tag: Color-coded cell references Tag: 770029
Why are my page layout options grayed out?
I am new to the 2007 version and cannot figure out why MARGINS, ORIENTATION,
and SIZE are grayed out under the Page Layout tab. I have tried copying and
pasting to new workbook but still not working. Any suggestions? Tag: Color-coded cell references Tag: 770022
Adding to a formula
I am trying to add a cell from one worksheet to a formula in another
worksheet but it just shows the forumula in the total box instead of the
figure what am I doing wrong?
--
Jooles Tag: Color-coded cell references Tag: 770021
Comparing Spreadsheets - best practices
I have two spreadsheets that contain names, addresses, telephone numbers,
etc. of prospects. Both sheets have about 4000+- contacts. I want to
compare the two and accomplish a couple things but i'll just start with the
first and go from there:
I want to see what companies are found on both lists so that i can compare
the names and addresses and update one list against the other (one is new and
one is old).
Any ideas on the best way to go about this? Tag: Color-coded cell references Tag: 770018
ROUNDING IN EXCEL
I have a customer who wants calculations Rounded per the requirements of
ASTM E29. Does anyone know if Microsoft Excel complies with ASTM E29 when
numbers are rounded?
Thanks
Paul Tag: Color-coded cell references Tag: 770017
I've lost the color highlights that show which cells my total refenences when
I double click on the total, anyone know how to get them back?