multiplesheets

I am working on creating a user form that takes the data entered, and submits it on a table on a specified sheet. On the user form, how do I have the data submit to different tables on different sheets? I want to be able to click submit on the user form and specify which sheet that I want the...

Hi All, I have a workbook which has one worksheet in it, this has a 'summary' section in it complete with formulas which needs to be pasted into another workbook which has 119 sheets, at the top of every sheet. Basically I need a macro to insert 30 blank rows onto all 119 sheets (or to ensure...

Morning, Can anyone help me please? I need a formula to count how many lines of information there are, rather than add them up. For example On the sheet called 'Sales Progession' I want to count how many of the deals are at certain percentages, so that it looks like this. 40% 8 60% 22 80%...

Hi, I am trying to add up hours worked on specific projects over different sheets and with multiple criteria. For example, I want excel to recognize and add up all of the hours spent with criteria "company" and "project name", over 6 different sheets. Company is listed in all sheets under...

Hi All, I have tried to use other posts but due to inexperience was not successful. I am new to macros, but have managed to run the 2 subs below successfully: Sub Delete_Empty_Columns() first = Selection.Column last = Selection.Columns(Selection.Columns.Count).Column For i = last To first...