Just Go on DATA ribbon in Xl, Then Other Sources, then Give the path
of SQL table this exercise need to done once.
after onward same u can pull from Existing Connection just need to
given Username & Password.
Regards
Vijay
--
-
Hi mahesh,
in a simple manner u have given instruction to macro to del column
which contains "na" value in any columns right but i want that instead
of specific value bifercation i want that entire column should be
their rest columns to be deleted
for eg. If if u select process 5 or emp name e i
HI Daniel,
Thanks a million. This works absolutely fine!!
Now my doubt is do i need to create a different module for all the
clients for their respective individual sheets?
Also is it possible to have the data of Company A, Company B, Company
C etc. all in one sheet named "Others"?
If at all I coul
please send sample file.
On Sun, Feb 20, 2011 at 10:05 PM, jaibeersingh panwar <
panwar.jaibeersi...@gmail.com> wrote:
> Hi Jitendra,
>
> If you have that excel sheet forward it to us.. empty one will do..
> Regards,
> Jaibeer
>
>
> On Sun, Feb 20, 2011 at 4:38 PM, Jitender kumar
> wrote:
>
>>
I am newbe to discussion group but my solution would be:
1) to click on cell that you want total or value of cell of another
workbook
2)type = sign and then select other work book, sheet, and cell that
you want.
3) the resulting formula in that cell would be something like this:
='[junk2.xls]Sheet1
*thanks Daniel Ji for the reply... here what I need and what the code
doesn't do.*
*
*
*This code runs as long as the Sheets("1").Cells(2, ColNumber) =
Sheets("Name").Cells(RowCounter, 1) but doesn't do the job. I have some data
with a lot of variables in sheet "1" of which I need few variable list
Thanks Ashish
On 20/02/2011, ashish koul wrote:
> see it it helps
>
> On Sun, Feb 20, 2011 at 3:10 AM, sudhir kumar wrote:
>
>> HI
>> All Dear Friends,
>>
>> Please help on attached file.
>>
>> thanking you
>>
>> Regards
>> Sudhir Verma
>>
>> --
Hi Jitendra,
If you have that excel sheet forward it to us.. empty one will do..
Regards,
Jaibeer
On Sun, Feb 20, 2011 at 4:38 PM, Jitender kumar wrote:
> Dear Excel Guru,
>
> 1. I have address book in Excel in following format. How to print 15
> address label in A4 paper Sticker using excel.Pl
DEAR TEAM /EXCEL EXPERTS
PLZ HELP ME
REGARDS
JITENDER
On 20 February 2011 16:38, Jitender kumar wrote:
> Dear Excel Guru,
>
> 1. I have address book in Excel in following format. How to print 15
> address label in A4 paper Sticker using excel.Pl attach a sample sheet(if
> uses VBA or else)
>
DEAR TEAM
PLZ HELP ME
THANKS
JITENDER
On 20 February 2011 16:38, Jitender kumar wrote:
> Dear Excel Guru,
>
> 1. I have address book in Excel in following format. How to print 15
> address label in A4 paper Sticker using excel.Pl attach a sample sheet(if
> uses VBA or else)
>
> S.no
Hello,
What is not working ? Do you get an error ?
What are you trying to do ?
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de rakesh kumar
Envoyé : dimanche 20 février 2011 11:16
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ CODE
Dear Excel Guru,
1. I have address book in Excel in following format. How to print 15 address
label in A4 paper Sticker using excel.Pl attach a sample sheet(if uses VBA
or else)
S.noEmpcode Name FName Address1, Address 2, City, State, PIncode,
Mobile
It should be printed like this
Na
Hello,
To create the first ABC sheet from "Main" sheet , paste the following macro
in a standard module :
Sub test()
Dim inCalculationMode As Integer
Dim rng As Range, sh As Worksheet
Dim teste As Boolean
Application.ScreenUpdating = False
inCalculationMode = Application.Calcul
see if it helps
On Sat, Feb 19, 2011 at 10:54 PM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:
>
> hi,
>
> I will be preparing the leaveplanner tracker report frequently .
>
> i will colour the specific day when i am absent on particular day.finallyon
> the end of the month
>
>
Hi Shrinivas,
In excel 2007 version and onwards, We already have functionality to save
excel in PDF format. So we do not need a VBA for Excel to PDF.
While saving excel workbook , Just select the .pdf in 'Save as Type' and
this will generate a PDF format file for you.
Let me know if you have mo
Hi Ayush,
We have any VBA coding to convert Excel to PDF.
Regards,
Shrinivas
Citi(r) Global Transaction Services - India
UB City, Canberra Block, # 24, Vittal Mallya Road,
Bangalore - 56 00 01.
Ph- +91-80-4144 6339 / 6340
Email - shrinivas.chidur...@citi.com
__
Any progress from any member awaiting
On Wed, Feb 16, 2011 at 1:52 AM, maulik desai wrote:
> Hi Group,
>
> I JUST want Macro instend of Formulas used in sheets
>
> I want a macro which can give me the output like formulas (i dont want to
> use formulas in sheets as it becomes very heavy f
Hi Venkatesh,
Install SQL DTS (Data transformation services) available in microsoft
download center for export and importing the data from SSIS.
Do revert if any clarification on the same.
On Sat, Feb 19, 2011 at 2:59 AM, Venkatesan c wrote:
> Dear All,
>
> I want to Export data to Excel 2007
Any Progress...
On Wed, Feb 16, 2011 at 1:23 AM, maulik desai wrote:
> Hi Group,
>
> I am having database with many columns outof that in one column name is
> current status in that column there are 37 unique attrition codes are
> available ,each code has its logic behind that
> i want a macr
One more thing i have noticed that macro delete the complete Column contains
"NA" value from the sheet but as i have mentioned on my prev mail that i
want the specific cloumns based on Process name becasue sometime it happens
that in required columns we have to enter "NA" so in that case macro will
Hi Mahesh,
Thanks for the lovely Solution but 2 minor modification i wanted from you
1. File should be saved in Excel 2003 format (.xls) ,Currently it is saved
in .xlsx format
2. i dont want " sheet Name should Be" Column should be saved on output
sheets because it is just for your information,ki
hi Daniel..
I am not able to attach any file with the post, i mean i am not having
any option to attach file; if there's any way please let me know, this
is the first time I am posting.
Below is the sample data just pasted from excel.
now this is the main sheet where in I will be entering the data
Dear Ayush,
Can you please how to run the macro? I am new to macro & I need this
application.
Regards,
Darshil.
On Sat, Feb 19, 2011 at 1:04 PM, Ayush wrote:
> Hi Rashid,
>
> You can find the macro at the link below :
> http://quickvba.blogspot.com/2010/12/import-pdf-in-excel.html
>
> Let us k
23 matches
Mail list logo
