hard code

I have >100 files, all with the same make-up. I use Sample File to get a 'specific part of the table'. I also need '1 value' of this table from a specific cell, BUT this value is filtered out in the steps to get the 'specific part of the table'. I could Add (the '1 value') as New Query before I...

So i've been working on a little personal project for a better way to sort out my stuff in a game, what better way than to use excel, in my means to do this, i also wanted to make the excel super cool so i've ran into a problem i don't know how to solve because of my lack of knowledge on...

Hi, I've seen some similar posts, and attempted to tweak the VBA in order for it to work for mu purposes, but I am relatively new to this and I haven't come up with anything that works properly yet. I am looking to search through my workbook (quite a few sheets) to select and hard code all...

​ <tbody> A B C D E F G H I 1 <tbody> 27-Feb14 </tbody> <tbody> 28-Feb14 </tbody> <tbody> 1-Mar-14 </tbody> <tbody> 2-Mar-14 </tbody> February March April 2 3 4 X 5 </tbody> <tbody> if range of cells A4:AD, contains...

Hello everyone. I'm pretty new to VBA even if I already know how to do basic codes. In this case I have the idea but i don't know how to write it down. I'm working on a worksheet with 12k rows actives, and it's all structured as the table i posted below. What i have to do is substract the...

Long time viewer, first time poster. I want to build a macro to push a value from an input cell to table on another tab. For the sake of this forum, I made a very simplified version of what I want to do. On my second tab I have a table with TV shows and number of seasons: Dexter 6 True...