VLOOKUP the right choice?
Sorry for reposting but
Still having trouble.
Column A is (A2:A130), ascending, and is my Vendor list and is named
"VendorList" and resides on a worksheet named "Lists".
Column C (worksheet named "Lists") contains the addresses to the Vendors in
column A and are aligned by rows.
G12, on a worksheet named Purchase Orders, is a drop down list and is tied
to "VendorList" on the worksheet named "Lists".
When I make a selection in G12 (worksheet named "Purchase Orders"), I want
G14 (same worksheet) to display the appropriate address.
I am thankful for all your help. Tag: How can I create a check box in an excel template Tag: 505968
Odd result when copying functions
Usually, to post in this NG, I copy formulas from the function bar and paste
them into a message here.
However, IF I (in Excel 2007)
Select Show Formulas
Enter <alt-ENTER> into the formula so it will split over two lines in the
function bar
Copy the formula from the CELL (and not from the function bar)
the result is as below:
"=MID(A1,FIND("","",A1)+2,FIND(CHAR(1),
SUBSTITUTE(A1,"" "",CHAR(1),2))-FIND("","",A1)-2)"
If I copy the same formula from the function bar, then:
=MID(A1,FIND(",",A1)+2,FIND(CHAR(1),
SUBSTITUTE(A1," ",CHAR(1),2))-FIND(",",A1)-2)
I might have thought this was by design, except that without the <alt-ENTER>,
copying from the cell does NOT result in the quoting and double-quoting:
=MID(A1,FIND(",",A1)+2,FIND(CHAR(1),SUBSTITUTE(A1,"
",CHAR(1),2))-FIND(",",A1)-2)
Is this a bug?
If so, can someone report it to the appropriate people?
--ron Tag: How can I create a check box in an excel template Tag: 505967
Looking Up the Answer by Row and Column
I'm so new to excel that even though I know how to create some functions, I
do not know the terminology, so I don't even know what to ask to get my
answer. Bear with me.
Imagine a table: Down the leftmost column is "Apples" "Pears" "Oranges", and
across the topmost row is "Retail Price" "Quantity" "Our Cost". The rest of
the table is filled with the appropriate numbers, so when i look at it I can
easily see what "our cost" for "pears" is, or what the "quantity" of
"oranges" are.
But say I want it to be that easy for a spreadsheet user: Somewhere on the
same worksheet I have two cells, one cell to enter the name of the fruit, the
other cell to enter the property of the fruit (property may not be the right
word). But the user enters "pears" in one cell and "our cost" in the other
cell. The gears turn and out pops the appropriate response (say "$1.25") in
another cell. How do I do that?
Another table would be one that most of us remember seeing on maps: the
distance between two cities. Along the left is listed a number of cities,
and along the top is that same list of cities. To find the distance between
"New York" and "Las Vegas" you simply had to finger across one city's row and
down the other city's column until your fingers met and that was your answer.
So how do I simply do this in excel if the user types in "New York" in one
cell and "Las Vegas" in the other?
Thanks. Tag: How can I create a check box in an excel template Tag: 505961
Duplicate sheet, autonumber sheet, record data on another sheet
Hi,
I've had so much help in this forum over the last few days, i'm going to
push my luck now.
I have a master/template sheet, which needs to be copied, the new sheet
autonumbered and certain data recorded. This is for quotes I have to give to
customers on a daily basis. This is what i want to do:
1. First I want to be able to start on the template sheet everytime a new
quote has to be opened. In this sheet is a field for document number. The
new sheet has to add 1 to this number (initially) thereafter to the last
sheet that was saved, in order to keep a sequence of quotes. How? What would
be the simplist practical - to open a new sheet or workbook? If possible, I
would want that new document number to become the tab name of the sheet.
2. Certain cells in every sheet need to be recorded in a different (summary)
sheet where i can ceate a list with the details of clients we quoted for -
say about 12 cells in every sheet need to be listed in columns.
Please help Tag: How can I create a check box in an excel template Tag: 505959
Question on breaking on cell into three seperate
I am currently searching for a method to do a similar formula in excel.
I currently process around 120 students every 2 weeks into classroom databases. Currently when we recieve the spreadsheet, the names of students show as:
last, first middle initial in cells A1-A120.
I was wondering if there was a way to create a formula to break this cell down into three cells one for first, one for last and one for middle inital.
Example...
Smith, John C.
would be in cell A1
How could this be broken down into three seperate cells B1, C1 and D1?
I tried basing this off the above suggestions but peoples name have different lengths so I need a way to seperate them by commas and periods. any suggestions would be appreciated. Thanks Tag: How can I create a check box in an excel template Tag: 505957
Excel data formatting
I would like to swap the data in an Excel spreadsheet by changing the
columns to rows, and the rows to columns, For example:
This: 1 2 3 Would become this: 1 4 7
4 5 6 2
5 8
7 8 9 3
6 9
Is this possible, and if so how can I do it? I have a large amount of
data and performing this by hand would take an extreme amount of time.
Any assistance you can provide would be appreciated.
--
jreinier Tag: How can I create a check box in an excel template Tag: 505946
Why Can't I navigate Excell 2003 Worksheets via Navigation Bar
I can left click and choose a worksheet at the navigation bar but I cannot
use the arrows to move either between worksheets or to the first or last
worksheet Tag: How can I create a check box in an excel template Tag: 505942
Function/Formula Question
Example:
I have a drop-down in A1 with 5 options (A, B,C,D,E)
I need to be able to have a formula that looks at A1, and if it's value is
"A" (from the drop-down) then place a "1" into cell B1.
I am trying to perform this without a formula residing in B1 because a
calculation is being performed on the value of B1. If the formula is there
and the value is displayed, the calculation fails because it sees the formula
instead of the value.
The formula I use to display the value is:
=IF(A1="A","1",IF(A1="B","2",IF(A1="C","3",IF(A1="D","4",IF(A1="E","5")))))
But, I need the end result to be a number that can be a part of another
calculation.
Help! Tag: How can I create a check box in an excel template Tag: 505940
How to: If G12=A2 then C2...or if G12=A3 then C3 and so on 30 time
How do I create a formula to have cell show the value in C2 or C3 or C4
etc...based on what is in A2 or A3 or A4 etc... EG: If (G12=A2 then C2)...or
if (G12=A3 then C3)...or if (G12=A4 then C4) and so on as many as 30 times. Tag: How can I create a check box in an excel template Tag: 505931
what does this forumla mean?
I got this forumla:
=SUM(IF(('[Title and Reg Chat Data.xls]FY08'!$C$2:$C$9000=W$66)*('[Title and
Reg Chat Data.xls]FY08'!$E$2:$E$9000=$C67),'[Title and Reg Chat
Data.xls]FY08'!$A$2:$A$9000,0))
I understand it is going to the worksheet title and reg, to worksheet fy08,
looking at the range c2:c9000- what is the = w66? As well as the = c67? I
know it is an if asking if those ranges = those cells, but what is the true
part? and how does sum fit in?
Thanks!!! Tag: How can I create a check box in an excel template Tag: 505929
Number Format?
I have entered the following in cell A1 ="Average "&AVERAGE(D:D)
and the value I get is Average 47.247619047619.
How can I round down to 1 decimal place?
I have tried number format but it does not make a difference
:-( Tag: How can I create a check box in an excel template Tag: 505923
How can I find out what date going to be 3 month from today in ex
If today is 08 NOV 2008 after Three or six months later what date going to
be. How can I create a function in MS Excel. Can you please let me know.
My e-mai is shahin512@hotmail.com
or
shahin512@gmail.com
Thanks,
Shahin Khan Tag: How can I create a check box in an excel template Tag: 505914
Summarizing updated external data
I have a basic sheet that refreshes external data based on what someone
fills in for starting and ending dates in a couple of cells. The data is
just a bunch of customer order lines that have the customer id, part, qty,
price, etc.
I want a variety of summaries of some of the data on the side of the sheeet
or where ever, but I don't know the functions to use that will do somethnig
like the following automatically.:
Date --- Avg $ --- # of Ord --- Total$ --- Total Units
1/1/08 -- $15.00 -- 20 --- $500 ---- 300
1/2/08 -- $10.50 -- 10 --- $500 ---- 100
1/3/08 -- $12.35 -- 12 --- $500 ---- 250 Tag: How can I create a check box in an excel template Tag: 505913
How do I create a staff roster in Excel?
I have to create a staff roster each month for volunteers in different
locations around the country. At the moment I had each persons name manually
to the time cell relating to the hours they can work, eg, Mon 8:00 - 12:00,
12:00 - 16:00, 16:00 - 20:00 etc. Is there an easier way? I am currently
running Office 2003 Tag: How can I create a check box in an excel template Tag: 505905
GetPivotData Question
I have the following GetPivotData formula
=GETPIVOTDATA("Sum of ProjEstV.Value",'Validated Value Pivot'!$A$6,"Status
Month","2008-04","Sum.OI Category","Other","OI Goal
Category","OPS","CloseOIYr","","Status","Assigned")
Which works fine. I just don't want to use the part
"Sum.OI Category","Other"
So I get
=GETPIVOTDATA("Sum of ProjEstV.Value",'Validated Value Pivot'!$A$6,"Status
Month","2008-04","OI Goal Category","OPS","CloseOIYr","","Status","Assigned")
which gives me a REF error. WHY?
Thanks,
Barb Reinhardt Tag: How can I create a check box in an excel template Tag: 505904
Lookup in dependent tables.
I want to identify a unique part number for a light unit given that there are
three variables associated with it. The variables are voltage, color, and
steady/flashing.
Each voltage has bulbs of different colors; each voltage and color has
alternatives of steady or flashing. So I really need to 'nest' my lookups.
However, I am not having any luck figuring out how to do it. The IF(AND ...)
function looks likely, but I would have to make a very complicated formula.
Seems I am making the atsk harder than I need to. In a way, I want to
emulate the Online Autoparts application. When you have entered the Make
(Ford Truck) the display changes and asks you for Year. Then it changes again
and asks you for Body details. Finally it changes again and asks for Engine
Size.
Any suggestions?
Many thanks. (Btw, I am using Excel 2003)
Mike Tag: How can I create a check box in an excel template Tag: 505901
Conditional Formatting
Can someone help please!
I would like to format cell colors based on values that are in the cell. The
numbers in the cells are alpha-numeric order numbers followed by a number of
days in the sytem (e.g. x12345678-14). Some cells have up to 14 "orders" in
it.
How can I conditionally format the cell if the number of days is between
7-14 (green), 15-24 (Yellow) or >25 (red). I am using Office 2007.
Thanks in advance!
-Rob Tag: How can I create a check box in an excel template Tag: 505900
tab name
please help
how do i give a tab of a worksheet the same name as a cell in the worksheet,
automatically Tag: How can I create a check box in an excel template Tag: 505899
filers in more than 1 cell
in excel i have a coloum F and it starts from F10 to F165 now how do i appile
filters to them all
i want to be able to use just use the drop down for the user to select what
departmet they need and in the drop down their is going to be a list of 17
departments
any ideas Tag: How can I create a check box in an excel template Tag: 505885
Using roundup() but on a whole spreadsheet instead of since cells
Hi,
I need to update a fairly large spreadsheet so that all numbers are rounded
up... using roundup()
Ive looked around and ive come to the conclusion i need to use VBA.
can anyone help?
thanks.
Matty Tag: How can I create a check box in an excel template Tag: 505882
sheet name
is it possible to force a cell enty as a sheet name, i.e. i have a worksheet
that i use for quoting for clients. i wrote a macro that automatically put a
new number on each sheet when it duplicate the master sheet. i would like
that quote number in the worksheet, to be used as the sheet number for easy
reference Tag: How can I create a check box in an excel template Tag: 505879
Exceel formulae
hi there!!
Am New to this discussion and its this problem that brought me to this
discussion....
its have got to adjust values in Col E to 30, if it exceeds in Col D where
Col D is sum of A, B and C..... tried alot of rubbish formulae but all in
vain...
can anyone help plz
--
arisan Tag: How can I create a check box in an excel template Tag: 505878
Comparing 2 dates and times
Hi
I have a spreadsheet with 5 columns:
A = date an e-mail received
B = time e-mail received on that date
C = date e-mail replied to
D = time e-mail replaied to on that date e-mail
E = was the e-mail replied to within agreed time limit?
The agreed time limit is 24 hours.
I'd be happy enough coming up with a formula to input Y or N into colmun E,
if I only knew how to subract a time AND date from another time and date.
Can anyone advise, please?
Many thanks.
Keith Tag: How can I create a check box in an excel template Tag: 505877
Menu options
When using excel some menu options that are not used frequently eventually
are hidden by the system until you expand the menu, however when an option is
used once that option is displayed again until the expiration of the display
period and then it is hidden again.
I want to hide options that are used infrequently, either by reducing the
waiting period to hide again or by setting the option to hide manually. This
functionallity would greatly improve my use of the product by using
keystrokes rather than pointing with a mouse.
Any ideas are greatly appreciated.
Luis Elguezabal Tag: How can I create a check box in an excel template Tag: 505876
append worksheet with data from another
I have 2 worksheets that I need to bring together into a single worksheet.
The first column of each worksheet is the "persons" ID number.
I want to append the data in worksheet 1 with the data in worksheet 2, based
upon
the ID number. The data in worksheet 2 is a mix of text, number, phone
number, etc.
Is there a single formula I can use to bring it all in based upon the ID
numbers in column A?
example...
WS1 WS2
123,Mark 157,trans,(201)646,2008 Event,Yes
124,Harry 123,mortg,(732)995,2008 Event,No
129,Dave 762,rund,(676)423,2007 Event,Maybe
129,mortg,(212)123,2008 - Trip,Yes
124,party,(919)222,2006 - Trip,No
DESIRED RESULT IN WS1
123,Mark,mortg,(732)995,2008 Event,No
124,Harry,party,(919)222,2006 - Trip,No
129,Dave ,mortg,(212)123,2008 - Trip,Yes Tag: How can I create a check box in an excel template Tag: 505873
Shading of Multiple Rows in a Pivot Table
How do you shade multiple total rows in a pivot table on one click? Tag: How can I create a check box in an excel template Tag: 505871
Email files
What I would like to do is have an excel file email my work email when
the conditional formating has been reached.
I want to create a spreadsheet that will track training in house and
after a 3 month, six month, 9 month, and 1 year time frame, i would
like the spreadsheet to email me this speadsheet at these intervals.
I dont know if it is also possible to have it only email the
individuals that have reached to time frame limits, not newly added
individuals. Tag: How can I create a check box in an excel template Tag: 505868
Summing a Column - Net and Absolute Values
I've got a column of positive and negative numbers that I want to total in
two ways :
- net - ie just natural addition which I can do with the SUM formulae
- absolute - ie the total being based on an assumption that all numbers are
positive
A slightly messy way (because of the design of the spreadsheet) is to create
an extra column of absolute values and sum that.
So my question is 'Is there are formulae I can use to do an absolute sum on
those values directly?'
TIA
Rob Tag: How can I create a check box in an excel template Tag: 505855
pivot table help
I've got a (non-pivot) table with 5 columns that looks like this:
HRG POD yr1data yr2data yr3data
HRG and POD are categories, and the figures in the 3 data columns are the
values of interest. I want to have HRG as the rows, and then I want 3 main
column headings: yr1data, yr2data and yr3data. however, there's only 5
possible values for POD, and I want each of the 3 data columns split into 5
subcolumns, each headed by a value of POD.
I can get the pivot table with HRG as rows and POD as columns, but I only
seem to be able to add the data by subdividing rows rather than columns, even
when choosing 'column area' in the 'add to' drop down.
any suggestions gratefully received Tag: How can I create a check box in an excel template Tag: 505853
Is it possible?
Hello,
I wonder if it is possible to make a sheet work in tally chart form?
I have satisfaction questionnaires that come to me periodically. I want to
know if it is possible that excel can, rather than use '1' as the answer, add
this to whatever was in there before?
For example:
Cell contains I type in Automatically it adds
together
3 2 =5
If not any suggestions on the easiest way I can record this information? Tag: How can I create a check box in an excel template Tag: 505850
count unique in non-continuous list
Hi,
Is there a way to count unique values in a list that is not continuous and
contains merged cells?
I have a list in one column which regroups data (numbers) in several
categories and each value can occur in several categories. And there are
merged cells as well.
How to count the unique entries over the entire list? The functions
mentioned in the numerous posts here do not seem to work.
Thanks,
Hans Tag: How can I create a check box in an excel template Tag: 505848
data validation
my data validation in the series of cells i "validated" with a list is there,
when i check through edit>goto>special>data validation, but the drop down
arrows don't show in that series of cells. what am i doing wrong? Tag: How can I create a check box in an excel template Tag: 505839
Can anyone assist me with a new workbook template for Excel 2003?
I have reloaded all of Office 2003, repaired Office 2003, reset all worksheet
options that I am aware of, and cannot get fill color or font colors to
display in a worksheet. Also, I have reset display settings numerous ways and
removed updates to no avail. Additionally, I have followed Office
instructions to remove sheet.xlt and book.xlt, but never found either file. I
have tried resetting XP options which I really don't understand.
This has been going on for several months and is really causing problems and
frustration. If you can offer suggestions, please contact me asap. Thank you
in advance.
Kelly Tarbell - kellyjotarbell@live.com Tag: How can I create a check box in an excel template Tag: 505834
Find Earliest Date
Hello,
I have 2 dates, not in any order. I would like to create a formula to give
me the earliest date of the 2.
Example:
A B C
1 Date1 Date2 Result/Answer
2 4/20/08 1/20/08 1/20/08
3 2/28/08 5/10/08 2/28/08
4 5/7/08 2/14/08 2/14/08
I thank you in advanced for your continued support.
--
Respectfully... Elaine Tag: How can I create a check box in an excel template Tag: 505830
Logical Test
I have extracted text data format thus i cant perform any maths calculation
on the data. Thus i tried this logical test to convert the data into number.
cell A cell B cell C
cell D cell E Cell F
4101001 NET SALES/PRODUCTS 172.641 172 641 172,641
4102001 NET SALES/MERCHAND. 641 641 0
6410
Cell C should read as 172,641 and 641. Since the value is text format,
firstly i tried to pull the interger from 172.641 and mod .641 and which
later combine these two result into number and reads as 172,641.
i write this formula on respective cells,
Cell D =INT(+$"Cell C")*1
Cell E =IF(+$C7>1,(MOD(+$C7,1)*1000))
Cell F= =(+O7&P7)*1 note *1 in formula to convert the text to number
somehow, if the value in cell C is only 641, the result in cell F is 6410.
Anyone can suggest the solution for a formula to suit these 2 situation?
thanks in advance
4102001 NET SALES/MERCHAND. 672 Tag: How can I create a check box in an excel template Tag: 505828
Insert a drop down list into an excel cell, linked to Access
I need to insert a Drop-Down list into an Excel 2007 worksheet cell, with the
data linked to an Access 2007 database. Can anyone advise please? Tag: How can I create a check box in an excel template Tag: 505827
Excel queries
Hi;
Appreciate if someone could help me with this:
I have a spreadsheet that contains a column for the user to indicate whether
they want to "Update" or "delete" the request.
Please advice whether the following can be done:
a) When the user enter the value called "update" in the cell, then the excel
should automatically change the wordings in that row to "blue" color
b) When the user enter the value called "delete", then the excel should
strike through the whole row for me
Thanks in advance. Tag: How can I create a check box in an excel template Tag: 505821
How to get the result with IF function
Hi,
Kindly advise how to get the result in return with the following condition
A B
12 10
B value must be =>1 but =< 15 will be result A value, otherwise 0.
Thanks Tag: How can I create a check box in an excel template Tag: 505820
Pivot tbl rpt-how to return text in a field vs. a sum/count value
New to pivots & discussion groups - please be kind!
Trying to use a pivot report for scheduling. On the spreadsheet I have
columns for calendar days and another column called projects. Each row on the
sheet will have a project name in the "projects" column and the volume for
the project is entered & repeated in the columns for each calendar day the
project is planned to run.
Want to be able to show all of the project names that are planned into each
Calendar day but also want to see only the projects names planned for each
day.
I have all of the Calendar columns in the row area of the report and I was
hoping there might be a way to return the text in the C&F field for each of
these calendar columns?
Expect to have several hundred projects planned over a few months. Tag: How can I create a check box in an excel template Tag: 505815
Lookup Issue
I have a problem that I require help on.
I am working on a big spreadsheet. I have to pull information from one sheet
into another. However I have 2 lookups to do. Is this possible.
example - Info Sheet
A B C
1 Manchester ABC Total -230.30
2 Manchester DEF Total +123.34
Example - Working Sheet
A B C
1 Store Name ABC Total DEF Total
2 Manchester
I need to lookup "Manchester" and "ABC Total" to give me "-230.30" in a cell.
Any Ideas if this is possible, or another solution!!
Thanks in advance
Jayz Tag: How can I create a check box in an excel template Tag: 505812
pivot table filtering not working
I have a cube that I am accessign from Excel 2007 pivot table. I have a date
dimension that I need to filter on in my reports, but excel is not completely
seeing this column as date values. It will tell me to apply a date filter,
but any filter and combo of values I use blanks out my entire result set.
When I use the revers boolean logic, I get the entire result set back,
nothing filtered out. When I select indvidual values from the multi select
box, that filters everything ok, and when I use the canned "All dates in the
period" section, that filters the data as expected as well. But of course I
need to be able to filter starting in the middle of a month and end in
another month.
Any ideas on how to either get Excel to treat the data as a Date value so it
will filter correctly, or force a lable filter up so I can use that?
thanks in advance!! Tag: How can I create a check box in an excel template Tag: 505806
how to keep a running tally of boxes filled with info
Hi, I use a spreadsheet of Excell 2007 to keep track of dates that different
individuals work. There are about 150 persons and everytime they work a day,
I put the date in the next sequencial box to the right of their name.
I need to keep a running total of the total number of boxes filled in. Any
suggestion on how to do this?
Thanks! Tag: How can I create a check box in an excel template Tag: 505803
Need to copy
I am constantly added worksheets to my excel file. How do I copy all info
including the column widths to another worksheet? Tag: How can I create a check box in an excel template Tag: 505802
Invisible Formatting ? or ... ?
I have some cells formatted in blue font & green background on my worksheet.
Is there a way for conditional formating, or some other way, to make them
invisible ? I need to provide most of the data on the worksheet to others,
but I don't want them to see those blue/green cells.
I know I could manually format them as no-fill with a white font, but I was
hoping to make it automatic, or even possibly with a macro. Any help or
assistance would be greatly appreciated.
Thanks,
Steve Tag: How can I create a check box in an excel template Tag: 505799
Multiple cell value
I am using a formula and it has 2 or 3 different cells, it like as follow:
cell A1: January, A2:CH
now I want to take a formula to use those two cells as a combine like,
Index($B4:$I9000,Match(cell("contents",$A$2),$B$4:$B$9000,0),2) --this is my
original formula now I want to change and put down a two matching cells like
A1 and A2 in the formula... How can I do this? Tag: How can I create a check box in an excel template Tag: 505798
Two-variable Data Table - Problem with result/output
Hi all. I'm having a problem with a two-variable data table. I have verified that I correctly have a formula driving the data table, and my 'base' inputs for the two variables are hard-coded in the table. I have multiple data tables in my workbook and all but this one seem to be working correctly; the table I'm having the problem with is essentially an Earnings Per Share table (specifically, what happens to EPS if the company repurchases X number of shares at X buy-back price--the # of shares repurchased and the share buy-back price are the variables).
The Row output seems to be correct - EPS decreases accordingly based on # of shares repurchased (as it costs us more $ to buy more shares, therefore, EPS should decrease); however, the column output (EPS based on buy-back price) is staying the same at all levels of the # shares purchased, when it should increase as the # shares repurchased increases (because there will be less shares outstanding to split up profit between).
I cannot figure out why this is not working...help. Tried to paste the matrix below for your reference, but the system was not letting me (rec'd a message stating 'inappropriate text found in text' !). Tag: How can I create a check box in an excel template Tag: 505791
Making formula results not visible in a cell
In my "total" column I don't want the results of the SUM to show up if there
is not an entry in the cell to the left of the SUM cell.
--
MPS Tag: How can I create a check box in an excel template Tag: 505786
intercept and slope functions
I'm using Vista and Office 2007. I have formulas using intercept and slope
calcs, but they are now coming up as DIV/0. Thre are no "0"s in the list and
I have the addins activate. What am I missing Tag: How can I create a check box in an excel template Tag: 505783
gathering multiple spreadsheets into one
I have 2 worksheets (2 individual XLS files) that I need to bring together
into a single worksheet.
The first column of each spreadsheet is the "persons" ID number.
I want to append the in worksheet 1 with the data in worksheet 2, based upon
the ID number. The data in worksheet 2 is a mix of text, number, phone
number, etc.
Is there a single formula I can use to bring it all in based upon the ID
numbers in column A?
eg.
WS1 WS2
123|Mark 157|trans|(201)646|2008 Event|Yes
124|Harry 123|mortg|(732)995|2008 Event|No
129|Dave 762|rund|(676)423|2007 Event|Maybe
129|mortg|(212)123|2008 - Trip|Yes
124|party|(919)222|2006 - Trip|No
DESIRED RESULT IN WS1
123|Mark|mortg|(732)995|2008 Event|No
124|Harry|party|(919)222|2006 - Trip|No
129|Dave |mortg|(212)123|2008 - Trip|Yes Tag: How can I create a check box in an excel template Tag: 505773
VALIDATION
while playing around, i did something that seems to have disabled my
"data-validation" drop down list in a range. it seems to have something to do
with auto fill. can anyone perhaps help? Tag: How can I create a check box in an excel template Tag: 505766
I have an order sheet template that I want to create check boxes that when
cliked on insert a check mark into the box. Does anyone know how to create
these?