Hi, I have two files: FileOrigin and FileDest. I execute a Macro in
FileDest, and select the FileOrign with
Application.Dialogs(xlDialogOpen).Show.
1) FileDest as a unique ID in sheet “Track”, cell AQ7. This is text
and numeric (example IFS-gs21e3). Also has a list of Providers in
range C84:C133.
One way you can do is select and copy A1:A4 for exemple and click and
A1 paste special -> Transpose, its in the left corner down, of copy special
box.
Try there.
Lately you can create a macro that do this for you
Best Regards
André Luiz D´Avila
2010/4/28 balbirkumar .
> Dear Friends,
>
>
> I wa
Hi ,
You just copy on range a1:a4 and click on other blank cell then right click
and select paste special ,
select value and transpose it can arrange series as you want.
pls note that it can not paste on cell a1 because it was same cell that be
copied.
Hope it can help you.
Worawat
2010/4/28
Dear Friend,
Thanks for your response, I attached two excel sheet here, one is 'old file'
and other one is 'latest file'.
Latest file is having the latest changes, now i want to compare both the
file so that i will come to know that what are the changes in between them,
what is added,deleted or cha
Dear Balbir,
Copy the column values and in the destination wile pasting give it Paste
Special - in paste special choose "Transpose" your task will be done.
Let me know if you still need in detail the steps.
This should solve your query
On Wed, Apr 28, 2010 at 2:50 PM, balbirkumar . wrote:
> D
Dave - thanks for this, I am going to give it a try. StartCellR is a range
where I want to the macro to start entering data based on the formula that
you are helping me with.
Regards
John
On Tue, Apr 27, 2010 at 10:14 PM, Dave Bonallack
wrote:
> Hi John,
> What is 'StartCellR'?
> Also, if you p
Hi All,
I am using a vbs to insert some text into an excel file, I then add a
macro, run the macro and then remove the macro using
"xlbook.VBProject.VBComponents.Remove
xlbook.VBProject.VBComponents("Module1") " in order to send the users
a clean excel. When the user tries to download using pop3 i
Hello,
Please let me know what was the attachement. I am using excel 2003 and
cannot use any other.
Please assist.
Regards,
Vin
On Wed, Apr 28, 2010 at 11:58 AM, rf1234 rf1234 wrote:
> Dear Vinod,
> Have a look in attached Zipped,It will help you.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Hope it Will Help
Dear Friends,
I want to arrange the series of data in a coloum to series of row. For
example
Data is available in the following Format:
A
B
C
D
1
Cat
2
Rat
3
Dog
4
Lion
5
Want to arrange the data as :
A
B
C
D
1
Cat
Ra
There is an excellent spreadsheet compare addin you can upload from
http://sourceforge.net/projects/spreadshcompare/
It can easily do what you want.
On Tue, Apr 27, 2010 at 10:51 AM, sudhir wrote:
> Dear friends , i m waiting for reply,
> thanks
>
> On Apr 26, 8:59 pm, sudhir wrote:
> > Dear
Hi,
I have uploaded the file AGING_RPT.XLS which also has a notes sheet
with information that hopefully will make it clearer in what are the
requirements.
Again, thanks for any help that you can provide.
Good day,
Wilfredo
On Apr 26, 12:42 am, Dave Bonallack wrote:
> Hi Wilfred,
>
> You have
Hi Chetan,
May be you can Use If condition like below :
=IF(F2>0,1,0) - If the entry is in cell F2. Cuz you put any value more
than 1, it will give you only 1 as required.
Hope this works.
Best Regards,
Haigreeva.
On 4/28/10, Chetan wrote:
> Can anyone help me on this issue
>
> On Apr 26, 5:
hi,
if u went count of identify unique dates for employee ..
put.. =COUNTIF(A:A,A1)
On Wed, Apr 28, 2010 at 12:34 AM, Chetan wrote:
> Can anyone help me on this issue
>
> On Apr 26, 5:13 am, Chetan wrote:
> > Hi Harmeet Singh,
> >
> > Thanks for your reply, It works for Month criteria, But
Can anyone help me on this issue
On Apr 26, 5:13 am, Chetan wrote:
> Hi Harmeet Singh,
>
> Thanks for your reply, It works for Month criteria, But i want it for
> Days criteria , for example if i have 3 entries fro 2nd Jan it shoudl
> consider as 1, for 3rd jan 2 entries then it should consider i
14 matches
Mail list logo
