Log in

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

  1. Fill Online Application - Acknowlegement number not generated (4 replies)
  2. [SOLVED:] filling combobox's issue (2 replies)
  3. Closing a program without killing other workbooks / "Wait please" pop up window (3 replies)
  4. UDF To Concatenate (9 replies)
  5. Challenging VBA Web scraping coding (0 replies)
  6. [SOLVED:] Toggle cell value on single click (6 replies)
  7. VBA macro to delete all empty rows and columns (1 replies)
  8. Converting an Excel macro to run from Word (2 replies)
  9. google translator vba code stop working (3 replies)
  10. Saving Excel 97-2002 file to Excel 2013 warning about Script Objects (1 replies)
  11. [SOLVED:] Make specific text bold in cells (5 replies)
  12. adapting number code to incorporate () - - (0 replies)
  13. change code to incorporate other textboxes (0 replies)
  14. [SOLVED:] Go To Previous Worksheet / Go To Next Worksheet {Problem} (16 replies)
  15. [SOLVED:] regular expression in excel (10 replies)
  16. Multi-Dimensional Array Sort (2 replies)
  17. Pasting a function to be in edit mode in a cell in excel (0 replies)
  18. Importing all outlook folders to excel using VBA (0 replies)
  19. [SOLVED:] copy cell value from one workbook to another based on two criterias (21 replies)
  20. [SOLVED:] Preserve line breaks when inserting/pasting into a single Excel cell (7 replies)
  21. Run Java code for web page via VBA (1 replies)
  22. Saving information from the user form (3 replies)
  23. 2nd time a freefile is opened, exception is thrown (2 replies)
  24. VBA UserForm: Updating Existing Data (0 replies)
  25. [SOLVED:] Vlookup a text and MsgBox it thanks to VBA (9 replies)
  26. Scatterplot Illustration Help (1 replies)
  27. Re-indexing Excel Sheets (0 replies)
  28. [SOLVED:] Help, loop finds overlaps, then adds not overlapped items, but misses the first match (2 replies)
  29. [SOLVED:] Date value error, need help (3 replies)
  30. [SOLVED:] Print Array (17 replies)
  31. [SOLVED:] Is necessary "Set Object = Nothing" (3 replies)
  32. Exel Power View worksheet (0 replies)
  33. Userform Filter Search (1 replies)
  34. Day/Time difference VBA (1 replies)
  35. Add Chart to constantly changing stats table (2 replies)
  36. Transfer data from one list box to another in a userform (1 replies)
  37. Combobox from one form filters another combobox in another form (0 replies)
  38. Select Cells based on values in another cell (2 replies)
  39. When/why does the VBIDE remember/forget its window state/position? (0 replies)
  40. boolean variable (1 replies)
  41. variable counter (1 replies)
  42. Specific Sheets Very Hidden (2 replies)
  43. [SOLVED:] Hide rows based on multiple criteria (5 replies)
  44. Running Macros in other Spreadsheets (2 replies)
  45. Adding a search box to an Excel sheet using VBA (very novice) (2 replies)
  46. [SOLVED:] Exporting Data to .txt - Need Help Setting Directory! (0 replies)
  47. Multiple Pivot Generation (0 replies)
  48. Run-time error '6': Overflow (0 replies)
  49. Create a dialogue prompt to filter down data? (0 replies)
  50. loop through cells (2 replies)
  51. Help with worksheet and workbook objects (1 replies)
  52. How do I mark my post as 'SOLVED'? (1 replies)
  53. "Subscript out of range" ... Issue (3 replies)
  54. VBA Macro Summary Sheet (1 replies)
  55. Dynamically modify Chart source data? (5 replies)
  56. Compare values between 2 tables (8 replies)
  57. Decreasing time by 1 hour (3 replies)
  58. Private Sub Worksheet_Calculate() - Not running when workbook opens (4 replies)
  59. [SOLVED:] Setting ranges that could change in VBA (3 replies)
  60. VBA Download File From Link (0 replies)
  61. Mismatch error (0 replies)
  62. [SOLVED:] Copy a block of lines/rows and paste to another worksheet (24 replies)
  63. Selecting dynamic range in Excel VBA (4 replies)
  64. [SOLVED:] Network days in VBA Calculation (0 replies)
  65. [SOLVED:] VLOOKUP Workbook Reference Asking For Data Updates (3 replies)
  66. [SOLVED:] working code inside - need to add a delete the row after the data has been copied (2 replies)
  67. [SOLVED:] How to put Cursor in text box and move to next text box? (2 replies)
  68. Excel - Sort data after report refresh and certain cell changes? (0 replies)
  69. [SOLVED:] Adding range values to email (2 replies)
  70. Formula excel Combining to cells (13 replies)
  71. saving pdf file of the specified range (16 replies)
  72. Array (25rows x 6 colomns) to be filled with random numbers with rules (1 replies)
  73. Copy cells in loop (7 replies)
  74. create folder if does not exit (9 replies)
  75. [SOLVED:] Remove the Index References table and continue to show the CF (2 replies)
  76. [SOLVED:] VBA To Determine Row label reference values in Pivot Table (2 replies)
  77. Having trouble with a VBA double loop iteration (2 replies)
  78. [SOLVED:] Match first column sheet A with first column sheet B (11 replies)
  79. Help automating the macro (5 replies)
  80. Pivot Table: VBA code to filter dates based on a date in another cell (0 replies)
  81. [SOLVED:] [ask]split text with comma to new rows (2 replies)
  82. Refresh autofit row using VBA excel (2 replies)
  83. VBA code to copy data per month to another sheet (0 replies)
  84. [SOLVED:] I need a Conditional Formatting formula (12 replies)
  85. [SOLVED:] Returning a value in the textbox on the form (9 replies)
  86. Highlighting Duplicates in Excel that are not a perfect match (5 replies)
  87. [SOLVED:] VLookup with VBA (9 replies)
  88. [SOLVED:] Delete Duplicate Data (7 replies)
  89. Improving VBA code (6 replies)
  90. [SOLVED:] Count numbers in a string and add numbers together (9 replies)
  91. Return query from access to excel combobox (1 replies)
  92. Button for every sheet one new email (0 replies)
  93. Option buttons inside frames within a userform disappear partially when scrolling (1 replies)
  94. [SOLVED:] [ASK] Excel VBA for multiple files in folder (4 replies)
  95. Filter data based on the date provided by the user (6 replies)
  96. Copying data from multiple worksheets to one summary sheet (0 replies)
  97. [SOLVED:] How to compare data in a spreadsheet and paste matched values in another sheet (6 replies)
  98. [SOLVED:] Vba code to transpose specific range of data from column A to another sheet (4 replies)
  99. [SOLVED:] Colour cell based on dropdown list (1 replies)
  100. Possible to create a link/macro to copy cell contents into an intranet page in IE? (0 replies)
  101. Userform to check 2 textboxes for duplicate & date check (2 replies)
  102. Need to transpose data from rows to columns (1 replies)
  103. Split Worksheet into separate workbooks (14 replies)
  104. Excel VBA - Hide cell values based on ComboBox selection (0 replies)
  105. If Not Like - Checking string for date format (5 replies)
  106. [SOLVED:] excel UF link to Accesd DB (3 replies)
  107. Assistance with a formula to return values based on time (3 replies)
  108. Conditional row formatting based on multiple nested IF/AND statements (1 replies)
  109. Combining Rows (4 replies)
  110. round to even calculation (4 replies)
  111. Combining All Worksheets of all Workbooks into one Workbook (2 replies)
  112. How to bold values that are less than the average? (0 replies)
  113. [SOLVED:] How do I automate color coding the highest performers on a chart? (7 replies)
  114. Creating user names & passwords to an excel workbook and restricting the view of data (1 replies)
  115. [SOLVED:] VBA msgBox executing before the previous line of code (0 replies)
  116. [SOLVED:] Consolidate a table with keeping 3 column criteria (4 replies)
  117. Run Macro when a character is entered (8 replies)
  118. VBA to match data in one file and copy data to an existing file (2 replies)
  119. [SOLVED:] UF Reflect Sheets & Future Sheets (2 replies)
  120. Sleeper: Exit/hide combobox when item in dropdownlist is chosen (1 replies)
  121. Automation help with the current code in VBA excel. (0 replies)
  122. HELP... How to copy paste tabs content to another excel in the same order of tabs (0 replies)
  123. [SOLVED:] search for the keywords and copy paste to another sheet (10 replies)
  124. Add new Row (table) (1 replies)
  125. Activate Combobox dropdown when cell selected, not when doubleclicking (3 replies)
  126. [SOLVED:] automatic variable names (2 replies)
  127. multiple comboboxes (0 replies)
  128. [SOLVED:] Excel CF help (4 replies)
  129. [SOLVED:] Import script help. (1 replies)
  130. [SOLVED:] Change value of a MS Word ActiveX Checkbox (10 replies)
  131. [SOLVED:] Problem while open file script (1 replies)
  132. Display VBA assigned values (2 replies)
  133. code sequence works manually but not as a macro? (21 replies)
  134. Macro to save book with diferent name each time ran (5 replies)
  135. VBA Code to Move row if criteria to tab within same Workbook (4 replies)
  136. Format user input from inputbox into a lap time (6 replies)
  137. Transpose Script not copying one specific field (0 replies)
  138. Excel 2010 – VBA Userform - Vlookup Textbox1 and return value to textbox2 (0 replies)
  139. Excel 2010 – VBA Userform - Vlookup Textbox1 and return value to textbox2 (0 replies)
  140. Excel 2010 – VBA Userform - Vlookup Textbox1 and return value to textbox2 (0 replies)
  141. Excel 2010 – VBA Userform - Vlookup Textbox1 and return value to textbox2 (0 replies)
  142. [SOLVED:] Writing a sub, using arrays, to join information on two worksheets using VBA (7 replies)
  143. [SOLVED:] Change SQL Query Syntax (2 replies)
  144. [SOLVED:] need help with combine files (2 replies)
  145. [SOLVED:] How to COmbine two files with this code need to modify (0 replies)
  146. [SOLVED:] problem with open file Run-time error 1004 (2 replies)
  147. VBA Copy cells paste +1 column (0 replies)
  148. [SOLVED:] Minor formatting issue: allow capturing a (.) full-stop as decimal (14 replies)
  149. [SOLVED:] need to open file if file exists then merge (0 replies)
  150. Subtotal and Label Specific Data Sets (1 replies)
  151. [SOLVED:] How to match two filenames? (0 replies)
  152. [SOLVED:] Select certain files with statement (combine files) (0 replies)
  153. [SOLVED:] Modify code a bit, (combine function) (3 replies)
  154. [SOLVED:] Creating Functions From Formula (7 replies)
  155. Copy Paste hide columns of Filtered data (0 replies)
  156. Object variable not set (2 replies)
  157. Counting files in a folder (22 replies)
  158. [SOLVED:] combine data from 2 workbooks with matching cells in different locations (19 replies)
  159. Using Record Set in loop (2 replies)
  160. Sendkeys not working - trying to copy dated data (0 replies)
  161. OCR by MODI via VBA Macro in Excel / Runtime Error -2147417848 (80010108) (7 replies)
  162. [SOLVED:] Sort current usded range (21 replies)
  163. fullscreen userform (4 replies)
  164. [SOLVED:] Timer please (24 replies)
  165. How to copy cells to same place but in another document? (2 replies)
  166. importing specific event log data into workbook (1 replies)
  167. [SOLVED:] AND and OR formula into an IF (2 replies)
  168. [SOLVED:] add/insert data validation cell to if column value to left is a number (2 replies)
  169. Function with FOR loop (3 replies)
  170. Macro to copy column from multiple files to paste to one file (9 replies)
  171. [SOLVED:] Sub-Procedure or Sub-Routine....?? (5 replies)
  172. Search No. & text list (0 replies)
  173. [SOLVED:] Ofsetting Cell by 1, 0 vba (3 replies)
  174. smart vlookup (1 replies)
  175. macro to remove numbers before first alphabet in a cell (18 replies)
  176. [SOLVED:] Emailing from Excdel only rows with data showing (2 replies)
  177. run time error 91 "object variable or with block variable not set (1 replies)
  178. using conbo boxes to populate data into text boxes (0 replies)
  179. [SOLVED:] Use one cell to create a variable number of rows on a different sheet (2 replies)
  180. [SOLVED:] Deleting all subsequent duplicates below first one in sorted list. (3 replies)
  181. [SOLVED:] Simple syntax problem (3 replies)
  182. [SOLVED:] Loop through active columns and save to file (1 replies)
  183. VBA excel access sharepoint slow connection (0 replies)
  184. [SOLVED:] Delete Blank Columns and Delete Blank Columns (2 replies)
  185. Sleeper: Storing and retreiving text from a separate workbook (1 replies)
  186. Excel VBA Code HELP - email active sheet plus 1 other (1 replies)
  187. [SOLVED:] how to loop through all used cells in just row 1 and alert? (11 replies)
  188. Data Scrape from IE (3 replies)
  189. values going below the ribbon (4 replies)
  190. Function help (2 replies)
  191. CategoryNames or SetSourceData on Excel VBA 2013 (0 replies)
  192. Formula - show unique value based on two condition (0 replies)
  193. change the date column (1 replies)
  194. [SOLVED:] VBA help! copy and paste to database sheet (10 replies)
  195. Saving a value from a variable -- I'm missing something obvious! (9 replies)
  196. [SOLVED:] Linking several workbooks to a master workbook (12 replies)
  197. Hyperlinks for Combo from Sheet Tabs (1 replies)
  198. Reg; Excell cell count according to the cell values (1 replies)
  199. Excel table if update the row end of cell date cell should update accordingly (1 replies)
  200. How to update an excel cell/column date everytime a change is made to its row? (2 replies)
  201. Listbox using List of Hyperlinks to other sheets (2 replies)
  202. [SOLVED:] vba Linear Sort help (3 replies)
  203. [SOLVED:] Can't use Split correctly (4 replies)
  204. [SOLVED:] How to select just letters in the alert and also make a string (4 replies)
  205. Help with my code - I want to clear any formulas when pasting (1 replies)
  206. [SOLVED:] Transpose 3 Columns (variable rows numbers) to 3 Rows (4 replies)
  207. NEED VBA Macro (2 replies)
  208. doubleclick doesn't work (6 replies)
  209. [SOLVED:] Count formla for three criteria (1 replies)
  210. [SOLVED:] VlookUp not Working? (1 replies)
  211. [SOLVED:] Can you sort SpecialCells or other noncontiguous cells (17 replies)
  212. Beginner question (5 replies)
  213. Problems with nslookup function (0 replies)
  214. [SOLVED:] How to rename active workbook? (1 replies)
  215. Small Help in this Code (2 replies)
  216. VBA to Restrict certain usernames. (14 replies)
  217. [SOLVED:] VBA Function - Search Min Value by length (8 replies)
  218. [SOLVED:] VBA - Find Specific words from Column "A" and paste to column "H" (8 replies)
  219. I need a formula.. (5 replies)
  220. [SOLVED:] Remove the Index References table and continue to show the CF (3 replies)
  221. VBA - Combine two column value using Distance (1 replies)
  222. [SOLVED:] I need help for Conditional Formatting. (1 replies)
  223. [SOLVED:] Column "A", where the zero value where the column "B" must be delete in the Value (3 replies)
  224. Highlighting a specific marker in a line chart (2 replies)
  225. [SOLVED:] VB Code for EXCEL 2010 - PLEASE HELP!! (3 replies)
  226. [SOLVED:] Deleting rows where value in column B starts with specific letter (5 replies)
  227. [SOLVED:] COUNTIF(AND... Mulitple criteria (4 replies)
  228. Glossary of terms using excel vba (8 replies)
  229. Automate Vlookup in Excel spreadsheet (3 replies)
  230. Copying value from multiple workbook to one after every 60 mins (1 replies)
  231. [SOLVED:] Selecting the next sheet and copying the previous (5 replies)
  232. ADDIN doesn't show when opening existing spreadsheet (2 replies)
  233. [SOLVED:] Vba code in excel to move doc files from one folder to another. (4 replies)
  234. [SOLVED:] how to see the first cell in a row also copy to a new sheet (2 replies)
  235. Newbie Help with VBA I think (25 replies)
  236. Autosort vba problem (1 replies)
  237. [SOLVED:] Excel cells into publisher help (2 replies)
  238. Help with Userform (1 replies)
  239. [SOLVED:] Copying specific cells to a new sheets also give sheetname (7 replies)
  240. Drawing sample in Excel (2 replies)
  241. Code Efficiency (6 replies)
  242. [SOLVED:] Missing apostrophe (6 replies)
  243. Find a word in a cell and delete the rows which doesn't have the word (4 replies)
  244. [SOLVED:] Export column script (1 replies)
  245. Date Prior to Actual Date (1 replies)
  246. [SOLVED:] VBA Cell Formatting Copy (3 replies)
  247. Ranking using data from 2 colums (4 replies)
  248. Textbox and the standard module (1 replies)
  249. [SOLVED:] VBA code chages - pick two cell instead of 1 (2 replies)
  250. [SOLVED:] Modify code to search multi columns and return data (4 replies)