I am facing a problem which has taken much of my time. I have to set of data
parallel to each other, related, but not in sync I have inserted divider
whenever the data changes, horizontally. But I can see that there are empty
cells in between the divider even if one particular ...

Pitanje
     itanje
I have some blank cells which have to be complete once. Example, same
people

We have an Excel page in html on the Intranet.
Some want to print the page. And some of them get in trouble:
frames, from where you enter the page, what's selected etc.
For example, if the tabs are selected at the bottom you only get that frame.

Sir,
i am using excel 2003. we sale 10  types of limestone.we have different
customers.we make daily sales comprehensive report .all the data we collect
from our weigh Bridge. but it take time to make report.data contains summary

I have 10 input cells in one column (say A1:A10). To ensure the user enters
input in a subseqent order (i.e. start from A1 and continues down), my
current "Private Sub Worksheet_Change" procedure unlocks the next cell only
when the previous cell has been populated. But this does ...

I need to extract data (the first three letters after the 2nd comma, and the
first 35 characters after the 7th comma) from a csv file (over 100,000 rows),
only after the 8th column matches a values in column A of my spreadsheet. The
two extracted data elements need to be stored ...

I am exporting records from an existing dbase in CSV format into a Excel
File.  There will be 2 completely different exports from this dbase into
excel and I need each export to come into 2 different workbooks within the
Excel file.

Is there a faster way to pick a window than to go to the Menu bar.  It would
be nice if there was a fast way to make a popup come up in the middle of the
screen with the names of the open windows on it to select.  Going to the Menu
bar is a bit cumbersome.

Hi Sir,
Excel can export to webpage (html)..
If we have so many pages (item) in one Main Page
then how to be able to let people see that page in LAN?

Does anyone know the maximun number of objects a collection variable can
hold (in Excel 2003 and 2007)? I tested it in Excel 2003 and it seems to me
that there is an upper limit of 256 objects per collection variable but I
still want to confirm.

I have a worksheet with over 500 names in a column. I wrote a macro that will
create each name as it's own worksheet(tab). I'm wanting in also put in the
macro the ability to hyperlink each on of the names on the first(master)
spreadsheet to it's own worksheet within the workbook ...

I have 5 cells [range is I13:I17] each with a hyperlink to a wav file and I
would like to have a macro that randomly selects these cells to enable the
hyperlink.
Is this possible?

I have a job costing spreadsheet that includes 7 worksheets from my different
vendors and a labor worksheet which includes hourly rates, overhead, etc.  
This spreadsheet accurately tells me the cost for a job and currently i have
a "totals" worksheet which simply sums any data ...

I've modified an existing macro that copies one range to another by pasting
values.  The source range has formulas that use CONCATENATE to build a
formula by looking up values in several cells.  That part works ok, but when
I paste it as values, I need to edit each cell and ...

I have a worksheet with some column in blue color background & when i enter
the data in this worksheet (direction Right when I press the ENTER key) I
would like if the next column is in blue the cursor automaticly jump to the
next column until the cell have no background color.