Hello Vicky,
I'm not at all coping data from any where otherwise I would have used the
"paste special". I'm pulling data from software & which some times finish
within 10 rows & 10 columns & sometimes it's cross 30 columns & 100 plus
rows.
If somehow I want to tell excel that follow my 10 step
Hi there,
I'm new with excel macros and have to build a macro to hyperlink the items
in the Master-Activity sheet with the items in the Details-Activity sheet
in the same workbook.
Please check out the attached excel file with the sample data and detailed
comments.
This file has two sheets
1
Hi,
Could u see the error..
Regards
On Sun, Mar 23, 2014 at 6:29 PM, Deepak Rawat wrote:
> i tried the code but giving ubound error, sample is attached,
> kindly check
>
>
> On Sun, Mar 23, 2014 at 6:19 PM, Deepak Rawat wrote:
>
>> Hi,
>> i tried but not working but showing #Value! Error
>>
>
You sure you are pressing Ctrl+Enter after you have chose the reference
cell? I personally used this many times, it never failed me. Here's how I
do it:
1. Press F5, Go to > Special > Blanks.
2. Without losing the selection of blank cells, put *=* and select my
reference cell (preferably with an a
Hi Suyog,
My understanding is you would like to have same format for all data so my
logic is rather formating each line of data I have saved your format in
"Format" tab in attached sheet and then that format will be applied to your
copied data in Original Sheet.
Same as we do in Excel using *Pas
Hi,
I have a large set of data from a report that leads to lines of blank data
for certain variables. A certain person may have multiple children
attributed to their entry which creates multiple rows for them but does not
fill in their pertaining data. I am trying to figure out a simple solutio
Hello All,
Greetings for the day.
Pl refer attached excel, I'm using one database software & when I pull out
different reports from that I need to do 10 steps for each report every
time. I've tried to record macro also but I don't know how to find out
"last cell which contains text" sometimes
any help?
On Sat, Mar 22, 2014 at 3:24 PM, amar takale wrote:
> Dear All Experts
>
> Pls suggest me VBA Code for Sector wise sort company.Code should be
> simple & easy where I change range data only as per my need.
>
> Regards
> Amar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do yo
