if your 10 categories are in column C and D
Your 10 categories here
ColumnC ...ColumnD
Orange.....Fruit
Fish...... SeaFood
Burger.... JunkFood
------ ------
------ ------
And your List in Column A and your Result will be in Column B if yoou input the vlookup formula in cell B2...
if the data in your columns can have blanks, then use
Sub Master()
Sheets("source").Activate
Range("A2:X2").Select 'assuming your data is from A to X - you can change this
Range(selection, selection.End(xlDown)).Select
rcount =...
Insert a button from Develepor tab and then hit "New"
which will take you to VBE (Visual Basic Editor). here paste the code below:
Sheets("source").Activate
Range("A2").Select 'assuming you have headers in column 1
Range(selection, selection.End(xlToRight)).Select...
Akash,
I tried the code in above link, and it says "An unexpected error has occurred. Changes to your data cannot be saved"
However, as I need the data to be appended, I doubt if this would solve my problem.
as you stated:
can you help me with those commands - I have really no clue on...
Thanks for the link Narayan, I infact had googled this link before, however, what Im looking for is :
An excel template with a macro - from which data will be updated by multiple users(which means each one will have their own copy of this template(say temp1)),
this data needs to be appended...
Hi All,
I'm looking to update/append data from Excel to Sharepoint, and again retrieve the same.
I basically need this for multiple users having the excel template with macro to update their respective data, which gets updated onto sharepoint, and then when I run another macro, I get all the...
Using the same code of Luke:
the below should help you
MyChoices = Range("A1:A40")
DropDownBox = Range("B2")
'Loop 40 times
For i = 1 to 40
DropDownBox = MyChoices.Cells(i,1).Value
'Make chart
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:UserssmithDocumentscopy" & i...
In your module, at the time of opening the workbook
Type this
ActiveWorkbook.Protect ("Type Your password here")
and once the macro is run, and before saving the said file
type this
ActiveWorkbook.Unprotect ("Type Your password here")
This will help in unlocking the sheet...
When you used a variable range/cell, did you still use:
desti_range.Paste
Then it no more works, but if you just use
Range("A" & rcount).Select '*see below
activesheet.paste
then it should work.
*rcount or any "x" being a variable can be used- You can also change the column...
Hey Dee,
You are getting that error message as the Copy Mode is getting deactivated when you try selecting the destination range.
You can try using the destination cell as a variable (depends on your requirement)
SS23
HSK - Probably you could use the advacned Filter, however It would not copy to another sheet.
Also you can have a look @ http://chandoo.org/wp/2010/11/10/vlookup-second-value/
*the Sample File
However, if the number of instances a Name repeats is not constant, the file may become huge...