Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Macro To Perform Redundant Excel Tasks

13 Oct 2016   #1
rc0213

Windows 7
 
 
Macro To Perform Redundant Excel Tasks

Hi,

I am trying to extract information from one program, then import it into Excel. Well, the format it is extracted is not the format that is what I need. So, I have been manually deleting all the unneeded rows. My question is there a macro or C-Plus program that can delete these rows for me?

The rows I want to delete will not have data in the first column, where the ones I want to keep do. What is the easiest way to doing this, macro, C-Plus, etc.? And, if it is a macro, is there a macro you recommend? Or, can someone create this for me since I am not a programmer.

Thank you for all your help!


My System SpecsSystem Spec
.
14 Oct 2016   #2
ignatzatsonic

Microsoft Community Contributor Award Recipient

Windows 7 Home Premium SP1, 64-bit
 
 

I'm not a programmer and cannot write anything for you.

But......

I use an Excel macro that I did write with help from others. It contains maybe 20 lines of code. When run, it copies all data from a row to the row immediately below it.

I did the coding within Excel using the "Developer" tab. I'd guess it could be done with the C language if you insisted, but I woudn't think it's necessary.

My best advice would be to go to an Excel specialist website such as the Mr. Excel forums, which you can find with Google.
My System SpecsSystem Spec
Reply

 Macro To Perform Redundant Excel Tasks




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Excel Macro to move columns to 1 row after each other.
I was hoping someone could help me write or find a macro that would take two columns and move it to column A under the previous data and repeat for all columns. Basically user information is located in pairs of columns (typeofvalue, value). So column A and B are for user1, column C and D are...
Microsoft Office
Windows 9 redundant already??
I just found this and probably everyone else has heard already but in case not sse this Windows 10: What You Need to Know
General Discussion
Is it OK to perform other tasks during defragment?
Simple questions as in the title :) This question is asked on the assumption that other tasks should NOT be performed when burning a disc....
Performance & Maintenance
My laptop locks up when I perform certain tasks
I've been having this issue for maybe three weeks now, and I'm hoping someone can at least shed some light on what might be causing it. I've got an ASUS K50IJ notebook, and lately, when I try to Save, Save As or Browse files on my computer, it freezes. This doesn't happen all the time; it's pretty...
BSOD Help and Support
uac crashes excel macro
Hi, I am having a problem when I try to run an excel macro addin (ie vba functions) that calculates some statistics, it doesn't work. Shows permission denied. When I turn off UAC, It works. Is there any fix for this? Turn UAC on and off is too annoying...cos u need to reboot each time.
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 23:50.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App