dynamic rows

Hello, I am attempting to copy part of my excel worksheet as a table to an email. I have a for loop that loops through every row, with "rw" being the variable used for that current row. When I use my code, it is only copying column G and I am unsure why. Help would be appreciated 'Set the...

Hello and thanks for reading. I have code that copies data and pastes to another worksheet on the next available row. I am trying to delete a dynamic number of rows from a worksheet if they exist. I can search for a value in column C and lets call that value "dekalb". If vendor name exists i...

Question: How do I take the difference between cell data inputs (see text in red below) and create a dynamic number of rows that equals the difference? For example: Age at Distribution: 56 Age at End of Distribution: 90 Years of Total Distribution: 34 <--------- This is the number of rows I...

Hi, I have been looking around but not found an answer yet, if you have a link, pls post it. If not, here is the problem: I am looking to use "dynamic rows in lookup_array" of a match function. The MATCH have the following arguments (lookup_value,lookup_array,match_type). The...

I am working on a worksheet to lookup values from a table. I am having a problem figuring out the row and column dynamic lookup. I have two pieces of information. For example, 4 and $21,000. With these two pieces of information I need to be able to look across the top row to determine where 4...

Hi All, I am a bit of a newbie to Excel's formulas so apologies in advance for incorrect use of terminology. However I have an issue that I was wondering if anyone could help me with. I have a report that varies in row size daily, and I need to count how many employees we have in that one...

HI everyone, I just got started with VBA and I have a challenging macro to program. I would appreciate if you could help me or give me a hint how to do the following. I have a table that looks like this: prices quantities Company 1 5 ABC Company 3 45...

Tried searching for this but couldn't find exactly what I needed. I have a page of data that users input for stats. Because the user inputs multiple items for the same client I have formulas on another page that add up hours and events of that one client. However, I would like that second...

Tried searching for this but couldn't find exactly what I needed. I have a page of data that users input for stats. Because the user inputs multiple items for the same client I have formulas on another page that add up hours and events of that one client. However, I would like that second...