Hi All,
Please let me know how to automate two things in excel:
1. I need to give a number in A1 cell of 'Data' sheet (1st sheet) to add the
total number of rows in two sheets i.e. in sheets 'Data' and 'Analysis'
2. All the formulas in the 'Analysis' sheets should automatically copied to
new gene
it is not clear what you want.
you entered the date as text because you entered an apostrophe at the
beginning.
in excel enter the date as m/d/yy that is, in this case 10/20/09
now you have entered as texts in 4500 cases you have to convert to
excel date
in an empty cell in the same row type this f
You could just use Global variables.
On the On_Click event set the globals = to the value in the textboxes on
your form.
On Mon, Nov 16, 2009 at 6:50 AM, laudes wrote:
> Thank you a lot for your help. It worked with the "call", and sorry
> for the delay.
>
>
> On 8 Nov., 00:20, Fabio Lemos wrote
Your question makes absolutely no sense.
On Mon, Nov 16, 2009 at 8:26 AM, big smile wrote:
> Respected Excel Friends,
>
> Attached please find the excel sheet -- in which i have explained my query.
>
> Try to resolve it
>
> Thanks
>
> J C SHAH
>
> --
>
> -
Just run the macro or press ctrl+g,it will do the needful you required.
Regards,
C.G.kumar
On Mon, Nov 16, 2009 at 1:23 PM, Nandkumar kakvipure <
nandkumar.hindust...@gmail.com> wrote:
> Hello
> Pls change the date format and tell me solution
> me manually nahi karsakta because 4500 customer
I have some VBA code that sends an email automatically after attaching
an Excel file.
The email gets sent using my corporate email account. Is there a way I
can make the FROM email my team's group email address rather than
mine?
--
-
Respected Excel Friends,
Attached please find the excel sheet -- in which i have explained my query.
Try to resolve it
Thanks
J C SHAH
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video a
Thank you a lot for your help. It worked with the "call", and sorry
for the delay.
On 8 Nov., 00:20, Fabio Lemos wrote:
> just remove the parentesis as follow:
>
> Modul1.Get_Param CInt(TextBox1.Text), CInt(TextBox2.Text)
>
> 2009/11/6 laudes
>
>
>
>
>
> > Hi all
>
> > I've got a problem a
Check the file.
On Sun, Nov 15, 2009 at 6:39 PM, Dilip Pandey wrote:
> Dear Dan,
>
> I have tried to build up the data as mentioned by you and able to get the
> desired result.
> Same spreadsheet is attached herewith for your review.
>
> Best Regards,
> --
> DILIP KUMAR PANDEY
>MBA-HR,B COM(
Dear Excel User,
You have submitted this issue in several post. It's not a good
practice
Some users have already responded to your request.
I think that you should maintain one post for your issue so you can
capitalize the suggested solutions.
Best regards
On 14 nov, 09:33, Jitender wrot
Dear Mahesh,
One option could be to put the Excel File / Or its shortcut in Startup
Folder of Windows at your login. Now, whenever system boots up / logged in,
the Excel File automatically opens up and you can see the tasks due for that
day only.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B C
Hello
Pls change the date format and tell me solution
me manually nahi karsakta because 4500 customer same problem
Problem Yellow mark
find attach file
Thanks in advance
--
--
Some important links for excel users:
1
Hi All,
It is possible that whenever i open my system, this excel open automatically
and show all the things to do.
Rgds,
Mahender Bisht
On Sat, Nov 14, 2009 at 6:53 PM, Dilip Pandey wrote:
> Hi Punit,
>
> Used Excel VBA coding in order to solve the task and attached herewith.
>
> Best Regards
13 matches
Mail list logo
