A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Excel Programming Forum Tools Search this Forum Feed Icon
  Rating Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Create if partial match then copy and paste data from one cell to another by theaxemonkey@gmail.com
Hello, Hopefully, I can explain this well which is probably half the challenge. What I am trying to accomplish is a bit complicated. For the purpose of...
September 22nd 13 08:06 AM
by Auric__ Go to last post
1 414
Get/Find criteria and copy sum by Living the Dream
Hi all I know the subject title is a little vague, so here goes. What I would like to achieve is: One of the DC points that gets trucks actually unloads...
September 22nd 13 03:36 AM
by Living the Dream Go to last post
2 330
remembering the same filtering criteria by baha17@gmail.com
Dear All, I would like to know that is there any way of recording criteria when I filtered data. For example; A1,A2,A3,A4,A5,A6,A7,A8,A9,A10 and A11 I have...
(Multi-page thread 1 2)
September 21st 13 10:05 AM
by baha17@gmail.com Go to last post
13 457
Excel 2007 Adding Template Sheets and Invalid Name Error (#NAME?) by JohnWEngle
I have a workbook (.xlsm) that gets built by adding in template sheets (.xltx). There are numerous template sheets that can be added depending on the needs...
September 20th 13 10:05 PM
by jerfka Go to last post
1 310
ActiveCell on inactive sheet by witek
is there a way to find out which cell will be ActiveCell when sheet is selected without selecting it? Each sheet remebers last position of active cell so...
September 20th 13 04:37 AM
by GS[_2_] Go to last post
8 441
A data validation question by Portunus
I'm trying to understand how/why Excel does this and would like to know if there is a way to do this differently. Here is my scenario Column-A contains...
September 20th 13 02:25 AM
by witek Go to last post
1 264
Snag in invoice generator. How to change the "series" by Howard
I have made some modifications to this code I found by McGimpsey. Say the invoice number gets to a certain number, then I want to be able to change the...
September 19th 13 09:58 PM
by GS[_2_] Go to last post
5 322
Sequential numbering formula by Joe PSAV
I have a list of Session names in column A (could be just 1 or more then 25). I would like a formula that looks a column A and if A1 is the same as A2 then...
September 18th 13 08:00 PM
by Joe PSAV Go to last post
2 249
text wrap merged cells by Robert Crandal[_2_]
So, if it's not possible to use text wrap in merged cells, does that mean I need to use VBA code to programatically enforce text wrap??
September 18th 13 07:59 PM
by Claus Busch Go to last post
1 205
linking sheets and workbooks by carolina.vl@gmail.com
Hi - I know this is pretty basic but I need to have data from one sheet in one workbook, linked or somehow automatically populated (copied) into a Master...
September 18th 13 06:39 PM
by carolina.vl@gmail.com Go to last post
0 234
The Placement property does not seem to be working. by shorepointln@gmail.com
I have created an active X command button on a worksheet and set its Placement Property to 3 which means "free floating" (Do not move or re-size with...
September 18th 13 05:22 PM
by GS[_2_] Go to last post
6 271
Delete all, but the last 23 lines of an external text file by Charlotte E.[_3_]
Hi Guys, I have a workbook that write a new line to an external (text file) log each day. This works fine no problem here... But we really only need to be...
(Multi-page thread 1 2)
September 15th 13 01:32 AM
by GS[_2_] Go to last post
12 816
Find/Replace MSWord wildcard characters from within Excel by Susan
Excel 2003, Windows XP This code, based in an Excel workbook, retrieves words from Microsoft Word (Word 2003). But first it strips out all punctuation. I'm...
September 14th 13 08:06 AM
by GS[_2_] Go to last post
6 493
Open to modify by kardifflad
I'm hoping this is an easy one for someone. I have a macro that writes data to an archive sheet every time a button is pressed. This works fine. However I now...
September 13th 13 11:53 PM
by GS[_2_] Go to last post
3 277
SQL not importing records from ACCDB by Steven North[_2_]
I'm struggling trying to figure out why the SQL is constantly returning 'no records'. It's essentially the same as MS Query. Except in the MS Query it's...
September 13th 13 03:26 AM
by Steven North[_2_] Go to last post
2 314
this action will cancel a pending refresh data command by Emma Hope
Hi All, Hope you can help. I have a number of workbooks with large numbers of sheets with MS Queries to Access databases each also have a number of sheets...
September 11th 13 11:18 PM
by tylerlohman@gmail.com Go to last post
2 1,442
SQL data from VBA - Sort into groups via heading. by djforgone@gmail.com
Hi Everyone... I am trying to figure out how to go about doing this. I want to build an Excel Finance Reporting Template that will import GL transactions...
September 11th 13 07:35 AM
by GS[_2_] Go to last post
7 427
macro find and delete duplicates in a spread sheet. by Marc[_18_]
Hi, Does anyone know, or point me in the right direction, how to have Excel find duplicate cells and delete them. For example, I have 2 columns of numbers. ...
September 9th 13 09:28 PM
by GS[_2_] Go to last post
5 320
Similar Book to Book Code, one works other does not by Howard
Thanks to Claus for these two codes. Normally you would have the "Copy WkBook To" open and both codes work well. I added the open "Copy WkBook To" code line...
(Multi-page thread 1 2)
September 9th 13 02:01 PM
by Howard Go to last post
11 485
Select Case code error by Howard
This errors out as "Case without Select Case" on the Case Is = "Beef". I first wrote the code for Swine only, just one case and it worked fine. I added the...
September 7th 13 11:49 AM
by Claus Busch Go to last post
8 437
Post New Thread

Display Options
Showing threads 1001 to 1020 of 174006
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 06:44 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.