hi Dave,
thanks for ur replay, well yes its very confusing, i have a file name
AXN which is having some data inside with column A, B, C, now there is
another file (or a sheet2 of AXN) with two column A, B which says
channel name and channel code and data in it is AXN and 234 and other
such
Hi sjsean,
Try the attached workbook.
Put the words No Sales (without the quotes) into any cell on one of the
sheets.
Note that sheet name and then run the macro.
That sheet should be deleted.
Hope this helps.
Regards - Dave.
From: sjsean sjsean95...@gmail.com
To: MS EXCEL AND VBA MACROS
Dear All,
pls go through the attached file.
here i m passing row no, is there any way with out passing any row no it
solve entire for entire column
Regards
Harish Upadhyay
9773284902
--~--~-~--~~~---~--~~
HI
so can u tell me how will u import file name in tha same sheet ... i
am doing +cell(filename) but this is giving whole path but i just
need file name...??
On May 31, 12:18 pm, robin_suv mail2rbhand...@gmail.com wrote:
hi Dave,
thanks for ur replay, well yes its very confusing, i have a
Dear Members
1. I have a table with columns A, B, C, D, E, F,
1.1. Column A has the range of values to be be evaluated and Columns
D,E,F,...have the sum range (values that need be summed up based on
criteria)
1.2. If I just had one criteria I could use sumif function. say sumif
Hi Robin,
You can import the file name into any cell with the following formula:
=MID(CELL(Filename),SEARCH([,CELL(Filename),1)+1,LEN(CELL(Filename))-1-SEARCH(],CELL(Filename),1))
I'm sure that there's a shorter single-formula method, but I can't think of it
just now.
Waiting for your sample
Hi Dave,
I'll try to describe it better.
I have columns like
F J
data1 data2
(empty)data3
(empty)data4
(empty)(empty)
data5 data6
(empty)data7
(empty)data8
(empty)data9
(empty)(empty)
My result must look like:
F J
data1
Dear Subu,
This can be accomplished with Sumproduct function.
Please send a sample sheet, I can work it out for you.
Regards,
Andy
On Sun, May 31, 2009 at 7:40 PM, Subu mail_to_s...@yahoo.com wrote:
Dear Members
1. I have a table with columns A, B, C, D, E, F,
1.1. Column A has the
Dear Excel/VBA user and programmer,
I am looking for a training in Excel VBA starting from Basic to Advanced
level. Currently I do use VBA but with some limited knowledge, however I
think I have gained a good experience of Excel. I am currently based in
Bangalore so if someone can suggest
Hi,
I've managed to get a combo box on a spreadsheet. Now I want to copy
that combo box down in column A for a hundred and fifty or more rows
and the linked cell to each combo box needs to be the adjacent cell to
each combo box in column B. I'll end up using what's in column B
later on for a
Hi,
I assume you are referring to VBA.
VBA can't select a cell or range on a sheet which isn't active.
You have to activate the sheet, then select the range:
Sheets(A).Activate
Range(A1).Select
However, most of the time you don't have to select the cell or range you want
to work on.
For
11 matches
Mail list logo