$$Excel-Macros$$ Re: HELP urgent

[Brian Henard]

If you are using Excel 2007, then you can do part of this without VBA.  If 
you want to change color of cell, for example, when the cell value is 
negative, you can accomplish this by going to Home > Conditional Formatting 
and then creating a rule by which the cell changes.  This is probably easier 
than fiddling with VBA to accomplish the same thing.

To tackle your year question, I would probably figure out how to write a 
subroutine that would be activated upon a change in the worksheet.  Whenever 
you make a change, this subrouting would be triggered to run.  I would then 
run a loop using the range.offset property such that the loop counter is 
used to run down the rows and perform an algorithm on each row to check the 
value and copy your year.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Re: Help Urgent i want to convert pdf file to Excel (column will remain same)

[JsinSk]

Simply searching the group for pdf to excel would've given you several
potential answers. I did not check this URL but here is one possible
software answer.

Link to answer:
http://groups.google.com/group/excel-macros/browse_thread/thread/b6fae3eee31606ec/d32d131c316fa8d4?lnk=gst&q=pdf+to+excel#d32d131c316fa8d4

Able2ExtractProPortable
http://w15.easy-share.com/1700287853.html


There are also apparently several online solutions, I would use these
with caution depending on the sensitivity of your data.

www.zamzar.com
www.youconvertit.com
www.pdftoexcelonline.com/

I cannot verify any of these as I'm at work, and I won't load unknown
websites from here.


On Feb 24, 1:54 am, rashid memon  wrote:
> -- Forwarded message --
> From: rashid memon 
> Date: Wed, Feb 23, 2011 at 2:57 PM
> Subject: help! i want to convert pdf file to Excel (column will remain same)
> To: excel-macros@googlegroups.com
>
> Dear Sir,
>
> i have PDF file which i have to convert to EXCEL i have Adobe Acrobat 7.0
> Professional
> please provide me VB Code
>
> Excel file for sample is also attached...
>
> Looking forward to receive your kind attention.
>
> Thanks & Best Regards
>
> M.Rashid
>
> Email:- *mr.rashidme...@gmail.com*
>
> --
> Looking forward to receive your kind attention.
>
> Thanks & Best Regards
>
> Muhammad Rashid Hussaini
>
> Email:- *mr.rashidme...@gmail.com*
> Cell: 0323-3289198
>
>
>
>  querry.xlsx
> 25KViewDownload
>
>  Querry.pdf
> 26KViewDownload

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel