• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    How to populate a column in excel?

    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...
  2. S

    Make a Form in Excel

    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 =...
  3. S

    Make a Form in Excel

    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...
  4. S

    VBA to update data from Excel to Sharepoint Tables/Lists

    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...
  5. S

    VBA to update data from Excel to Sharepoint Tables/Lists

    Akash - Im looking to update the data into SharePoint list. Will check the link that you provided - thanks for your time.
  6. S

    VBA to update data from Excel to Sharepoint Tables/Lists

    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...
  7. S

    VBA to update data from Excel to Sharepoint Tables/Lists

    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...
  8. S

    How do I use this macro correctly?

    Sorry Luke, dint see you posting :)
  9. S

    How do I use this macro correctly?

    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...
  10. S

    Macro Error

    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...
  11. S

    Share your favorite Excel Sites

    I vote to http://www.ozgrid.com/ http://www.mrexcel.com/ and ofcourse : http://www.cpearson.com/excel/topic.aspx S23
  12. S

    Copy paste taking reference of source destination range from input box

    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...
  13. S

    Copy paste taking reference of source destination range from input box

    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
  14. S

    Fetching multiple records from a excel table.

    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...
  15. S

    If function problem

    pradeepthota, Probably you can have a look at http://chandoo.org/forums/topic/shiftless-worksheet-fill-shift-cell-based-on-time-cell
Back
Top