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. Manipulate 2 different columns to become one (4 replies)
  2. VBA Column comparison against sheet and viceversa (2 replies)
  3. [SOLVED:] dblclick cell text cursor blinking (3 replies)
  4. Delete by Dates (1 replies)
  5. Excel Date formatting issue (1 replies)
  6. Change from Internet Explore to Google Chrome (1 replies)
  7. Switch case not giving desired product (7 replies)
  8. function keys open wrong dialog (1 replies)
  9. Help Logging into Website with VBA (0 replies)
  10. [SOLVED:] EXCEL (macro) - Analysis of hourly intervals from sectional graph, correlation (20 replies)
  11. Move data from sheet 1 to 2 (2 replies)
  12. [SOLVED:] Concatenate cells with leading zeros vba (9 replies)
  13. Convert PDF data into Excel or txt using VBA (3 replies)
  14. [SOLVED:] Script to loop match initial search term in data column to find the value of cell bel (2 replies)
  15. Deleting specific cells when a condition is no longer met (0 replies)
  16. Linest() <> Chart Trendline Formula (4 replies)
  17. Sorting Issues (0 replies)
  18. [SOLVED:] Run code on each cell until month changes (6 replies)
  19. [SOLVED:] VBA to extract data from WebPages (4 replies)
  20. Sleeper: VBA & IE Form (1 replies)
  21. Excel VBA performance variance issue (5 replies)
  22. collection / array help (6 replies)
  23. VBA - Help me to solve this one, makro who can select between 3 sheets (13 replies)
  24. [SOLVED:] Automatically filter selected worksheets by date criteria (4 replies)
  25. Automatically copy certain cells from rows from one Worksheet into another Worksheet (0 replies)
  26. VBA Power Analysis Macro help (8 replies)
  27. [SOLVED:] Extracting Dates (14 replies)
  28. Import CSV File to Workbook (2 replies)
  29. Excel VBA macro to fill web form using excel data (0 replies)
  30. Excel macro to fill web form using excel data (3 replies)
  31. [SOLVED:] Help with Offset and r Resize formulas to select a range. (5 replies)
  32. checkbox in excel (0 replies)
  33. Change color of cell/cells (2 replies)
  34. Replace functions with hard values (1 replies)
  35. Username to populate (0 replies)
  36. [SOLVED:] Very simple problem with no solution found (7 replies)
  37. Invoice date help (2 replies)
  38. [SOLVED:] Merging two Private Sub (6 replies)
  39. Using Macro to Pull in New Data Every Month (0 replies)
  40. [SOLVED:] Multiple Consecutive Line Feeds Using vbCrLf (2 replies)
  41. Find a last row and insert a values (7 replies)
  42. [SOLVED:] Copy and paste row of data to another worksheet macro (6 replies)
  43. [SOLVED:] Count_Colours_Not_Duplicate (6 replies)
  44. Comparing Data Across Sheets, with Multiple Variables (3 replies)
  45. Loop Thru Cells (1 replies)
  46. [SOLVED:] how to create a excel macro (button) that will show next number from a list? (6 replies)
  47. Print from Image Object in Sheet using VBA (range of print changed when filter table) (0 replies)
  48. [SOLVED:] VBA Unprotect not working properly (2 replies)
  49. [SOLVED:] Remove lines with no entries and copy back some data (5 replies)
  50. xlDown not returning last used cell (18 replies)
  51. copy email body to excel (0 replies)
  52. Userform - Different rights for differenz users (6 replies)
  53. [SOLVED:] Enable and disable calculations for a range of cells (1 replies)
  54. Toggle SUM/AVG on Pivot Table (7 replies)
  55. VBA code for Autofit row height for rows with merged and unmerged/normal cells (1 replies)
  56. [SOLVED:] Find a cell in a range based on a condition & change the value of the cell beneath (8 replies)
  57. UserForm Retrieve Data From Correct Sheet, based on Combo Box Value (1 replies)
  58. How do i extract a part of text file content (4 replies)
  59. Need help with my macro "Sub or function not defined" (1 replies)
  60. Getting VBA to decide which cell to use (1 replies)
  61. VBA, i want the value, not the formula (4 replies)
  62. [SOLVED:] Using a variable to call either a form or a sheet (4 replies)
  63. [SOLVED:] Help with an array formula (3 replies)
  64. [SOLVED:] Compare dates - password required if expired (5 replies)
  65. Internal Hyperlinks in Pivot Tables (7 replies)
  66. How can remove " after do replace in beginning and end of cell (8 replies)
  67. [SOLVED:] Converting a string by detecting Chr(183) (2 replies)
  68. Embedded objects in Excel (0 replies)
  69. [SOLVED:] Issues with Arrays and DLLs (10 replies)
  70. [SOLVED:] Cell with multiple lines of data , delete lines without # into one line (8 replies)
  71. Issue with sending the active workbook & printscreen via Lotus Notes (6 replies)
  72. callback for Application.Run (2 replies)
  73. Stuck on VLOOKUP VBA using variables (11 replies)
  74. [SOLVED:] VBA Copy and Paste data form one workbook to another.. Problem is data change every w (8 replies)
  75. Problems with simple counter (2 replies)
  76. [SOLVED:] NEED HELP RESCTRUCTURING MACRO TO FIT MY WORK SHEET, PLEASE. (3 replies)
  77. Speedup VBA (4 replies)
  78. excel formula and vba automation help (6 replies)
  79. Available Procedures in COM add-in (1 replies)
  80. INSERT OVERWRITE INTO correct syntax? (2 replies)
  81. [SOLVED:] Editing the contents of a Match Index Cell through VBA (2 replies)
  82. Email and HTML (5 replies)
  83. TOC macro to skip displaying hidden sheets (4 replies)
  84. Newton's Method Iteration Code in VBA- No errors but will not output (3 replies)
  85. Automatic numbering up, with two matches (26 replies)
  86. Sleeper: New line in formula & Join Text (2 replies)
  87. Montly, Weekly, Daily Attendance (11 replies)
  88. [SOLVED:] Tab delimited text file issue (2 replies)
  89. [SOLVED:] Runtime error 1004 (4 replies)
  90. Conditional VBA for Combinations (4 replies)
  91. [SOLVED:] Offset in an Array - Replacement (12 replies)
  92. Disable Sort In Shared Workbook (3 replies)
  93. To search a column in a database and to return all the entries found (2 replies)
  94. [SOLVED:] VBA Macro Stops at line 986 (11 replies)
  95. [SOLVED:] VBE Editor Select Module (2 replies)
  96. [SOLVED:] Transpose Excel data from rows to columns (6 replies)
  97. [SOLVED:] Struggling to apportion value 'dynamically' - Worksheet attached (7 replies)
  98. VBA Powerpoint formating (14 replies)
  99. If Value is >= 1 Take header and insert into row (1 replies)
  100. [SOLVED:] CDR CVS help needed (8 replies)
  101. VBA to use a variable filename (3 replies)
  102. [SOLVED:] LEFT Function to retain first 10 characters of cells with VBA (4 replies)
  103. Explain Formula (15 replies)
  104. Advanced Filter Help (2 replies)
  105. Vba Macro in Excel for exporting multiples files in Word with prompt (3 replies)
  106. [SOLVED:] Calling Textboxes created in runtime with a form how to reference in a loop (6 replies)
  107. [SOLVED:] Making VBA userform, ChangeButton does not work (2 replies)
  108. Link spreadsheets (1 replies)
  109. [SOLVED:] For loop inside IF statement (2 replies)
  110. Filter by named range in closed file (7 replies)
  111. Open PDF in WebBrowswer Control on Userform (0 replies)
  112. Sleeper: How to save as with fixed name and server location ? (9 replies)
  113. Updating database using userform dependent combobox selection (2 replies)
  114. Changing an Excel Userform does not work (3 replies)
  115. [SOLVED:] Simple Macro Help (8 replies)
  116. Chart - Excel 2013 - Series Highlight on Label mouse over (7 replies)
  117. search a column of keywords in a folder of .docs and match file names and string (27 replies)
  118. How to use buttons on userform (3 replies)
  119. [SOLVED:] Add a link button dynamically in 1 cell of each row (5 replies)
  120. Select Listbox Item by ComboBox Item (3 replies)
  121. Upload File with winscp and sftp (8 replies)
  122. [SOLVED:] update a table between two Excels files with a condition (3 replies)
  123. [SOLVED:] ListBox - Population - Load For Each Worksheet (13 replies)
  124. [SOLVED:] Generating new ID VBA code (7 replies)
  125. Vba Need Dice Continue Rolling? (1 replies)
  126. [SOLVED:] Worksheet.Evaluate to Formulae (2 replies)
  127. Treeview not loaded in userform (6 replies)
  128. I need the cursor to go to the last non-zero in column C (3 replies)
  129. Web scraping (2 replies)
  130. [SOLVED:] DATE and TIME FORMATTING in Office 2007 (9 replies)
  131. Excel sending email format (1 replies)
  132. Help with macro filter sequencing (9 replies)
  133. Create outlook reminder from excel (3 replies)
  134. [SOLVED:] Transpose date from column name (2 replies)
  135. [SOLVED:] Variable Not Defined Error (6 replies)
  136. Changing Vlookup to variable depending on search results? idk (1 replies)
  137. Refresh DB Connection Programatically (1 replies)
  138. Delete table rows where a cell in D contains certain numbers (1 replies)
  139. exportasfixed format specific range not working (2 replies)
  140. reformuler un tableau ce forme dans rapport Excel (3 replies)
  141. work hours with lunch break (2 replies)
  142. Check for headers in Excel (1 replies)
  143. Referencing Classes ByRef vs ByVal (3 replies)
  144. Excel-Visual Basic UserForm Coding (3 replies)
  145. For Each inside another loop works only once after excel startup (7 replies)
  146. INDIRECT with Data Validation for a 3D formula (2 replies)
  147. PDF2XL (1 replies)
  148. [SOLVED:] Subscript Size (5 replies)
  149. [SOLVED:] Userform focus causes document in opposite window to minimize - Dual Monitors (1 replies)
  150. [SOLVED:] Highlight Offset Consecutive Column Cells (5 replies)
  151. Hit button and download file using excel vba on web page (2 replies)
  152. [SOLVED:] Can you keep a connection to a DB open? (5 replies)
  153. [SOLVED:] Trying to Create a Remove Last Button (36 replies)
  154. Want to fill data from Excel in to specific Form for Print Lable. (2 replies)
  155. VGA code to list files attributes and also arranged them with filter using buttons (3 replies)
  156. countifs column with date (1 replies)
  157. Code to copy the active WS before a specific WS in the WB (3 replies)
  158. [SOLVED:] Macro to Print Worksheets Containing Specific Data (6 replies)
  159. [SOLVED:] Transpose Selected Cells Containing Specific Value (3 replies)
  160. [SOLVED:] Text to columns for every character in text file (3 replies)
  161. time to decimal format (10 replies)
  162. Close Open Text File - No Save Prompts (4 replies)
  163. Integrating Calendar with WorkSheet and UserForm (2 replies)
  164. Merge 2 Excel Worksheets together (4 replies)
  165. UserForm webBrowser ctl: how to detect 'no web page found' for a defective url? (1 replies)
  166. [SOLVED:] Going through a range (Looping?) (11 replies)
  167. CLEARCONTENTS OF CELLS WHEN OTHER CELL VALUE IS DELETED (10 replies)
  168. Textbox search conditionally (8 replies)
  169. Send Mail VBA LOTUS NOTES (1 replies)
  170. [SOLVED:] WorkSheets in an Array - Copy From (2 replies)
  171. OLAP Pivot Table - Variable number of filters (8 replies)
  172. [SOLVED:] Userform Assist - commandbutton to add multiple textbox (2 replies)
  173. List Box - Scroll Bar movement creating a ghost image of the ActiveX List Box (3 replies)
  174. [SOLVED:] Replace Exact String - Array (6 replies)
  175. Need to copy Some part of outlook mail body into excel through vba (0 replies)
  176. [SOLVED:] Help With Coding Structure (4 replies)
  177. [SOLVED:] Delete Rows Not Containing Array Term (4 replies)
  178. [SOLVED:] Array Step by 50 - Loop Incremental (4 replies)
  179. Macro to send e-mail for different recipients with different messages (4 replies)
  180. User Form Assistance (8 replies)
  181. Insert Excel Ranges in PowerPoint (4 replies)
  182. Filtering dates (8 replies)
  183. Print Documents Using File Path (1 replies)
  184. [SOLVED:] [Microsoft][ODBC Driver Manager] Data source name too long (7 replies)
  185. [SOLVED:] Combine multiple DIMs into one line instead of separate? (8 replies)
  186. organize data in groups with near equal Totals (7 replies)
  187. [SOLVED:] Summing individual rows, for overall group total (7 replies)
  188. Sendkeys and windows 10 (0 replies)
  189. Workbooks.Open - Convert .CSV (1 replies)
  190. [SOLVED:] VBA to compare multiple worksheets and produce report of cells where data varies (3 replies)
  191. copy data from multiple workbook ranges into one workbook sheet ranges (8 replies)
  192. Adding a Filter to a Pivot Table Inquiry (0 replies)
  193. Code that adds new appointments to Outlook (2 replies)
  194. Possible to apply conditional formatting across multiple ranges? (5 replies)
  195. Duplicates in named range (1 replies)
  196. Autofill column B based on dynamic range in column A in multiple sheets except some (2 replies)
  197. Copying excel ranges to powerpoint (6 replies)
  198. Naming a sheet to the current year (3 replies)
  199. Connect to two barcode scanners (2 replies)
  200. [SOLVED:] calculating time difference (6 replies)
  201. create Calendar from table (1 replies)
  202. [SOLVED:] When I move the cursor more than one cell become highlighted (8 replies)
  203. [SOLVED:] Copy paste Cell inside Table under certain conditions 2 (3 replies)
  204. [SOLVED:] Color Chart Columns by Conditionally Formatted Cell Color (4 replies)
  205. [SOLVED:] Printing Multiple Sheets to PDF (Excel 2013) (4 replies)
  206. Co-Authoring Issues - Auto-Updating (7 replies)
  207. Move informaiton based on a match (2 replies)
  208. Combination of cells to match a specified cell (3 replies)
  209. [SOLVED:] Code for a changable range in COUNTIF function (6 replies)
  210. Macro for data validation with two condition and high-light row (1 replies)
  211. Error When Open From Protected View (1 replies)
  212. Move Cells Up after Content is Cleared (2 replies)
  213. Counting Employee hours booked (9 replies)
  214. [SOLVED:] Userform: Change Textbox color in loop (4 replies)
  215. Need help to click on ID using VBA (1 replies)
  216. [SOLVED:] Loop Thru Columns (2 replies)
  217. auto filter on adding rows (8 replies)
  218. Calculating Compliance (1 replies)
  219. VBA: How to prevent chart / picture / button from moving in Excel? (5 replies)
  220. [SOLVED:] auto filter and send by outlook (1 replies)
  221. Multiple Digital Signatures - on different TABS??? (1 replies)
  222. Launch windows powershell using VBA (1 replies)
  223. Check if Directory Exists (1 replies)
  224. Skip a fault 13 with an If code and go on with the macro (2 replies)
  225. syncing files (1 replies)
  226. Save to PDF (6 replies)
  227. [SOLVED:] SUM by colour (9 replies)
  228. Pick directory and merge 2 files into 1 workbook (4 replies)
  229. [SOLVED:] Run-time error 53 when moving files (2 replies)
  230. VBA script not working what have I missed (2 replies)
  231. Comparing to Excel Sheets based on a Key Column Value - Semi Working (2 replies)
  232. [SOLVED:] Problem with VBA code in Excel (2 replies)
  233. calculate time difference between cells (2 replies)
  234. Pasting an Image Into Cell, Merging Cells, and then Resizing (1 replies)
  235. vba help (7 replies)
  236. [SOLVED:] finding the value and paste in another sheet . (7 replies)
  237. [SOLVED:] Macro for moving the columns (1 replies)
  238. Copy paste values from another workbook if criteria is met (2 replies)
  239. [SOLVED:] trouble hiding columns (2 replies)
  240. Implementing formulas with variables into VBA (2 replies)
  241. [SOLVED:] VBA macro for data filter and copy (2 replies)
  242. [SOLVED:] Display values based on matching column data (12 replies)
  243. Import Outlook-Taks in an Excel-Sheet (12 replies)
  244. sumproduct? (5 replies)
  245. Formula help please (18 replies)
  246. Using VBA in Excel macro to extract data from table and reconstruct table (2 replies)
  247. [SOLVED:] sum cells above every blank cell (5 replies)
  248. Creating a dynamic #N/A Filter for EXCEL. (4 replies)
  249. [SOLVED:] vba copy active sheet to closed workbook (2 replies)
  250. [SOLVED:] Array Prefix & Suffix Methods (7 replies)