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