Limiting number of columns/rows on a sheet
How to limit the number of columns on a sheet? I'd like to have a
columns on a sheet and afterwards coming the "gray area" (Like it i
coming after 256 columns or 65536 rows)
Thanks in advance
tarvi's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3610
View this thread: http://www.excelforum.com/showthread.php?threadid=55883
hide unwanted rows and columns
"tarvi" <email@example.com> wrote in
message news:tarvi...Include credit memos on checks without applying to an invoice
Currently, you cannot include a credit memo on a check without applying it to
an invoice. If that invoice is already paid, you have to apply it to a
different invoice -- one that has nothing to do with it! You lose accurate
transaction history for both invoices -- the one already paid and the one
being applied against.
We are in the retail industry and receive tons of credit memos that adjust
costs on previously entered invoices at each month-end because we met
quantity orders. It is impossible to apply them to original invoices and,
therefore, have to apply them to invoices that th...vb code to copy and list selected row to diff sheets
I am working with workbook with 30sheets for each day x each worksheet having
same headers and colmuns x I want to copy selected rows to corresponding
sheets with different name . eg.
date name details amount type
13feb kk ccj/dxb 1300 inv
14feb pv ccj/auh 1200 alh
I would like to copy first row to a sheet named inv and second row to sheet
names alh. can u adv me the code to be used
pvkkutty new to discussion group however a freequent reader of discussion
Try the below code with all the sheets...
Dim wb As Workbook...Insert a blank row
I need some help to insert a blank row in a range where column A has a
series of dates. There will be several of the same dates and I need to both
sort the dates and then insert the blank row at the end of each sequence. In
the blank row I need to total figures that will be in columns B through to
maybe an easier solution
1. Sort your data (use 'Data - Sort', e.g., column A ascending)
2. Use 'Data - Subtotals' This will insert a row after each date and
calculate subtotals automatically for you
> I need some...Seperating cells and columns
Is there a way to seperate some cells and/or columns so you could have
different height cells/columns that are in the same row?
DRLski's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26892
View this thread: http://www.excelforum.com/showthread.php?threadid=401166
inserts some rows above and below your initial row and merge the ones
that need to be higher with cells above and/or below
-------------------------------------------------------------------...when certain rows are hidden, can I also hide a combobox?
I have a code that hides certain rows in sheets 3 and 4. Is there a way to
make 'Drop Down 3' and 'Drop Down 4' hidden when rows as per Case 2 are
hidden? The code I have so far is below:
' Combobox Value Is changed
varData = Range("B27").Value2
' unhide ranges
On Error GoTo 100
Application.ScreenUpdating = False
Sheet3.Range("A58:A68").EntireRow.Hidden = False
Sheet4.Range("A150:A185").EntireRow.Hidden = False
Sheet3.Range("A35:A57, A26").EntireRow.Hidd...How do I sort a column of formulas in Excel? #2
I have a column of dates that I produced by putting in the first date. Then
the next and following were simply a formula =SUM(A4+7) and so on for five
years of Sundays. I wanted to have two for each sunday I could have them
sorted by AM or PM so I duplicated the list and put AM in the next column
beside the first 5 years of Sundays and PM beside the next five years.
I then sorted with column A (dates) descending and column B (AM/PM)
I expected to get 01/01/2000 AM and then 01/01/2000 PM under each other and
so on but the formulated column would not sort. I tried a sample of ...SQL Error Message- Row Cannot Be Located...
Hi, we're getting the following error message on a customers machine when
she tries to open up Store POS for the first time- "Row cannot be located for
updating- some values may have changed since last read". This is a new RMS
Store Operations 2.0 installation and it's connecting to HQ. After this
particular store was first created, there was an error synchronizing the
databases, a collation problem which was immediately fixed and everything
synched up fine. Disconnected and reconnected the database, Store Manager
opens fine, deleted and recreated the register and ...Duplicate entries between two columns
Need some help with an excel formula.
I have column A with 962 entries. I have column B with 898 entries. I
want to find out the matched entries of the two columns in Column C.
mazalam's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26768
View this thread: http://www.excelforum.com/showthread.php?threadid=400897
Put this in C1:
and drag down.
True's will mean that B has a match somewhere in column A.
mazalam wrot...stacked column with series in variable locations
I don't think this can be done within Excel, but then again, some of you have
some very creative ways of getting things done!
I have a client who would like to create a stacked column chart. Here is
some sample data.
Day 1 Day 2 Day 3
ab 6:00:00 AM 6:00:00 AM
cd 6:30:00 AM 2:50:00 PM
ef 9:15:00 AM 6:00:00 AM
gh 1:30:00 PM
hi 4:00:00 PM 6:45:00 AM 1:00:00 PM
The chart would have the Days along the X axis and the times along the Y.
Each day goes from 6:00 am - 6:00 pm.
On Day 1, Product ab is run from 6:00-6:30, Then cd from 6:30-9...VBA/Row number/column numer
If I want to specify a cell in VBA but only know it's row
NUMBer and not column number, how would I describe this
cell in vba? i.e. instead of AA5, i want to be able to
talkb about it as being column 27 and row 5...
Cells(2, 3) would give you cell C2
mvpearl omitthisword at verizon period net
"mika." <firstname.lastname@example.org> wrote in message
> If I want to specify a cell in VBA but only know it's row
> NUMBer a...Reversed column labels
For some reason, when I open any new spreadsheets, the column labels are
reversed, with column A on the right side of the screen. This is making
working with excel difficult. Is there some option I enabled that can be
disabled so that Excel gets back to normal?
tools / options / international - check the settings under default direction
note, you won't see the affect of this until you close & reopen your
"Drew Remsen" <email@example.com> wrote in message
news:MeSpd.73932$8G4.firstname.lastname@example.org....How to apply an over-credit to a sale?
Ok, we had an online customer overpay his order using a money order. So,
when I tendered the money order, he had about $45 coming back to him. Well,
he just wanted that applied to his account. So, I selected (Payment) and
applied the $45 to his account. It warned me that it was an overpayment and
I clicked OK.
Now, on his next sale, how do I apply that $45 credit?
Just apply 45 to his house account. When you tender the sale it will deduct
45 form his account and then it will be zero
"nutribodies" <email@example.com> wrote in message
news:FD033E...Radom hidden rows
Excell seems to be hiding rows on it's own. When I try to Unhide the rows or
set the row height, nothing happens. I have about 1200 rows in the sheet but
it's hiding about 600 rows. I can manually mouse click on the row to unhide
the data but once I save the file it hides other (seemingly random) rows. All
the users are experiencing the same problem with this workbook.
The workbook is shared (I am the author), and not protected.
...For all rows, if cell has "X", get number from range?
I'm hoping this can be done with a formula - I'd like to stay away
from macros unless I have to.
This is a job order tracker. Each job order entry takes four rows.
The first few columns are job info; the next 31 columns are the dates
of the month. The first row of each job order is for days worked - if
that job was worked on that day, an "X" goes in the row under that
I'd like to put a formula at the end of each job order that captures
all the dates the job was worked, as indicated by the "X" in that
column in that job order.
Something like this:
1...Possible to show clustered and stacked columns on one chart?
I have 2 categories of sales for two companies. one is projected sales the
other is actual sales for a series of years. I want to show for each year
stacked company one and company two projected sales. Then next to it
(clustered) I want to show the same two company actual sales stacked. thanks
Jon Peltier has an example of that here:
> I have 2 categories of sales for two companies. one is projected sales the
> other is actual sales for a series of years. I want to show for each year
> ...Paste to next row if cells are not empty
I have a workbook that contains calls details of clients. Those details are
be pasted to individual client workbooks.
I have this macro that pastes call details to workbooks in a folder.
Dim ClientFile As String 'Holds client's file name
Dim CurRange As Range 'Holds current range selected
'In case of an error this will handle it gracefully and give me
On Error GoTo ErrorHandler
'Turn screen updating off. I won't see the client file being updated.
Application.ScreenUpdating = False
' I Make sure ...How to apply Macro on a same type of format but in excess content?
First of all i 'd like to explain what problem i'm facing.
See i've data in three Rows and three Columns.
I've recorded macro & i applied the same macro in same formation.
like three Rows & Three coloumns.
But the question here is now i've Five Rows & Five coloums. Now if i apply
the same macro here then it overrides the data over three rows and coloumns.
Please let me know can i do apply the same macro because the formation is
same only data is in more no.
Looking forward to hearing form you.
Wi...how can I stop sub total rows appearing in pivot tables in excel
I am working in excel and I need to prevent sub total rows appearing in my
pivot tables. Does any know if this is possible and if so how?
Also, I am working in Access and I need to be able to have multiple columns
headers (grouped) similar to what you can do in Excel, any ideas?
Thanks for your help.
If you rightclick on the button like header in your pivottable, you can select
there's a "none" option for subtotals.
If you don't get an answer for your access question, you may want to try an
> I am wor...select columns by column index
Hi to all.
I am having a small problem. I would like to select columns by their
indexes. psedou script is as follows.
select column(1), column(2) from table
Is it possible to do ?
and (Number) is going to be dynamic.
Thanks in advance
__________ Information from ESET NOD32 Antivirus, version of virus signature database 4611 (20091116) __________
The message was checked by ESET NOD32 Antivirus.
It's usually considered good practice to avoid depending on the order of
columns in a table. So I would reco...Conditional Formating on Row
Can you apply conditional formating to a number of colums in a ro
dependant on what information is enterd in a particular cell in tha
IF Cell H2 = "New" then Format text in cells A2:H2 as 'Red' 'Bold
Message posted from http://www.ExcelForum.com
try the following:
- select the cells A2:H2
- goto the conditional format dialog and enter the formula
- choose your format
"loscherland >" <<firstname.lastname@example.org> schrieb im
Newsbeitrag news:loscherland.1...Automating a Chart w/ a row of criteria as Y axis
Hi, I hope someone can help. I can automate a chart given 1 x- and y-
axis. However when I try to apply the same offset principle to a
chart w/ an x-axis consisting of more than 1 criteria, it won't work.
For example, my table looks like the following:
Week # January FebruaryMarch April
week 48 10000 20000 30000 40000
week 49 10000 20000 30000 40000
week 50 10000 20000 30000 40000
week 51 10000 20000 30000 40000
week 52 10000 20000 30000 40000
week 53 10000 20000 30000 40000
week 54 10000 20000 30000 40000
My chart is 3-dimensional, week # is the z axis, months the x axis,
and the sal...Detect Data Changed State in Row with Focus
On a continuous form, how do I detect that the row having focus has had one
or more controls' data changed? A procedure started by a command button
needs to know whether the row with focus has been changed by the user. This
is before the focus leaves the row so the before update event for the row has
not fired. It is after the before update events for a control would fire if
present. Is there a simple way to test the form for the update state of the
row with focus? I want to avoid a lot of VBA to collect the state change for
each control in before update events. I just want to...Use Query for Row Source
Re-Post question not resolved/provided attention to from 26 Oct 07
Steve, here is the info you requested:
Row Source = SELECT [EPR/TR/OPR].[FullName] FROM [EPR/TR/OPR];
Column Count = 1
Column Widths = 1.7605"
List Width = 1.7604"
Bound Column = 1
"Steve Schapel" wrote:
> In design view of the form, can you select the combobox, and look at the
> Properties. Can you post back with what is entered in there for these
> Row S...Unwanted change in width of columns when showing formula.
When selecting to show formulas in cells, a lot of my columns change their
I have confirmed that I am viewing the worksheet at the same zoom-level
before and after switching to showing formulas.
When reverting back to show the actual results of the formulas in the cells,
the width also goes back to what I had initially decided on.
Why is this (width gets bigger)?
I want to have the freedom to maintain _my_ chosen column-width,
stupid-looking as it might be. Is there a solution to not have the
column-width changing like this?
Thank you in advance.
The column widths change because E...