I am working on a project with several co workers who are located in different places - we all need to collect information and up date it to an Excel spread sheet - is there a way we can put i...
I have a text data file that contains HEX data, and I would like to read it into EXCEL. But EXCEL treats the columns with HEX data as if they were numeric (when they don't contain the charact...
Hello,
I'm trying to filter a pivot table (and ultimately about 20 pivot tables in my workbook) based on items selected in a multi-select Excel 2003 listbox.
So far, I've written the selec...
I have two workbooks with different information in each that I need to reference the two together. I have already referenced, one workbook with all the information that I need from it, but no...
Excel Spreadsheet.
Column F and G.
Column F lists names of objects. A, B, C, D, etc.
Column G is a counter column for objects that begin with "A".
F1 = A
F2 = A
F3 = A
F4 = A
F...
Can someone please direct me to some on-line,printable examples of working Excel financial analyses spreadsheets/tools? I would like something I can download, enter data into a "model" and se...
With the help from experts@EE(jeveist,rorya,byundt) i was able to combine all excelfiles in adirectory into a single excel sheet and extract data from them.
i need help in improvising the cod...
A remote users swears that he no longer has the editing field in his Excel spreadsheets. I am not sure what to call the little bar or field next to the red X, green check mark, and the fx but...
Hi,
How do i add filter on the top row so I can filter according to what type of data there is there.
Thanks.
I have a couple of shapes I created in my spreadsheet that I use like buttons to start a simple macro. Is there a way to give the button a tool tip or something that behaves like one? This i...
I am trying to sum up some values across multiple tabs in excel. Is there any way to do it without using sum(Sheet1!B2,Sheet2!B2,Sheet3!B2....)?
Hello,
When I open a document in Excel 2007 on network drive and edit the document, save then close the document, it is read only after that and cannot be changed. Also, the document cannot...
hi
is it possible to create an excel and write data from pl/sql? currently my pl/sql has this code. but it writes from the database. i want to write few lines on my own
e.g
NAME: SEWWEW
S...
Hi,
we've got a large .xl spreadsheet with alot of VBA behind it that is delivered to clients in a variety of locations running various concoctions of XP/2000/NT and office 2000,2002/2003, a...
i am trying to Open different excel files in a directory and access different sheets in each files based on sheet name. (ex sheet names: open, closed etc..) i was successful doing it when the...
Hi Folks,
I am trying to retrieve data from a column in a listbox on a form.
The list box has several rows and columns of data, and all i want to do is to cycle through each row of data ...
I have two instances of excel running on my desktop. When I paste special into the same opened excel application that I copied from, I get all th options such as past only formulas, text, etc...
I am trying to group data by 15 and 30 minute intervals in EXCEL. Pivot tables lets only 1 hour or 1 min. Please tell me if there is an alternative to do this. VBA code or macros etc...
Hi Everyone,
I should have known that my boss was going to through yet one more requirement at me regarding this task. Below is how the spreadsheet will look like, and Chris did a GREAT jo...
I just installed an MPLS network at a remote office that is only 30 miles away from where the main File Servers are located.
All the connections are fine, but when the remote office attempts ...
I need a macro for excel that takes stock information about open, close, day high, day low and draws a candlestick graph. The candlesticks need to be added each day across from the date and th...
Have MS Access 2000 DB where I created queries that produce data for Pivot Tables. I'm trying to link the existing queries to an Excel Spreadsheet that I can then create Pivot Tables from. Als...
Hi,
I've got some excel worksheets with VBA code inside them. These run fine under excel 2003.
When I try to run the same sheets under Excel 2007 I get a VBA error "Object doesn't suppor...
Currently, when the file is already opened and another user on the network open it, it says it is already open by User1 would you like to open in read-only?
What we want with this particular ...
I have a workbook with multiple worksheets. Each sheet is a detailed page with dates and times. Sheet 1 has been added as a quick view of each page. The rows of Sheet 1, column A has the name ...
