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:] Copy Data based on cell value
  2. [SOLVED:] Shift column from row 3 to left
  3. ENABLE COMMENTS BUT PROTECTING OBJECTS
  4. [SOLVED:] Delete filtered rows - 2 conditions
  5. [SOLVED:] Textbox Loop
  6. Excel VBA Double Click or Hyperlink That Filters For Value In Another Workbook?
  7. IF statement for pasting entries into another sheet
  8. [SOLVED:] Macro to only allow data to be copy pasted based on data validation criteria
  9. Macro to Copy and Paste from Adobe Reader to Excel
  10. How to Separate One Long Column of Data into Separate Columns
  11. Copy Sheet - Change Name with a twist.
  12. [SOLVED:] Looping Advanced Filter specific to current worksheet
  13. [SOLVED:] If column F is not empty merge data with column C
  14. If then, Go To Next Sub using a filtered column in VBA
  15. =IF(J2=B2,"Match","") ???
  16. [SOLVED:] Issue with getting last member from an array
  17. help to fill the table
  18. Send email via Lotus Notes by clicking a button
  19. Give permission to users to change data in Excel using VBA code [VBA]
  20. How to enable user name and password in remote desktop
  21. [SOLVED:] VBA code to search for online data and import into excel
  22. vba to extract selected subfolder name and file names
  23. Excel application crashes on ImageSearchDLL without any error.
  24. Stringing a bunch of Subs together creates an error But running separately does not
  25. Macro to refresh only sometimes working?
  26. [SOLVED:] enter choosen OptionButtons caption to cell
  27. VBA to sort horizontal rows Help
  28. [SOLVED:] Circle Invalid Data
  29. [SOLVED:] Clean Up
  30. [SOLVED:] copied userform error
  31. Hide Rows in VBA
  32. [SLEEPER:] Can I disable Excel 2013 Start up screen using VBA?
  33. [SOLVED:] Graphics with multipage form
  34. Decision tree with VBA
  35. Loop through files in order of date created
  36. Code won't paste into excel table, always outside it?
  37. Force SaveAs for this macro only
  38. Formula to change cell color based on if it is within two dates
  39. Range with Table VBA?
  40. [SOLVED:] Is it possible to add a mouseover tooltip to a cell?
  41. [SOLVED:] VBA Script to extract MS Word document to Excel
  42. [SOLVED:] Macro to upload data from a file into a summary file
  43. [SOLVED:] Paste only Values from sheet 1 that are not in Sheet 2 into sheet 3
  44. Using VBA to Autofit Visible Rows
  45. Index Match Formula to VBA
  46. Click on a blank cell and have text appear in another cell
  47. [SOLVED:] Split the row to column
  48. Lock selected range except for current week
  49. [SOLVED:] Assistance for code pasting data into few columns and leaving few columns blank
  50. [SOLVED:] If a word in a cell in col A matches the name of a worksheet, move row to that sheet
  51. [SOLVED:] Copy Paste Shapes to Different Worksheets Loop
  52. Loop to match headers on seperatesheets, copy data below, return and paste in header
  53. Macro to attach Worksheet to a new E-Mail in Lotus Notes as PDF
  54. Range Values
  55. Find bottom right cell, and then highlight bottom row
  56. Export from Excel to PPT then Apply Custom Slide Layouts created in SlideMaster
  57. Creating new sheets based on date and other criteria from sheet 1 and 2
  58. Avoid duplicate entries
  59. Dataset Help
  60. New Worksheet from listbox name!
  61. [SOLVED:] Application.OnTime loop keeps falling out
  62. Deleting and Adding new Chart Using VBA
  63. Fill multiple comboboxes from same range variable
  64. VBA to write to CSV in certain way
  65. Different print.
  66. Application-Defined Error: 1004
  67. Creating a pivot table
  68. [SOLVED:] Simpson's Rule in VBA
  69. [SOLVED:] Quick question about Listboxes
  70. [SOLVED:] VBA unable to set CF for second range
  71. [SOLVED:] Check For Existing File and Create New if Not Existing
  72. [SOLVED:] Userform Label Class - Reference Worksheet Cells Range - Run Macros Event Click
  73. VBA loop to replace 5k+ array formulas and circular referencing
  74. [SOLVED:] WorksheetFunction.Sum not working
  75. Edit MS Access data using Excel
  76. copy custom tablestyle into new workbook
  77. [SOLVED:] Looping test bed for 3 variables
  78. [SOLVED:] Macro to paste Approval Data from Row 2 and Reject Data from Row 20 on sheet2
  79. Excel vba - Match Data
  80. How to compare data in a spreadsheet
  81. [SOLVED:] Delete all VBA Modules - Except a Few
  82. Userform macro to update data in specific range
  83. Select Non Continuous Range
  84. Help with coding (Macro)
  85. [SOLVED:] Changing the code from sheet to whole workbook
  86. Can an Excel Macro count categories in Outlook 2007 from a shared mailbox?
  87. VBA to copy random record from a range
  88. Macro to Separate Text in a Cell
  89. [SOLVED:] Macro to insert rows based on cell value
  90. [SOLVED:] Copy&paste only if live value has changed from previous loop
  91. Automatically mapping and collating data into a new workbook using Excel VBA
  92. [SOLVED:] Combined multi columns values in one column separated by coma
  93. Assistance With Code Which Is Causing Excel To Close
  94. Pls help *Urgent* VBA Macro Problem
  95. [SLEEPER:] VBA Excel increase invoice number and save (need help with code) Excel 2003
  96. Textbox macro to update data from 2 different rows on sheet2
  97. [SOLVED:] Format only selected text on textbox userform
  98. Writing userform List Box entries into a worksheet
  99. Create a numbered list from string
  100. POP - UP Window on Excel file start
  101. [SOLVED:] How do I lock the contents of a moving cell?
  102. Custom VBA Column to Row Insert and Transpose
  103. [SOLVED:] Excel 2013>VBA>Clipboard
  104. [SOLVED:] Excel 2013>VBA>Sheets>Array
  105. Excel 2013 -> need help having two macro's in a workbook - already have one running
  106. [SOLVED:] VBA Excel - Collections unexpected answer
  107. Consolidating worksheets into one and paste special
  108. Excel vba to open ie ribbon
  109. Excel to ask what activity I am doing every hour
  110. [SOLVED:] VBA Excel clear cells causes error 400
  111. Nested IF Statements - Please Help to Resolve
  112. Macro to Find Cells by Color and Copy to Different Worksheet
  113. [SLEEPER:] Email Sending Userform problem
  114. Check Points within Rectangles
  115. [SOLVED:] Need help with constructing a vba code, please!
  116. [SOLVED:] Addressing problem in loop
  117. Macro to check value, open file, copy value, loop through range.
  118. Transpose Horizontal Table
  119. Calculate distance between point and rectangle
  120. [SOLVED:] Linking to cells in another sheet with VBA - Can my code be improved?
  121. Drill Down Pivot Same Page
  122. [SOLVED:] Populating specific cell with data from a userform when an option button is selected
  123. Navigation With Firefox
  124. Find external links within code
  125. [SOLVED:] Find and open latest csv file in given directory
  126. Filter large files without opening
  127. [SOLVED:] Windows activate + Todays date
  128. [SOLVED:] Moving Data around in a Row.
  129. [SOLVED:] Deleting rows based on values of cells in TWO different columns
  130. [SOLVED:] VBA multiple Goal Seek depending and selection
  131. [SOLVED:] Need help constructing VBA code to enter selected letter into cell after data already
  132. Split data based on criteria
  133. Need help wth a Macro
  134. [SOLVED:] Exit Do after search item no longer found in a range
  135. Help with Macros for Conditional display
  136. [SOLVED:] Custom Formatting
  137. Dynamic gradient chart background
  138. Open outlook new email and attach most recent file from directory
  139. Copy Data from One Sheet to another Specific sheet
  140. Compile error
  141. [SOLVED:] VBA & OLAP Pivot:Code to set report filter pvt field with items from another pvt tabl
  142. Macro help to copy from Excel into email without duplicating info
  143. Select range on Row until last empty cell
  144. [SOLVED:] Issue consolidating data to another worksheet
  145. [SOLVED:] Need help with constructing a macro that counts dates as one day.
  146. [SOLVED:] Copying multiple sheets with varying numbers of rows to one sheet.
  147. Copy a range of cells
  148. [SOLVED:] Need help restructuring or recreating VBA code Please!
  149. [SOLVED:] Help, i need to create a command button for saving selection as txt file
  150. [SOLVED:] Save Workbook As .txt File With Delimiter
  151. [SOLVED:] need help constructing a vba macro by using a key chart to reanslate number combin to
  152. [SOLVED:] Macro to automatically paste the selected column into another sheet
  153. [SOLVED:] VBA to open file with date and partial name
  154. [SOLVED:] VBA :FORMAT AS TABLE BASED ON ENTERED DATA
  155. [SOLVED:] How do I create a macro that allows me to show and hide rows with only one button?
  156. [SOLVED:] Problems with hidden rows
  157. [SOLVED:] Excel 2013>OFFSET>Count visible columns in a row that are >0
  158. Replace Multiple Carriage Returns with Single Carriage Returns
  159. VBA to autofilter between dates in one column based on text value in another cell
  160. VBA to auto filter based on 4 criterias
  161. [SOLVED:] Sending e-mail from Excel with Outlook behaving badly
  162. move email from a frolder to different folder from Desktop
  163. [SOLVED:] VBA to copy row if cells contain value
  164. [VBA] Query an Outlook Distribution List from Excel
  165. [SOLVED:] Run Time Error when I click on a button twice
  166. How to sort numbers and strings at once?
  167. Open Workbook when the workbook name is combination of cells
  168. [SOLVED:] Need Help in contructing a Macro the returns frequ. of searched data in chart,please!
  169. Help with Reusing file name
  170. Help with workbook source and textbox value
  171. [SOLVED:] Toggle Visibility of the Drop Down of A Specified Table Column
  172. vba to append data by sheets name
  173. VBA code to apply to whole workbook
  174. [SOLVED:] Need help restructuring code tohighlight numerical data w/o special characters please
  175. If first conditions is NOK else go to second condition
  176. Transferring Data Between Sheets (Excel VBA)
  177. [SOLVED:] Change Layout of Column chart
  178. [SOLVED:] Script to desseminate broker statement into trade journaling software
  179. Import Multiple Text Files from a folder to multiple worksheets
  180. Data Validation / Indirect help
  181. Consolidate and remove duplicate
  182. Macro to copy the 0 number
  183. [SOLVED:] Problem with Macro
  184. How do i select a table range in VBA
  185. From a form - write todays date and a variable value in the next available row
  186. 'Unique Filter' applied on look back for multiple entries
  187. VLookup in VBA returning an empty string Why I was expecting the value I was serching
  188. macro to copy excel to powerpoint
  189. [SOLVED:] Range " does not contain" - code
  190. VBA Script to Copy Excel Chart to Word not working in later versions of Word
  191. Print sheets based on partial sheet name?
  192. Excel 2013>VBA>Named Range>Display filtered range in listbox
  193. Stacking columns from several worksheets into a new worksheet
  194. [SOLVED:] Detect listbox item is numeric problem
  195. [SOLVED:] VBA: copy/pastespecial between workbooks
  196. Please configure my code with automatic filter
  197. [SOLVED:] Problem with pasting a concatenate value using VBA
  198. [SOLVED:] Page in multipage form dont show picture, comand button and so on after swapping
  199. Else If - Do Nothing
  200. Comparison between two worksheets and find the difference
  201. [SOLVED:] I need to remove the offset
  202. Excel 2013>VBA>AutoFilter>Multiple Fields Multiple Criteria
  203. need a 2 input solver
  204. Stepped through with no issues...but still obtained an error?
  205. Copying an entire row and pasting it on next row (loop)
  206. How to call Auxiliary Functions
  207. VBA works in one workbook but not another
  208. Run code if hyperlink clicked falls in target range
  209. Can't Get Userform to Pop Up After Deleting Worksheet
  210. VBA script to auto send e-mail using closed Excel Workbook
  211. VBA for workbook path sending in an email
  212. VBA code for message box popup if data already exist.
  213. Copy UserForm text box values to another workbook
  214. MsbBox code help
  215. [SOLVED:] Hide row if cell contains...
  216. How to Loop?
  217. Hyperlink Help
  218. [SOLVED:] VBA Code to enter different formula if value is different
  219. Cell referencing in formula
  220. Pasting into an existing column
  221. [SOLVED:] VBA Conditional Formatting not Applying
  222. Excel 2013>VBA>Match>Wildcard
  223. [SOLVED:] UserForm does not show ... Runtime error
  224. Sending SMS through VBA
  225. how to do this with vba? a difficult question
  226. Create a wizard for Users
  227. [SOLVED:] Determining number of rolls to delete
  228. Disabling Cut Copy Paste in Excel 2013 not working
  229. [SOLVED:] Need Help restructuring this Macro for large amount of data. Please
  230. VBA Password Prompt Appears on Exit from Excel
  231. Count consecutive cells (rows) with same value
  232. Finding duplicate values
  233. vba for each worksheet loop
  234. VBA to delete empty rows
  235. [SOLVED:] Excel 2013>VBA>UserForm>TextBox>Name as variable
  236. [SOLVED:] Dynamic Array using Redim Preserve VS large static array?
  237. Range of Rows filtered by column data
  238. [SOLVED:] How do I convert text or string to time format using excel vba?
  239. [SOLVED:] Addtional condition in array formula
  240. Paste as Unique values and paste dynamic cell formulas too
  241. [SOLVED:] NEED with either fixing formual or preferably a macro to do this procedure. Please!
  242. [SOLVED:] Out of memory
  243. Help, User input dynamic array
  244. excel vba multiple charts in new sheet
  245. How to delete entire row if specific column has ANY data in it?
  246. How to check the code of a macro which calculates the value of a certain cell?
  247. Function Simpification
  248. .AllowMultiSelect = True works intermittently
  249. Automating Tasks in Excel via VBA
  250. Saving and merging Word docs from Excel Sheet