Date format issue when submitting from a userform to a spreadsheet
I have a userform that I've generated which routes dates onto a spreadsheet
based on the users input. I am having a bit of a frustrating time with the
dates, it would appear that in the process of moving the date from the
userform to the spreadsheet some dates are switched/transposed. I'll give an
example. If someone enters 09/02/2004 on the userform excel seems to look at
09 and assume it is a month and transposes the dates to 02/09/2004(this does
not appear to be a US/UK format issues as I have already gone down that
road). However, if the date 13/09/2004 is entered i...Sorting Alphanumeric values in a text field
I'm using Access 2003 for a database for my company. I have a field in a
table that has both text and numbers. They are part numbers, for example
21BC124. I kept the field as text because of the text with in the numbers
and didn't figure that a numeric field would alow the text. In my part
numbers table it sorts correctly (first by number then by letter then by
number again), but in my reports and queries there are a few number that sort
in the wrong place. Like this...
I can't quite f...Exporting file names to an excel spreadsheet.
I have a folder containing many many many .pdf files.
Is there a way to export the filenames of these .pdf files into an
If this is a dumb question, I apologize. I didnt have any luck
searching for the answer here.
Kepf's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30611
View this thread: http://www.excelforum.com/showthread.php?threadid=547520
I use Jim Cone's fine Add-in called "ListFiles"for this sort of thing. It's
available free (a...Move/Copy A Row Based on Formulas to a New Worksheet
I want to move several rows of sub-totals (averages within sub-groups) to a
summary worksheet, but I get the Ref error. How can I copy sub-group averages
to another worksheet?
high light and copy.
select where you want it.
this will turn you formulas into hard numbers.
you are getting the #Ref error because on the other sheet
where you pasted the formulas, the formula no longer had
the same references that they had on the other sheet.
=sum(a1:a10) in cell a11
you copy and paste on another sheet at cell a1.
excell tries to compensat...excel spreadsheet
How do I delete columns from my spread sheet? When I right click the word
"delete" isn't highlighted, so it doesn't work.
Is the sheet protected or shared?
Please keep all correspondence within the Group, so all may benefit!
"Ang" <Ang@discussions.microsoft.com> wrote in message
How do I delete columns from my spread sheet? When I right click the word
"delete" is...preview text disappears when email is opened
When someone responds to an my email, I can see what they have typed - until
I open the message - then only my original message is viewable. The preview
pane shows new message text when email arrives, hoever when the email is
opened the preview text disappears - and I just see the earlier part of the
message which I had sent.
If I mark it as unread it does not return to the previous state.
This seems to happen on email responses that people have received and
answered from a webmail service not that they downloaded and opened in
outlook on their PC
OL'03 XP pro sp2
Respectfully,...How can I wrap text across merged cells?
I'm using Excel 2000. I have a set of merged cells A5-
E5. I have several lines
of text in the cells and I want them to wrap across the
merged cells and it is not working. All I get is the
first line of text showing and the rest is cut off. It
works if the cells are not merged, but I really need to do
it in my merged cells. Is there a way to this other than
manually resizing the height of the row?
Instead of merging cells, have you tried the "Center Across Selection"
The appearence is just about identical to what you would get using merged
cells, although I d...enable java in spreadsheet
I have read most of the threads that ask about enabling java i
excel...but would appreciate a very clear idea of how to do it.
Can Com Add-ins enable java?
dismas's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1106
View this thread: http://www.excelforum.com/showthread.php?threadid=27659
what do you mean exactly with 'enable JAVA'
"dismas" <email@example.com> schrieb im Newsbe...How do I get text to copy from one cell to another ?
Type = in the target cell. MouseClick the cell containing text. Pres
BrianB's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=5
View this thread: http://www.excelforum.com/showthread.php?threadid=27034
...if statement with text
I am trying to create an if statement where the string of text contains
total, if yes then perform calculation base on that row and column. if no
total in text leave blank
FIND returns #VALUE if "Total" is not in A1
Therefore, ISERROR returns False if "Total" is in A1 (i.e., it was found, no
Remove 'Junk' from return address.
"jerry" <firstname.lastname@example.org> wrote in message
news:E249057A-F6E4-45BF-929A-B2BB61C3A700@micro...Supress col/row increment with copy
Question with (hopefully) an easy answer....
When you copy a cell that uses a formula referring to another cell,
for simple illustration say "=C4" it will increment based on where
you paste it. So, it will increment up to "=C5" if you paste it in
the next cell, or "=D4" if you paste below.
How can I suppress that, so that when I paste the new cell receives
"=C4" as well.
(I know I can simply copy the text and paste that in, but I want to
copy a whole row of formulas to be the same. I thought
Paste>Special>Formulas would work, but it seems to ...How can I have more than 64000 rows in one sheet?
I want to import an access database in one excel sheet, it requires 200.000
rows. Any suggestions?
"blafblaf" <email@example.com> wrote in message
>I want to import an access database in one excel sheet, it requires 200.000
> rows. Any suggestions?
The current worksheet row limit of 65536 is not expected to be increased in
the immediately foreseeable future.
To import your database to Excel, it would therefore be necessary to pass
64k tranches to each of four worksheets.
This...Adding additional rows for data entry
I have a spreadsheet with five columns that I enter data to. I then
have a blank row at the bottom of these columns. Below the blank row I
have several formulas pertaining to each row. How do I add more data
to the columns and have the formulas adjust for these new rows without
highlighting rows and using the insert rows command to make room (empty
rows) where I can then add the additional data to the columns. Is
there a formula that would always leave one empty row even when new
data is entered in the columns?
Put the formulas at the top of the columns. You can even use a Freeze ...convert text in excel to uppercase
Is it possible to convert all text in a workbook or on a spreadsheet to all
In VBA Editor
Dim MySht As Worksheet, MyCell As Range
For Each MySht In ThisWorkbook.Sheets
For Each MyCell In MySht.UsedRange.Cells
MyCell = UCase(MyCell)
> Is it possible to convert all text in a workbook or on a spreadsheet to all
"elaine" <firstname.lastname@example.org> s...How do i sort rows randomly?
I want to choose 50 random rows from 10,000 lines of data and paste it into a
new sheet. The only way I know is to use a random number generator to
randomly select the records and then copy/paste the data out out, row by row,
fifty times, which is time-consuming. Is there a way to randomize my entire
data table by row so that I can take the first fifty rows all at once and
know that they've been randomly selected? Thanks. Jeremy
> I want to choose 50 random rows from 10,000 lines of data and paste it into a
> new sheet. The only way I know is to use a random numb...Work spreadsheet issue
If I have multiple rows of data on a worksheet and on another worksheet
I want various counts of rows that have certain things in common, how
would I do that? Thanks.
jenrenea's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23098
View this thread: http://www.excelforum.com/showthread.php?threadid=373900
Can you provide a sample of your data along with your expected results?
I have a total sheet that gets data from three different shift sheets (all
in the same workbook) for a monthly report. I have named ranges on each
shift sheet for each month's production data (S1M1, S1M2, S1M3, S2M1...)
where S1M1 =A2:AC147, S1M2 = A148:AC329, etc. The old formula
was:=SUMIF('SHIFT 1'!$L$1:$L$147,"BB",'SHIFT 1'!$T$1:$T$147). I'm stumped as
to what the new formula would be - how would I direct Excel to column L of
S1M1 to search for "BB", then add the contents of column T? The range
changes each month, and I tho...Restrict dialog resizing
My dialog is resizable, how can I restrict the resizing to some
minimum limit. Means you can't make it small in width and height
beyond a certain limit. Should I need to override WM_SIZE.
Thanks in advance.
"Roland" <email@example.com> wrote in message
> Hello There
> My dialog is resizable, how can I restrict the resizing to some
> minimum limit. Means you can't make it small in width and height
> beyond a certain limit. Should I need to override WM_SIZE.
> Thanks in advance.
WM_...Insert new row as cell contents change
Insert new row as cell contents change. After importing
data I have a spread sheet with a column that contains a
series of alpha numeric characters. At various random
intervals in this column the contents change. EG rows 1 to
4 could contain ABC, then rows 5 to 15 could become 222. I
am looking for a method to insert a blank row
automatically between the rows were the contents change.
If you are familiar with VBA the code below will do what you want.
Preselect the column of data first
Dim myCell As Range
Dim sCurrVal As String
...Look up column name, match rows (a/cnumber) & summing up....its confusing!
Here is what I'v been trying to do but..!
I'v 2 sets of data (data1 & data2) Column name may be sane/different in
each data set and same applies to acct_no.. I want to prepare a report
that combine product & accounts data show accumulatd result on another
Data 1 - upto Jan 2006
Acct. No Total Prod - A Prod - B Prod-C
1001 51 10 30 11
1002 47 15 20 12
1003 80 20 15 45
1004 64 25 16 23
Total 242 70 81 91
Data 2 - Feb 2006
Acct. No Total Prod - A Prod - B
1002 7 5 2
1004 16 10 6
1009 9 3 6
Total 32 18 14
Acct upto Jan'06 Prod - ...Provide space in text
Where text and numbers are at different locations in different cells what
formula could be used to suit this type of information. I want to be able to
put a space between the main body of text on the left and give a space
between the text and the start of any numbers are in the cell.
A1 = Abelia Edward Goucher2 litre
Abelia Edward Goucher 2 litre
A2 = Acer campestre Nanum180stem 6-8
Acer campestre Nanum 180stem 6-8
Thankyou if can be of help.
If you double clcik in the cell with the data then you can move th
blink line to were you wan...Halfway through my publisher document the text starts scrambling
I am in the middle of a Publisher document that I have to get out ASAP and
the words are scrmbling all of a sudden; for instance instead of the it
Might try an updated printer driver.
What version Publisher are you using? What printer? What version Windows?
Canon has issues with Publisher 98 and Windows 98
How to troubleshoot text printing (inkjet printers) in Publisher 2000
PUB2000: Troubleshooting Text Printing (Laser Printers)
http://support.microsoft.com/default.aspx?scid=kb;en-us;198...copying rows from next sheet over
I'm trying to copy a range of rows from one sheet over from the activ
sheet, and paste them onto another sheet.
This is what I tried:
However, I'm getting the error "selection method of the range clas
What am I doing wrong, and is there an alternative way to do this?
Any help would be appreciated
ayl322's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=984
View this thread: http://www.excel...Find a text
I am trying to find a text and delate a Row if the text is in the row.
But I am not sure how to do it.
Can someone help me?
Dim Cell As Range
For Each Cell In ActiveSheet.UsedRange
If Cell = "Samtals hreyfing:" Then
‚the text Samtals hreyfing sin in in the column E:E
‚If the text Samtals hreyfing: is in the row then I want to delete the Row
I think you may be looking for this...
Dim Cell As Range
For Each Cell In Intersect(ActiveSheet.UsedRange, Columns("E"))
...How do I convert spreadsheet from Canadian $ to American $?
The Euro conversion is not doing it for me. I am working with Canadian funds
and American funds. I am desperate!
Assuming the Exchange rate be .70.........type that in an unused cell, say
X1, then highlight it Right-click and do Copy, then select the cell(s) with
the Canadian funds therein (assuming no formulas) and do Right-click >
PasteSpecial > Multiply.......
Vaya con Dios,
"Samantha" <Samantha@discussions.microsoft.com> wrote in message
> The Euro conversion is not doing it for me. I am...