Hello SirJB7 and bobhc,
I would firstly like to appologize yourself and others ( imla , Smallman ) who have faced problems because of me. Since I am a fresher in excel where I do not even know some of the simple formulas, there understanding of the code language and using it for my application...
The link
https://dl.dropboxusercontent.com/s/mzeskwns17zd35x/Photos.zip?token_hash=AAH8APbgk4OXlLWnBLjzwhtD7UM1bp2QL-M7q2KovU45xQ&dl=1
The pictures that have been shown is just for
and example purpose. The actual pictures are difficult
to show because it is against the company rules and I...
https://www.dropbox.com/s/kif1rc086gwyboj/PrdctApprl.xlsm
This is the link
I some how have tried. If you are able to download then
I have done it perfectly or I will have to try again.
thanks
Hi bobhc
I think it is miss-understood.
even today I have the file ready but the same
problem. How is the file attached. Previously I tried twice in this
site for the attach file button or option but could not
locate and then I got busy with my other work and the issue
is pending.
kindly...
I had posted this sometimes back
and one of the community member did reply but some
how it did not work at my end or may be my mistake
which I could not notice. But after that the printing
format and pattern got changed. I am still
looking for the solution.
I have a chart prepared in...
Hi Luke
Sorry for the delay since I hade to
learn first how to record a macro.
It was good and easy and solved my problem
thanks for the solution.
If I am stuck up with some other issue
I will disturb you.
I have a HP Laser printer and every day at the end
of the day I have many printouts to be taken on a
A4 page from different files.
Is it possible to design an instant button on the
sheet it self where I just click and I get
3 copies of that sheet printed.
I donot want to go to print...
sorry! did not work
even I have 2007.
however as I enter the code
for eg 1001 in A2 in sheet1 the row becomes
big and specially the L column becomes
as per the mentioned size. That part
is perfect. Only the pic is not attached.
thanks
I tried but not working
I A2 I have put the code 1001
and in A3 it is 1003 and with the same name
I have a .jpeg image in D drive in Photo folder
But the column L is not showing the picture
thanks
This one is related to images
I have in my D drive a folder named Photo where
all the images are cumpolsary in jpeg format.
In excel in column A from A2 onwards I have the
Product Code. This code exactly matches with the
image name in the photo folder.
I want a product image added in the L...
I have Excel-2007
I have entries in one sheet whose name I have given
as Records where I have 16 columns.
First column is named ProductCode which has all
numeric number which are unique. I have approx 10000+ records.
One of the column is named Qnty.
What I want is in sheet2 a userform kind...
This is just an example
Code ItemName Pkd Qnty
55093 Eggs Jan-2013 5
55094 Bread Jan-2013 10
55095 Butter Jan-2013 8
55096 Oil Jan-2013 12
55097
55098
As you see every Item has a unique code.
I cannot use 55097...
I have Excel-2007
I have entries in one sheet whose name I have given
as Records where I have 16 columns.
First column is named ProductCode which has all
numeric number which are unique. I have approx 10000+ records.
One of the column is named Qnty.
What I want is in sheet2 a userform kind...