PDA

View Full Version : Excel Help


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 [114] 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174
  1. Solved: finding row and skipping over data
  2. Loop thru FTP sub-folders, downloading, renaming & uploading their files.
  3. Create orders log and monthly report for all orders
  4. External Workbook Lookup and Match
  5. Combining multiple columns into 1 for pivot table
  6. Trying to open Excel 2010, auto-open Excel 2003
  7. I need VBA code to update log worksheet and maintain a history of all orders.
  8. Excel, send emails, vba, question
  9. Run time error '429': ActiveX component can't create object
  10. Compare and delete duplicated data from several columns
  11. Run time error '429': ActiveX component can't create object
  12. Solved: Trouble with copying in a loop...
  13. if find matched data, delete the column data
  14. Automating distribution of emails with excel attachments with VBA
  15. Simple but not for me :(
  16. extracting a single row from a multi row/column range
  17. Solved: If in particular column written text then other column should be numeric
  18. Run Autoit File from Excel File Location
  19. Solved: Auto Fit Selected Row Plus 10
  20. Understanding Code - Check If Named Range Exists
  21. [SOLVED:] Interpolation function with empty data
  22. A bit of Help with an array code
  23. Building a Call Tree (work in progress)
  24. Not Copying the Value of an equation from range.
  25. Excel VBA control loop with Find
  26. If formula - Can't get to work properly
  27. Application object names, true, false etc
  28. Solved: Accurate specific cells must be maintained in the concrete columns on another sheet
  29. Solved: Conditional Format
  30. Solved: Parsing an array, calculating cumulative sum and spitting some output
  31. edit vba code for display In Exponential Form
  32. Solved: Subscript out of range when using name of workbook that exists
  33. Solved: If Or Statement
  34. Solved: Rename the name of files
  35. Macro to count words
  36. Solved: Trouble with syntax?
  37. RefreshAll complete event
  38. Help with macro code found on this forum
  39. Solved: Copy and Paste to new row/column IF values exist in paste
  40. Input Box: Ranges...
  41. VBA Macro to Count Rows across Multiple Workbooks
  42. Out of memory when saving file
  43. Solved: Selection.Find Error handling
  44. text help
  45. edit code for display In Exponential
  46. VB Code partially working
  47. Write Res Password - Force ReadOnly unless Macros Enabled
  48. Solved: Mouse over a particular column in ListView to display a message
  49. Solved: Auto-populate column with hyperlink code
  50. Using a variable to as criteria in autofilter
  51. Solved: Renaming modules
  52. Solved: VBA to replace specific alphabets with blanks
  53. Solved: (VBA) Export to .txt only specific columns without empty cells
  54. Kick off macro at 8:15 am central time
  55. Solved: Stepping through Userform VBA code
  56. Find the max and min from a range of cell given a criteria
  57. Solved: Making two cells date and placing them with a hyphen in a cell
  58. Help to extract data between tags in webpage html
  59. loop to fill different cells regarding an Data base
  60. Solver in VBA- Project Dependencies
  61. Show formula and absolut reference
  62. How to code a boolean expression parser?
  63. google spreadsheet help
  64. google spreadsheet help
  65. Solved: copy ranges (tables) separated for separate tabs
  66. hi im new to VBA need some help copy and pasting with a twist.
  67. Look at Sheets that begin with Shop* then see if data exists in Range...
  68. Duplex printing of specific sheets in workbook?
  69. VBA to Add ListItems to a ListView
  70. Application to enter data from columns that are in the various documents
  71. Pivot chart - Auto change Data source
  72. Help with modifying code to look for like sheetnames
  73. textbox color change
  74. Get Data from IE Error ....
  75. Copying columns from multiple sheets to master
  76. Update Multiple workbooks with Master File
  77. vba combobox help
  78. After print event
  79. Open objFile For Input As iFileNum opens only 512 files and fails to open 513th
  80. Help with VB to VBA
  81. Vlookup query
  82. Asking about Using VBA in Excel for Download Financial Data
  83. .txt -> .xls format
  84. Solved: Date Format Problems
  85. Excel Compatibility issue
  86. Solved: What's the use of a class module
  87. Uncheck boxes in one group only
  88. Merging cells based upon values
  89. Find repetition in data values
  90. Formulas into VBA
  91. Page Numbers
  92. Macro to insert batch hyperlinks from external sheet [pics]
  93. Selecting a range based on a date range
  94. [SLEEPER:] Values and Reporting
  95. [SOLVED:] Plz help to modify search VBA (Data sheet to another file)
  96. Consolidate Lists
  97. vba code required to help populate emails with details in spreadsheet and send
  98. Color Entire row based on the date
  99. check if a surname is repeated within a cell and output a simpler name
  100. VBA: Multiple Autofill in same column
  101. Autofilter - Worksheet Calculate
  102. Question on Row References in VBA
  103. Solved: Transposing Irregular Data
  104. Help with an Export Macro to Excel
  105. [SLEEPER:] Search
  106. Multiple Actions on each cell in loop
  107. extracting from web
  108. Solved: Use VBA to assign assign code/a macro to a custom button added to a toolbar?it
  109. Solved: text to column question
  110. Drop down problems
  111. Copy\Paste
  112. How to Extract Title from a Text file and Paste to Excel
  113. [SOLVED:] vba code for remove blank cells
  114. VBA 2010 create PDF from multiple sheets
  115. Help using For Next loop to delete ranges
  116. Combining Spreadsheets by feature
  117. discret convolution
  118. Solved: Averaging figures logged in the AM vs PM hours
  119. Mail attachment through EXCEL
  120. Copy Paste Code
  121. Upon returning research userform,date is reversed MM/dd/yyyy(I.need.DD/mm/yyyy
  122. Help please - very new to this
  123. UserForm to select items from dependent lists
  124. [SLEEPER:] VBA to extract all images from word file
  125. VBA for Investment
  126. Election results
  127. [SLEEPER:] Sum Till Target is Reached
  128. Grouped Cells - show and hide groups in code
  129. Programming help
  130. [SOLVED:] Cut and paste records based on multiple criteria
  131. Probably an easy question for you VBA pros!
  132. Question on Target.Parent.Active
  133. Help required - please
  134. Efficient Macro - Suggestions
  135. [SOLVED:] Filter on matching data in two columns
  136. Solved: Help with labelling of graph
  137. Sending Emails from Excel Via Outlook 2007
  138. Solved: User can only save workbook if completed, or close without saving
  139. turning off calculation on all worksheets
  140. How can I add a file to the playlist of VLC when it's already in use
  141. VBA SetCursosPos with co-ordinates of cell value
  142. Matching Co-Ordinates
  143. Import selected cells from multiple WB's to 1
  144. Solved: double click worksheet event limited to a worksheet range
  145. Scripting Web Form
  146. Solved: Count Unique Values When Filtered
  147. Basic Help: Copy value from one sheet to another
  148. Basic Help: Copy value from one sheet to another
  149. Solved: Error using file on another computer
  150. Need Visual Basic code for macro to select pivot field name indirectly
  151. Browse to a folder and extract all workbook names to a sheet in a workbook
  152. Track and display multiple changes by different users as comment
  153. Excel visual basic (ctrl+click) copying clicked cells to new excell file
  154. [SOLVED:] Writing VBA code to loop
  155. finding 12 numbers that'll give me the most result in a row of an array
  156. datatype mismatch in criteria expression
  157. List Folder Based On Search Word
  158. get html img src filenames by Excel VBA
  159. Solved: auto complete based on the first and last name (combobox / UserForm)
  160. Conditional Copy Paste Code
  161. Solved: Looking for values outside of a range
  162. INSTR
  163. Checkout system
  164. Automatically create Combobox
  165. Solved: Understanding Date and Time Formats
  166. Add List value to hyperlink
  167. Need help on reconcile two worksheet
  168. Need a loop script to copy from one 'data' workbook' to a template, make some edits,
  169. Solved: Refering to a specific control in a class object
  170. function operations
  171. Counting Unique Values to Generate a List of the Top X Largest
  172. Solved: RmDir generates File/Path Access Error
  173. Save as csv
  174. GoTo vs Call
  175. [SLEEPER:] Trying to copy current worksheet name
  176. Ommitting Unused Data on Cell
  177. Help with conditional values
  178. Automating tables creation with VBA code
  179. Navigate to WebBrowser problem
  180. Table of content
  181. Run-Time Error '424' Object Required
  182. [SOLVED:] For Loop - increase stop counter due to inserting rows ?
  183. Solved: Please explain!!
  184. Solved: VBA Copy and Paste Specific Cells Based On Another Cells Value
  185. Update External Link in Text Box
  186. setting source data for a pivot using variables.
  187. Problem with a loop that compares two columns of data
  188. Solved: Moving data from form to worksheet
  189. Help with form
  190. Combobox dependencies
  191. Simple inserting column then titling
  192. Solved: Transferring data from Excel to Access macro
  193. Solved: I need help edit code hide rows in excel
  194. [SOLVED:] Visible Cell .EntireRow.Delete 2010
  195. Solved: For Next help
  196. Solved: Dimension help when closing workbook.
  197. Macro printing to refer to cell and named ranges
  198. Help with vba code
  199. For Each Loop looping to many times
  200. Creating index sheet in excel. Help
  201. [SLEEPER:] Excel formula help to check type of leave and calculating total days
  202. Need help for a macro to match data in excel!
  203. Lock specific columns
  204. Sort by Distance to Each Successive Point
  205. Pivot table help please
  206. How to auto enable circular reference?
  207. Solved: vlookup
  208. VBA loop help
  209. Need macro for taking data from one sheet and autopopulating another
  210. Restricting Save As Options
  211. Solved: Picture Size
  212. Get Data Only from Certain Records
  213. Command Button to combine multiple worksheets into 1 pdf
  214. Pivot Table Field selection
  215. Solved: Is this a good way to check if a cell contains a valid time?
  216. Checkbox - Automatic Copying to Different Sheet
  217. Not really sure how to title this...
  218. VBA to Change Connection String of all query's in a workbook
  219. into string value into range based on lookup in another workbook
  220. macro execuation to delete folders
  221. Search for character within a value (VBA)
  222. Autofilter based on cell from another workbook
  223. Solved: not case-sensitiv alphabetical order for combobox values
  224. VBA Filtering
  225. Calling a function, click a link using VBA
  226. data from another workbook and implementing conditions
  227. userform with option to Copying & Inserting Rows
  228. Solved: Check that an excel file exists
  229. Solved: VBA Help with Copying Data and Formats from Rows
  230. Solved: Filter Range Issue.
  231. [SOLVED:] Sort contents in a text file.
  232. vba comments
  233. Solved: Help on selecting unique random words from a list.
  234. Nested Formulas to skip 0's?
  235. Array formula to extract in-between dates
  236. Solved: Help to solve a little mistery
  237. Add digital signature using excel VBA to PDF
  238. Split words in each cell in range and compare to see if in another range
  239. Getting cell coordinate from the last cell with text in it in a ranged row
  240. [SOLVED:] IF Function Help
  241. Solved: Split Longitude and Latitude values
  242. How To Deconstruct Formulas Into VBA
  243. [SLEEPER:] FolderShortCut
  244. Need help to combine two tables under certain conditions
  245. Solved: Modify Code To Offset by 2 To Destination Sheet
  246. it is possible to freeze more than one row in excel?
  247. Solved: Using Union to combine two ranges
  248. Basic VBA - Active X control to also link to cell value
  249. Updating Internet Web page from excel
  250. Random numbers from a range to specific sum of randam values!