Search
Excel Help Forum - Excel Formulas & Functions: What formula to use for matches in column and return the sum of all match val...
Excel Help Forum - Excel Programming / VBA / Macros: It's possible to create an "autorization" or reject button with vba excel?
Excel Help Forum - Excel General: [SOLVED] help with formula. It works but empty cells show#VALUE
Excel Help Forum - Excel Formulas & Functions: Value return from two column comparison
Excel Help Forum - Excel Programming / VBA / Macros: have a drop down list with associated values difference to be calculated
Excel Help Forum - Excel General: R1C1 reference style default checked - driving me crazy
Excel IT Pro Discussions Forum: Combine multiple Excel workbooks and export to a single html page
I'm trying to find a new solution in Excel 2010 from 2003 that allows the ability to take multiple Excel documents with only one page each, auto select the data for the print area, and publish to a single HTML file. This needs to be done in a chronological order by the date of the file. I'm not sure if this can be done as a script within Excel or if there's a third party program which can help with this capability.
I'm not an Excel guru and could use your help.
Thanks!
Excel IT Pro Discussions Forum: I need a macro that does this (Two excel sheets shown)
My macro worked before to do what I needed to do but for some reason it either was wrong before or I just thought it was working. Anyway here is an example of two spreadsheets, the one on the left is prior to the macro and the one on the right is after the macro. The idea is simple and below the examples I will explain my logic and show my code. Please let me know if anyone can help asap I am getting confused.
As you should be able to see from my example my macro reads out the value in Column C "WP". It then compares it to the value above in Column C and when that value changes the value in column F "Name" will copy the name of the task that started the change. So MGMT overwrote Task3 and Task because the WP value changed. It also should read the offset value and keep copying down the task name until the "WP" changes again.
Here is my code I have been trying to use. (It runs from a project user-form but it is excel mostly)
Private Sub Test() Dim xlapp As Excel.Application Dim NC As String, tn As String Dim xlSheet As Worksheet Dim c As Range Set xlapp = GetObject(, "Excel.Application") Set xlSheet = xlapp.ActiveWorkbook.Worksheets(1) NC = xlSheet.UsedRange.Rows.Count For Each c In xlSheet.Range("A2:A" & NC).Cells Debug.Print c.Value If c.Offset(-1, 2).Value <> "" Then tn = c.Offset(0, 5).Value Else c.Offset(0, 5) = tn End If Next c End Sub
Excel Help Forum - Excel Formulas & Functions: If worksheet 1 cell A1 contains one the following N/S, OP, AFT 1 display a value
Excel Help Forum - Excel Programming / VBA / Macros: Macro to separate out raw data
Excel Help Forum - Excel General: Replace missing values
rpm problems.. - Forums Linux
rpm problems.. - Forums Linux |
- rpm problems..
- How can I auto mount usb key when I plug it ?
- where do I install openoffice 1.1 on knoppix 3.3?
- How to move personal config/home dir to another computer?
- Suggestions wanted for simple File Server linux variant..
- Display Corrpution/SaX2 configuration
- AMD 64 bit processing and SUSE 9.0 (Kernel 2.4.21) - compatibility query
- Linux Triple Boot
- 2G memory not recognized
- How to remove Red Hat Network Alert Icon permanently from the panel?
- xmms-infopipe problem
- PCMCIA.IMG for LiveCDs?
- Problem with ext3 filesystem on Redhat 7.3
Posted: 08 Feb 2004 01:23 AM PST >> hi all I expected to find it somewhere under the /usr/src so I did a find /usr/src -name version.h to try to locate it. from what I understand version.h is one of the files the driver-source needs. nothing. I also looked in /usr/src/redhat/SOURCES and found nothing that seemed to be kernel-sources. As I said I found it strange that GnoRPM think it's not installed (I checked on my laptop on which I know I have that package to see where it was located) I did a lspci and it said "network-card unkown interface" or similar regards Daniel |
How can I auto mount usb key when I plug it ? Posted: 07 Feb 2004 01:36 PM PST Yes I found /etc/hotplug/hotplug.agent. But how am I supposed to modify the script ? Must I find out where the action for an usb key is made and call my own script on plug and unplug ? I mean, I don't want to break the whole thing :) thx for you input though |
where do I install openoffice 1.1 on knoppix 3.3? Posted: 06 Feb 2004 09:01 PM PST walterbyrd a écrit: I do not know any specific about knoppix but: 1) The setup of OOO asks you where *you* want it to install. I suggest /usr/local/some-sub-dir/ or /opt/some-sub-dir/ ; depending on your partition scheme. 2) It is better to use ./setup -net if you want OOO to be readily available for everybody in a multi-user environment. 3) The doc that comes with the package(?) is well written and explains the install process. Bonne chance! -- On ne peut pas transporter partout avec soi le cadavre de son père. Guillaume Apollinaris de Kostrowitzky |
How to move personal config/home dir to another computer? Posted: 06 Feb 2004 08:51 AM PST Horus Alkebulan wrote: sure you can do that. Login as root, create a user for yourself, get those config files here. But make sure you chage the owner and group of the newly transfered config files. That what I do all the time I install GNU/Linux afresh. GVK -- Happy Hacking!!! |
Suggestions wanted for simple File Server linux variant.. Posted: 06 Feb 2004 05:57 AM PST "Frank Perdue" <com> wrote in message news:<c006gk$8ou$panix.com>... I'm assuming you're pretty new to Linux, so I would suggest you go with Redhat or SuSE or Debian simply because of their availability and wide use. These also may be easier to "sell" to others if you have to get other(s) to OK the distro. Other distros fine too. I wouldn't purchase any Linux distro till I was familiar with it and understood just what I was purchasing. To get started go with a downloadable version or buy a Cheapbytes cd: http://www.cheapbytes.com/ Code/configuration wise you won't notice a difference with the pricier fair. I would not recommend a "headless" server till you are comfortable with Linux and your distro in _your_ network environment. Trying to do all your setup (OS and users) -- not to mention installation -- remotely with an OS you're not familiar with will add more confusion than it's worth. All you need is a cheap (used/spare) video setup and a keyboard. What will you do if the file server goes down? If the network goes down? If your laptop goes bonkers? It's just not worth it and may be necessary anyway after a power outage crash. Considered an UPS? Later, after you're comfortable with your basic setup, you might want to try something like Webmin to do remote administration: http://www.webmin.com/ Ultimately, you'll want to learn to telnet (or SSH) into the server just in case. You'll also need to decide just how you want to provide remote file access to users. You'll need something that both the Win and Mac clients can easily reach and that Linux supports (and that you can administer without too many headaches). Looking at some distro manuals and Linux howtos should help out before you dive in with sleeves rolled up. Check these links (which I had handy): https://www.redhat.com/docs/manuals/linux/ http://www.tldp.org/docs.html Google for other distros also to get some basic sense of what's available. Also consider that whatever you go with has a way of growing into adding a web server, a mail server, a print server, etc., as Linux makes a fine platform for all these (and many more) services that will run nicely on older, cheap hardware. Pick a distro with an eye to the future. As a last check you might want to Google your hardware together with specific distros or just Linux. Eg., you might search with: LSI SATA raid Linux or LSI SATA raid Redhat or LSI SATA raid SuSE sendmail <- up to 10 words You get the picture. Use Google to search NGs the same way. You can learn quite a lot this way and get practice providing your "own" support rather than paying. It may be all you need. hth, prg email above disabled |
Display Corrpution/SaX2 configuration Posted: 06 Feb 2004 04:20 AM PST Ruari Callow wrote: IMHO, this was worth hashing out in front of the wider audience. Laptops are ever more popular, and there's precious few sites specializing in their unique issues. That is, precious few sites easy to find. Your question strikes me as proper use of the NG, so I'll defend it. About the only way it could be more useful is if you had done all the work, wrote it up in summary and then posted that. Tall order, if you ask me, and I happen to be a writer of just such articles (see ofb =dot= biz). -- Ed Hurst -------- Return address is a spam trap; try softedges =at= gmx =dot= net. |
AMD 64 bit processing and SUSE 9.0 (Kernel 2.4.21) - compatibility query Posted: 06 Feb 2004 01:45 AM PST David Brook wrote: Take a look at this url: http://www.mushkin.com/epages/Mushkin.storefront/4023799d00d11858273fc0a801020617/UserTemplate/27 It might give you some useful information -- |
Posted: 05 Feb 2004 02:58 PM PST Mitesh wrote: For hardware, if your computer is standard: put both drive pins to "Cable Select". Then plug the 120GB to the far end on the cable (i think it might be blue???). Then plug the 20GB drive in the 2nd position (between the 120GB and the motherboard). Set boot order in the bios to the 120GB drive. This is my _opinion_, and I _personally_ recommend installing the following way. 1. Create 80GB with XP Installer, install XP. 2. Install RH9. This requires MINIMUM 2 partitions, a root "/" partition and a swap partition. Create both, do the recommended swap size (depending on your RAM). *** Its good to have a separate partition to store data. Create a 3rd /home partition if you want. Make it big >20GB. You won't need more than 10-15GB for a full install of RH9 with enough room for just about everything conceivable. *** Install GRUB boot loader to the 1rst sector of the Redhat boot partition. NOT on the MBR. Use bootpart to create an entry in the XP boot loader (already in windows) to boot redhat: http://www.winimage.com/bootpart.htm 3. Install Suse on the second drive. Use its recommended partition scheme. Even though suse can use the swap partition on the first disk, it may want a separate swap on the 2nd disk. Also install grub to the first sector of the (suse) boot partition. You will need a 2nd entry in the XP boot loader to boot suse. Use bootpart again. ------ However, if you dont want to use the xp boot loader, you must install grub to the MBR for RH9. Then, for Suse you will need a separate entry in grub to point to the second disk. The good thing about using the xp boot loader is it doesnt affect xp booting in any way. From experience locking yourself out of booting XP is much more frustrating than locking yourself out of linux (since its easily fixable). Whatever you do, always install windows first! Also try to keep all windows partitions (ntfs, fat, etc) before linux partitions (ext, reiser, etc) when installing on the *same* drive. This has caused me some pain in the past. Hope this helps, good luck. -- Mauriat (www.mjmwired.net) ---------------------------- Remove 'NOSPAM' to email me. |
Posted: 05 Feb 2004 09:19 AM PST Davide Bianchi <net> wrote in message news:<bvu1du$10u0l7$news.uni-berlin.de>... I was under the immpresion that redhat kernels support mem >= 2G, and on a different server which is i686 that is fine. Is high mem configure only in the i586 kernels? [sorry, that should have gone to a redhat list] Thanks |
How to remove Red Hat Network Alert Icon permanently from the panel? Posted: 05 Feb 2004 05:53 AM PST joensuu.fi wrote: Well, the obvious question is: Did you save the settings? -- Fedora Core 1, Kernel 2.4.22-1.2135.nptl, KDE 3.1.4, Xfree86 4.3.0 23:35:00 up 34 days, 5:15, 4 users, load average: 0.09, 0.13, 0.09 It's what you learn after you know it all that counts |
Posted: 04 Feb 2004 09:55 PM PST Dave Abbott wrote: I got xmms 1.2.9 and xmms-devel-1.2.9 Things run smoothly now. Thanks for your time. GVK -- Happy Hacking!!! |
Posted: 04 Feb 2004 08:23 PM PST On Thu, 05 Feb 2004 22:16:55 GMT, Les Denham <com> wrote: Thanks, Have already tried that with PCLinuxOS LiveCD and Mandrake 9.1 pcmcia.img. It doesn't work. I guess the image file has to be matched to the distribution exactly, or the install is aborted with a "wrong version" error. Achim axethetax |
Problem with ext3 filesystem on Redhat 7.3 Posted: 04 Feb 2004 01:45 AM PST com (P Gentry) writes: Note that the size you see with 'ls -l' shows only the end-of-file pointer. ls -ls will show the number of blocks actually allocated to the file. It is perfectly legal albeit unusual to have a file which shows an EOF of 282GB on a 9GB drive, if most of the file is empty. scott |
You are subscribed to email updates from TextNData Forums - Linux To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
Google Inc., 20 West Kinzie, Chicago IL USA 60610 |
Excel Help Forum - Excel Charting & Pivots: Dynamic Multiple Charts - One Data Set
Excel Help Forum - Excel Formulas & Functions: Formula with Different Percentages
Excel Help Forum - Excel Programming / VBA / Macros: recursive correlation
Excel Help Forum - Excel General: Word slowing down using >paste special< with no links
Excel Help Forum - Excel Formulas & Functions: Converting a date serial number back to a date within a string
Excel Help Forum - Excel Programming / VBA / Macros: Copy values from one CSV to an excel worksheet?
Excel Help Forum - Excel General: Running clock in excel 2010
Excel Help Forum - Excel Formulas & Functions: Frustrations with Pivot Tabels
Excel Help Forum - Excel Programming / VBA / Macros: Only one computer adding leading apostrophes to drop downs
Excel Help Forum - Excel General: Mail Merge: The merge provides data from the previous record
Excel IT Pro Discussions Forum: Excel/Sharepoint
I have a very an App with, multiple SSs and charts. I would like to make the App available to many clients via the web instead of downloading the app to their computer. I understand, however, that when attempting this porting (HTML Conversion) many features that I am using will be lost.
Can Sharepoint be a solution, i,e., web access to Excel with no loss of local Excel features???
Excel Help Forum - Excel Formulas & Functions: advanced excel counting with running totals
Excel Help Forum - Excel Programming / VBA / Macros: Need help in Search database
Danh sách blog
1. Thông Tin Địa Điểm Trường Học Thuộc TpHCM
2. Tìm địa điểm ** Chính xác** Bản đồ,số ĐT,website
3. ATM Agribank, bản đồ, địa chỉ, đường đi
4. ATM Vietcombank, bản đồ, hướng dẫn đường đi đến Địa điểm
5. ATM Sacombank, bản đồ, hướng dẫn đường đi đến Địa điểm
6. ❤ ❤ Dịch vụ chọn lọc cho bạn ❤ ❤
7. Sửa lỗi
8. Đầm bầu
9. Top nice templates for you
10. Top answers for your issues - collect information from Google Search
11. Top Clips Vui Nhộn
12. AngularJS Tutorials
13. Lời bài hát