Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / May 2008

Tip: Looking for answers? Try searching our database.

Importing the format (Excel 2003)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jaco - 29 May 2008 05:27 GMT
I'm using a vlookup function to import data from a pivot table but I'd like
to import the format as well. From previous posts this is apparently not
possible unless you use codes. I'm unfortunately not familiar with coding. Is
there maybe a site you could direct me to where I would be able to figure out
what I need to do?

Any links to sites where one could learn a bit more about macros and coding
would be helpful as well.
DILipandey - 29 May 2008 07:52 GMT
Hi Jaco,
After entering the v-lookup formulae in the required cell, you can use paset
- special format from the respective pivot field.
Signature

Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
dilipandey@yahoo.com
dilipandey@gmail.com
New Delhi, India

> I'm using a vlookup function to import data from a pivot table but I'd like
> to import the format as well. From previous posts this is apparently not
[quoted text clipped - 4 lines]
> Any links to sites where one could learn a bit more about macros and coding
> would be helpful as well.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.