I pull reports of various employees that list the number of meetings and the types of meetings they had during a pay period.
When I pull the report, excel gives every employee their own worksheet. For example:
Sheet1 - John Doe, 3 evaluation meetings, 1 commercial meeting
Sheet2 - Jane Smith...
I have multiple tabs of data (named AB, BC, CD, EF, FG, GH, HI, IJ, JK, KL, LM, MN, NO, OP, PQ, QR, RS, ST, TU, UV, VW, WX, XY, YZ, Z00, Z01, Z02, Z03) in my "critical numbers spread-sheet" with wanted numbers per application identified in each tab but columns and rows are inconsistent. I have...
I have 28 tabs of data (named AB, BC, CD, EF, FG, GH, HI, IJ, JK, KL, LM, MN, NO, OP, PQ, QR, RS, ST, TU, UV, VW, WX, XY, YZ, Z00, Z01, Z02, Z03) in my spread-sheet with varying data (columns and rows are inconsistent) in each tab. I need a summary tab with count of each column per tab(only...
<tbody>
Order
PO number
Art number
Amount
123
1345
1
17
123
1345
2
18
123
1345
3
8
456
6547
4
8
456
6547
1
9
789
4564
3
11
</tbody>
Hello,
I have got a range of cells which I would like to split to multiple worksheet when a PO number changes (column...
Hello,
I'm working off an excel file used to track overall and individual performance scores on jobs (for a moving company). Right now, everything is entered/copied into the multiple sheets manually, which is unnecessary, but I do not know anything about macros.
The Master sheet will look...
Hello,
I'm intermediate with Excel formula but not very experienced with VBA. Any guidance on the below would be much appreciated!
I've built a spreadsheet that will help my colleagues add/remove product codes that are used by a client. I need this because there is a specific set of product...
I have a file that contains 25 worksheets w/ all same formatting.
Now, I need to set the print area to A1:N58 for sheets("firstone") and set the print area to A1:N40 for sheets("secondone"). I only know how to do this for 1 worksheet (activesheet) at a time. Below is what i used...
Hi,
I am currently working on a VBA code for share analysis and I have found a very useful spreadsheet that takes stock data from yahoo finance based on your ticker list and start and end dates that you set.
When you click 'get bulk quotes' command it retrieves date, open, high, low, close...
Hello to all!!
I've got the code below
Sub CopyUnique()
Dim s1 As Worksheet, s2 As Worksheet
Set s1 = Sheets("mypage")
Set s2 = Sheets("george")
s1.Range("A3:L500").Copy s2.Range("A1")
s2.Range("A3:L500") .RemoveDuplicates Columns:=1, Header:=xlNo
End Sub
It works great...
I'm looking for the right code where Sheet2 will add a new row and populate the Column B cell of the new row with data from a range on Sheet1. I need this to occur every time I add new item to the range on Sheet1. So if I have:
Sheet1:
<code style="margin: 0px; padding: 0px; border: 0px...
Hello,
I am trying to get this macro to run in every sheet in the workbook except for the sheets I'd like to exclude. I've spent all day reading similar questions but havne't been able to get any of the code to work. Any help is appreciated.
(Sorry it when i tagged it as code it was cutting...
Greetings,
I've been searching and searching for a solution. I've been able some threads that address parts of what I need, but I'm such a VBA novice, I don't know how to put them all together. I'm hoping someone can help me create the code to get this done ...
Excel 2003
Windows v8
--WHAT I...
Hi, im having trouble running a set of modules in order on a sheet then when thats done loop the seem sequence through all the sheets in the file
so far ive got
Sub Run_all()
Dim sh As Worksheet
For Each sh In ThisWorkbook.Worksheets
sh.activate
Call macro_1
Call macro_2...
Hi all-
Got what I hope is a fairly simple vba question. I am working with a 7 sheet workbook, and each sheet includes (among other things) about 10 input cells. I have used the name manager to define the entire range of those input cells (across all sheets) as "input".
I was hoping to write...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.