starting

Can I Please have help with a 2 part VBA question. The macro I have already checks for how many rows and columns that are being used on the open sheet. The last 2 things I need help with are. After the macro moves the data around we need to Ask the user to input a starting number so it can...

Hi, I'm looking to have a button that opens to the specific folder on the desktop, lets call it EFOLDER. You would then select one of the excel files to import. However I only want to import the worksheet named "PIE" which has data starting in A1. I then want that info copied to sheet1...

I have the following VBA code : Originally it had inputboxes but as this is standard I edited in such way that it would go to the right location and files automatically. I found this VBA code somewhere online and I use it to import sheets (sheet1) of several workbooks in the same workbook...

Hello, i want a vba to select the first blank cell in column b starting a row 7. I then want to move down 1 more row and enter text. Thank you!

Is it possible to colour cells dependent on values? On even rows (starting row 2) - Columns C:F - If "Yes" 169,208,12. If "No" 198,224,180 On odd rows (starting row 3) - Columns C:F -If "Yes" 155, 194, 230. If "No" 189, 215, 238 Finishing row 479

Help me!!:confused: I have been searching for a template I can use to give me a starting point to create a project tracking document. I need to track several tasks that will have moving dates and be able to have cells change colors for priority, when dates are behind or on target, etc.. I'm...

Hi, Please find here below the link to download the Sample workbook, where i want to extract the unique values which are only starting with numbers in Sheet1 from Column A. Request to you please help me. Thank you in advance for your help. Regards...

I have a pivot table with inventory reports for a number of schools. I need to copy each school's section individually from a pivot table and paste on another sheet. Once I find the starting point for a particular school, I can use xlDown to set the correct number of rows. However, I need the...

before.img.....(below) As you can see in the image above ... I would to delete the whole row of data of column of C2 & C3 If Column "C" contains data starting with Attn* & Date* delete the whole row After.img.... (below)

Hi. I'm trying to setup a scoreboard which uses a drop down list to show a value from a category. Once I have the value I want it to change a final sum, so it will subtract or add from a starting total. So far I've managed to get the tables to give a minus or plus value, but all it does is...

Good day! I am looking to retrieve data from a SQL sever then place that data in multiple columns (if required). I have an array of cells in the workbook. There are three columns. Each column is 8 rows deep. Each column is made up of 4 merged cells (for formatting consistency). Column 1...

Hi, I have 6 groups of numbers : 1 to 7 = 1 8 to 14 = 2 15 to 21 = 3 22 to 28 = 4 29 to 35 = 5 36 to 39 = 6 Starting in column C9 I have numbers that run from 1 to 39. and starting in column AF9 I would need a formula that return the group ID of that number. so if in C9 I have the...

Hello everyone. The purpose of the worksheet is to assist in generating x and y coordinates by entering information at Range C2:C13. The inputs are for: Rows Per Group Columns per Group Starting X-Coordinate Starting Y-Coordinate Starting Z-Coordinate Rectangle Width Rectangle Height...

Hi Guys, I am looking for a bit of help with some data I need to work with. I have an excel sheet that contains varied amounts of data. some of the cells are blank and I am looking for some code to put a - (dash) in all of the empty cells starting at row 19 I need the code to find the last row...

I have peoples names down column A (Starting in A2) and Years across the row 1 (Starting in B1) Then I have how much each persons Sales were for each year (This goes down to Row 564) I need a formula where I can find how much Joe Smith (value down Column A) made in 2016. On a separate sheet...

Hi All, can any one help me on this i have two columns if column A starting 4 texts match with column B starting 4 texts then clear the contain from cell which is in column A <tbody> <colgroup><col><col></colgroup><tbody> MIAMIFLORIDAUSA088317434 </tbody> <tbody> MIAMI </tbody>...

I am trying to trim a lot of data from the form "10am-6pm" and "11.30am-9.30pm" to "6pm" and "9.30pm". I basically just need the finish time (I already have a macro sorted to trim for the start times). However I cannot work out why my current code isn't working. So far I have: Sub...

Hello, I have a table of data where one column is called week number (from 1 to 52). I created form with "Starting Week" and "Ending Week" as individual unbound text boxes. I simply want the user to be able to filter their data between the Starting and Ending weeks. When I use the following...

Ok, so I've gotten a lot of use from this forum and now I have a question I haven't been able to find an answer to, I'm totally shocked by that fact...I'll probably learn I wasn't using the right search terms lol. Lots of detail here, possibly too much but hopefully better than not-enough :rofl...

I am new to the forum, and while I considered myself an expert in Excel, now that I have started working with Macros and VBA, I am a humble beginner again! What I'm trying to do is the follow... Look at all cells in range B2:B100 and if B2 contains X, then copy the contents of C2 and add it...