Hi Ayush,
I can help on content development time to time.
Congrats!
Cecilia
On Feb 2, 10:39 am, Ayush wrote:
> Hello everyone,
>
> I am glad to share that I have decided to launch an excel knowledge website
> for this group.The website will be launched on 4th anniversary of this group
> i.e.
Hi,
If you will have a "." and space separating the supplier name, you can
try: =RIGHT(A1,(LEN(A1)-FIND(CHAR(46),A1,1)-1)) where A1 is the cell
with the supplier name.
Hope it helps!
CC
On Aug 11, 3:43 am, Suhas wrote:
> Hi,
>
> We have a file which is downloaded from HTML page.
>
> The data
Hi,
If I understand, you might solve it by doing:
Your Data New Column
Column A Column B
-0.01 =IF(A2=0,0,B1+1)
0 =IF(A3=0,0,B2+1)
-0.002 =IF(A4=0,0,B3+1)
-0.005 =IF(A5=0,0,B4+1)
-0.01 =IF(A6=0,0,B5+1)
-0.004 =IF(A7=0,0,B6+1)
0 =IF(A8=0,0,B7+1)
-0.003 =IF(A9=0,
Hi Mahesh,
I was not able to open your file since I'm with Excel 2003. Please,
could you save as 2003 and re send? If you can have sheet 1 sorted
ascending, I think that you could use Vlookup without "TRUE" argument
at the end.
Thanks,
Chechu
On Sep 5, 4:07 am, Mahesh wrote:
ach a sample file, but I don't see any button to do
it :(
Thanks!
Chechu
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and T
Forget it, solved! Just need to uncheck the option "Save data with
table layout" in the PivotTable options...
Thanks anyway!
Chechu
On Sep 11, 3:23 pm, Chechu wrote:
> Hi, I am looking for some help on this! I have an Excel file with a
> Pivot Table, using as sourc
Hi Bunty,
Take a look to the following code, might help. It opens each .xls in
the same path where this file resides, and copy-paste predefined rows.
Regards,
Chechu
Sub Macro1()
Dim MyFile, MyPath, MyName, ThisFile, Location, PathFileTemp, Fila,
ThisSheet
'On Error GoTo ErrorHa
Yes, that's the challenge!! I can't unlock the VBA Code, because the
file resides on each user's computer. I have to send a new file with a
Macro to update it
Thanks!
CC
On Oct 1, 3:49 pm, Paul Schreiner wrote:
> If you can unlock the VBA code, then it's fairly simple
> to remove an entire m
nd cause for termination.
> '=
>
> But if the reason is that the files reside on remote
> computers, but the VBA code isn't actually "locked",
> then I can send you some code that you can
> modify to remove th
Sounds good Paul!! Thanks!!
On Oct 3, 4:52 pm, Paul Schreiner wrote:
> Actually, I might be able to help here.
> I'll have to wait until I get back to work on Monday though!
>
> Paul
>
> ____
> From: Chechu
> To: MS EXCEL AND VBA MACROS
Easier!! Given a sheet with the format I sent, I need to create an
output sheet opened by resource location.
On Oct 3, 3:33 pm, jamesdavey wrote:
> so you mean, for example, you want to add a new resource manually,
> then press a button perhaps to update an output sheet?
>
> On 3 Oct, 12:42, Cec
So no suggestions
On Oct 4, 1:37 pm, Chechu wrote:
> Easier!! Given a sheet with the format I sent, I need to create an
> output sheet opened by resource location.
>
> On Oct 3, 3:33 pm, jamesdavey wrote:
>
>
>
> > so you mean, for example, you want to
Not sure if I am correctly understanding the request here, but I
use the following code in some of my tools to track users usage:
Sub Auto_Open()
Dim serverfile As String
serverfile = "\\org\public\Hittrk\history.txt"
On Error Resume Next
Dim str As String
str = Application.UserName
str = str
Works in Excel 2003, not sure about 2007:
1) Insert in your worksheet the shape that you want later in the chart
2) Select the shape, and CTRL C (copy)
3) Select the chart, select the bubbles you want to change, and CTRL V
(paste)
Hope it works in Excel 2007.
On Jan 7, 8:05 pm, Keith25252 wrote:
Hi, I need some help in an export from Excel to Access macro. I have
an Excel tool which will be used by many users. In this Excel, I have
a range, let's say in Sheet 1, A1:B20, that I need to export to
Access. I mean, each user will have to click a button and export to an
Access database located i
t, I never worked with this kind of export/import out of
Excel
THANKS a lot,
Chechu
On Apr 8, 6:19 am, paulwillekens
wrote:
> Hi Chechu,
>
> Why not export that particular range in a .csv file, that would be
> stored in a dedicated folder on the network, and imported by Access on
&
eparate e-mail
(same subject) with the Excel file. May be it looks too complex for me
but it is easier than what I see
THANKS!
Chechu
On Apr 8, 1:01 pm, paulwillekens
wrote:
> There are two sides:
> a) the user side: if a1:b20 is all the sheet contains, the user could
> save
Hi Paul,
Ops, I’m sorry I posted the file as a different post; I didn’t know
how to do it following the original! I definitely agree with you,
a .vbs operated centrally after end user signs off on his
data entry. Then if I understand, user will sign off by exporting part
of the Tracking sheet to a
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.
I'm just one of the 7.000 group members, so I represent less than
0.01%. But in my opinion, if we are 7.000 members, is because this
group day after day helps people to solve Excel / VBA questions and
learn more on this topic. The focus is Excel and VBA Macros, as the
group name says. If I was look
20 matches
Mail list logo
