How do you combine two columns to one? Help!!!!!!
I have address numbers in column A and street names in column B, I want to
combine all of both columns into one without going through the whole process
for each individual cells. HELP!!!!!!
"sttrumpet" <email@example.com> wrote in message
> I have address numbers in column A and street names in column B, I want to
> combine all of both columns into one without going through the whole
> for each individual cells. HELP!!!!!!
Use the fuction =A1&B1 in cell B1
Drag the function ...VB Code help
Here is a portion of one of my VB Macros in Excel:
If Selection.Count > 0 Then
MsgBox ("Average = ") & (RunningTotal / Selection.Count), vbInformation,
My question: How do I format the number (RunningTotal/Selection.Count) to
look like 0.000, instead of 0.0000000000000000?? What should my code look
like with the new formatting.
....Format((RunningTotal / Selection.Count), "0.000")...
mvpearl omitthisword at verizon period net
&qu...Help with formula #18
I am WAY over my head here, and you all have always been great help,
so hopefully someone can help with this. I had someone write this for
me to use as an index at the top of a spread sheet. It works
beautifully . The problem is I would like to move this index to sheet
2 of the same spreadsheet and when I copy and paste it, it does'nt
work. Is there anyone who can modify this to work as an index in
sheet 2 and will search sheet 1 for the results?
=IF(#REF!="","",IF(ISNA(MATCH(#REF!,$H$31:$H$65536,0)),"",HYPERLINK("#"&C...Help needed with Money 2003 files
Hi there, I've been using money 2003 for years even when upgrading to new PC's as I had the original disk.
I've just had to rebuild my hard drive and now cannot find the disk anywhere so cannot install Money. As you cannot now buy Money, I've tried downloading the trial version of Money so that I can access all the account details/balances but it says that they're not compatible with earlier versions of money.
Is there anything that I can do to get these files open or have I lost all my records for the last 6 years?
I'd really appreciate your assistance. Jayne
EggHead...MSFlexGrig and SQL Query
How can i load dates in a MSFlexGrid Object whit a SQL Query????
...How do I seperate 1 page into 2 in MS Publisher 2003?
I have created a "Newsletter" for my company in Publisher 2003. It is all 1
page and I would like to seperate it into 2 so that the print break doesnt
happen in the middle of text boxes.
Also how can I convert the "newsletter" into a printer friendly format. Some
people are unable to print it correctly so I would like to send it out as a
more printer friendly format. I did try converting it to a PDF but it was
then 26mb which is too big to email obviously.
Any help or suggestions would be greatly appreciated.
WolfMaster <WolfMaster@discussions.microsoft....Merging Excel Sheet with Excel Sheet (Just like in MS Word!)
Purpose: create classroom roster between one Excel spreadsheet as data
source and another excel sheet.
I know how to use one excel spreadsheet as a data source to merge with
another word document; however, by using this method, I found that the link
between the files keep dropping from time to time, especially when the folder
has been moved around.
I'm thinking of creating the same layout of the Word document in another
Excel spreadsheet and somehow "LINK" the data source and the other
spreadsheet together, but I'm not sure how, or whether thi...Need help with using a bar graph in a report
I have a report that separates information about representatives by manager.
I need the graphs to give a quick summary on a few stats from each rep but
only show for that manager's team and not all information.
Manager A has RepA, RepB, and RepC under him. Each rep has Aux1, Aux2, Aux3
information which needs to be displayed. My goal is to show Manager A with
his Reps A,B, and C of their Aux1, 2, and 3. Then, under the next manager
Header I want Manager B to show Rep D, E, and F with their Aux1, 2, and 3
information. Etc thru Manager G.
Th...Help with Userform
I need to setup a restricted means of allowing users to edit data in
existing cells on a spreadsheet through a macro (userform?). I want to
create a userform that will read data from these existing cells and display
their contents in a series of text boxes. The user will then have the
choice to edit any data item, if they need to, or leave the data as is.
Upon the user hitting the OK key on the userform, the edited data will be
entered in their previous cell locations.
Any help or examples will be appreciated!
...Parameter Query using date ranges
I am creating a parameter query where I want to pull data between 2 dates.
In the date criteria of my query, if I write between #01/01/2008# and
#01/31/2008# +1, I will get all data for January. If I use a form to enter
the dates and have Between [Forms]![autoexec]![start] And
[Forms]![autoexec]![end] +1 in the date criteria, I get an error. Does
anyone know what I should put in the criteria to make the query work?
Are you entering your dates as m/d/y?
What happens if you try:
DateAdd("d", 1, [Forms]![autoexec]![end])
Is the form open?
Microsoft Access..."New Web Query" function
are there any friends use New Web Query fuction under Data -> impor
My objective is to export (a list of stocks info) from web page t
Excel spread sheet.
e.g. the is is Microsoft's stock details (stock code: MSFT)
i can use "New Web Query" function to link this page to spread sheet.
Question: how can I define a list of stocks (let say 10 differen
stocks) that I want to monitor apart from creating 10 differen
link with each individual stock code?
any ideas are welcome
thanks for your help
...amend a PO with a query? Please help!
Our new warehouse manager entered, received and committed a PO from the
wrong vendor - over 100 items!
Does anyone know a way to either reverse the PO or change the vendor?
You can reverse the PO by opening it again in receiving mode. Use the Quick
Scan button and add an item to the PO (any item). This will 'unlock' or
re-open the PO. You can now delete the item you just added back off. Next
you would enter the quantity 'Received to Date' of each item into the
'Quantity Received' column as a negative. Fo...Please Help...I can not send/receive or delete email on outlook 2000
It gives an the following errors" Error has been detected
in the file C:|Windoews\Outlook.pst. quit all mail
applications and then use Inbox Repair tool."
I spent hours tring to find a solution on the support
section. Couldn't find it.. Thank you so much for help..
What size is yr *.pst? OL prior to 2003 can have problems when greater than
The inbox repair tool is scanpst.exe
If oversize; http://support.microsoft.com/?kbid=296088
"Daniel" <firstname.lastname@example.org> wrote in message
> It gives an the follow...Need help with setting IFrame script
I got the perhaps overly ambitious idea of customizing the Account screen to
load the map and directions from our office to the customer site. I am using
the DirectionsFind url, though I may switch to MapQuest if I can find the
parameter list. Which I use, however, is a moot point if I can't figure out
how to make it work in an IFrame.
command for generating the map and directions from one point to the next. I
know the command works because I've pasted the results into my browser and it
brings up the corre...help, derag won't work and the outlook folder shows 36000 fragmnets
defragmented and the program works fine but when it finishes it looks the
same on the as the original analysis. Then I look at the report and it list
a lot of files that can't be drfragmented. The only thing I can think of is
that this pc was once on MSexchange (the reason I mention it is that the
outlook pst which is 1.8 gigs, shows 36000 fragments and it is located in
the c/exchange folder) Anyway, what do I do??? how can I get the drive to
When you open IE\Properties\Programs what do you see in there under E-Mail
box. Use the dropdown arrow and take a peek on ...SQL Server (XML Data) Through ODBC to MS Access
In one database in my company.
Previously the data in SQL Server, the tables were simple text and
number formats and it was easy for me to link the data through ODBC to
MS Access and I could do all sorts of queries and calculations, etc.
But, now (after several months) I realize that the DBA and Programmer
changed, the data in SQL Server to be XML Data Type in the new setup.
In SQL Server.
and so on.
and I see the data in Access (through ODBC) for one of the fields of
the above table like this:
...Using SQL Query to mass update a field.
Having a problem in eOrder where the pictures are not showing up. I found out
the Inventory image in internet information is mapped to a drive letter. If I
remove the drive letter, I can see the picture in eOrder. I would like to
mass update the SY01200 INET4 field and change all from f:\inventory
pictures\image.jpg to image.jpg (where image.jpg is the file name). It sounds
like I need to create a cursor script but am not sure how to do this. Can
anyone help me with this?
Backup you data first.
You might be able to use DTS to trim the data with a string transformation.
Or you ...MS Excel does not interpolate empty cells
Trying to plot a contour map of a film thickness. The substarte is round.
X/Y coordinates are not in a grid so the data table has several empty cells.
Trying to use 'Tool/Options...', 'Chart' tab and selecting the 'Interpolate'
radio button does nothing. The chart treats the empty cells as zero value.
If it would interpolate I would be happy.
I also tried this with a grid (square) X/Y table with a couple of empty
cells and again, it did not interploate.
If the cell contains a formula like =IF(A1=0,"",A1), then that cell is
neither empty nor blank. I...How do i insert a Address Bar kind of drop down list within MS Exc
I wonderr if anyone can tell me if i am able to insert into an excel
spreadsheet an address bar drop down list (like in windows explorer) to view
and select the necessary drives, and make this particular cekk work like a
pointer to changing the default path of where my macro searches for a
AT the end is some code that will browse and reset the folder, and use this
code to add a button to your standard toolbar
Dim oCtl As Object
Set oCtl = .Controls.Add(Type:=msoControlButton)
oCtl.Caption =...Please help
Only one of my users (who us utilizing IE8) is getting the following
error when creating a new Timesheet in PWA
'g_oMainForm_name' is null
or not an object
Many other folks are using Timesheets - some with IE8 - and it works
fine. This is the only user so far who has reported this.
Any help would be greatly appreciated.
Maybe this will help: http://allfaq.org/forums/t/136987.aspx
> Only one of my users (who us...Help in macro in excel.
I want to write a macro in an excel sheet wherein I want to copy a few cells
from my source worksheet and paste their hyperlink to another worksheet.
Also, the destination worksheet's cell number where this is pasted is not
fixed. How do I accomplish this?
Please help urgently.
Running the macro recorder whilst inserting a hyperlink yields this code:
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Sheet1!A1", TextToDisplay:="""go to hell"""
Now just substitute the relevant stuff into e...HELP PLEASE!!! #2
This is a multi-part message in MIME format.
how do i get this background off this?? im very new...
<!DOCTYPE HTML PUBLIC "-/...Help creating a list
I have a list of values in a single column. Many of the values are
repeated. I need to create a list from this, where each value only
appears one time, and capture in a new tab.
Example Tab 1:
2008 Record A
2008 Record A
2009 Record B
2010 Record B
2010 Record B
Result Needed in Tab 2:
2008 Record A
2009 Record B
2010 Record B
Appreciate any help....Thanks
...Problem with MS Visual C++ 7.0 getline function
I get this error each time I use the getline function. I am using MS
Visual C++ 7.0.
error C2780 :
_Elem)':3 arguments attendus - 2 fournis
error C2780 :
_Elem)':impossible de d=E9duire l'argument de mod=E8le de
'std::basic_istream<_Elem,_Traits>...my excel does not work properly, please help !!
i got all the Microsoft office programs on my laptop.
Excel use to work perfectly, till last week or so. when i open it or open an
excel program; it opens as if its " INTALLING " excel. it gathers information
to install it then it says File could not be found on C:\Program Files\
then it asks me to BROWSE to look for the file.
please help me, i need excel to work very soon.
p.s. i had the office CD back home .. im in another country for couple of
months. and you know how much it costs to buy a new 1. help me ....