called

Have copied data. Want to insert the data in workbook Alpha in cell A1. However I want it to loop though each sheet and insert the data in the sheet named: TB*, meaning TB plus any other characters following.. If there is no sheet called TB*, I want a new sheet to be copied in called TB. And...

Have a workbook called WB_A (Active workbook) and a workbook: WB_B Want to copy sheet1 (A1:currentregion) from WB_B to WB_A. The sheet should be inserted: If one of the sheets in WB_A is called TB* (*meaning any other character) it should be overwritten, and copied in from cell A1. If there is...

I have client numbers on a sheet called ABQ_IMPORT in the A Column and I need to see if they exist in the sheet i have called 2018 in Column B. If they do not exist on the 2018 sheet I need something to happen to notify end user like a conditional formatting to tell user that it doesn't exist.

Hi, I am analyzing someone else's code. One thing I notice is that they alternate between run("some_macro") and call some_macro Why is there a difference in the way the macro is called & does this make any difference? I personally don't like changing the way it is called, I would prefer...

Hi I have a column which has lets say 5 depts: hr, it, sales, marketing, and admin. If I want to see only hr dept. I apply filter and then select HR. What this called? Filtering all other departments except HR, OR filtering HR and leave other departments. Thank you very much.

Have a open workbook called Summary.xlsx. But this could in principle be all current selected workbooks. Want to create a macro: 1) to open another workbook called Accounts, saved in folder C:\ 2) Copy sheet called MD in workbook called Accounts 3) Insert it in workbook summary (or any other...

How do I loop through a specific set of worksheets in order to pull data from one worksheet and push it into these other worksheets? For example, I have a worksheet called, "Source," that I want to pull the data in Range("A1:A5") and "paste" it into in my other worksheets called, "A," "B" and...

Hi guys, I have a sheet set up with slicers. The sliced data sits in a sheet called Impact, row 17 and 18 to row n. Row 17 and 18 are header rows. Then data sits in row 19 downwards. I want a macro which copies the 'sliced' data into a new workbook called Newbook, onto a sheet called...

Hi all, I am trying to write a script to lookup and copy specific info from one worksheet to another if certain criteria matches. Worksheet A is called "Absent" and has 8 columns with A1 called CM CM ID Number Date Shift Position Reason Hours PTO Hours Worksheet B is called "Data" and has...

Hi there I wondered if some could help me as new to access and having the following issue I have a database where there are two dates that need to bee filled in 1 is called open for when a issue is reported and the 2nd on is called closed for when the issue has been resloved. Now i also have...

Hello everyone, I hope you all are having a nice day. Myskillset with Excel is intimidate best I currently own to 2016 MS Excel book.And to give some additional backstory I would for a insurance company with acall center type environment . I am hoping to create a excel worksheet for the...

Hello, So I have a pivot table with a pivotField called "Ship Month" I need to update them with my command button to only take this month (now it is September and the field called unscheduled) The issue is that I can't put With ActiveSheet.PivotTables("PivotTable6").PivotFields("Ship Month")...

Hi, I would like to add a tab in excel so you can go directly to a cell. I have an example but unsure how to post it in this forum. It was called a "scroll to week"i n the project mngt template I found online. ny help would b appreiated.

I am trying to combine these two formulas into one formula pulling information from two separate data sheets (one called contracts, the other called contracts 2) and comparing to the budget. This is the formula that works with one data sheet (contract), but when I try to combine using a...

Hi everyone, Ok so what i'm trying to do is this. I have a document Called "Master Dashboard" with a sheet Called "Projects Data" In this sheet Row1 has Headers of Project1,Project2 etc up to Project20 (A1:U1) I have a Folder on my desktop called "Projects" in this folder are up to 20 excel...

I have old dates in the E column on my sheet called ClientListings. Then on the next sheet Called GJ_Import I have new dates in the C column. How could I use VBA to update the old dates on SOME of the clients when there client number matches from the A column on both sheets. I also want it to...

I have the following formula: =LOOKUP(2,1/(Test_Method=Report!A2),Re_Assment) how do not use name rang. test_method= column "A", Re_assment =column "H". the named column are located on a sheet called "Entry Sheet" also, I would like it to copy the cell format.

Hi I have a column with hundreds of dates over several years. I wish to be able to find the earliest date within a particular year, the data is on a different sheet to where I am trying to do this, in this case you will see it is on a sheet called Records...

Have 15 sheet in same workbook. Want to consolidate entries in column A to C in each sheet into a consolidated sheet called "Consolidated sheet" Can this be done with a VBA formula?

Hello Everyone, i'd like to copy the entire last row of a sheet called ("HL_1") and pasted it to another sheet called ("HL_COMBINED"). I should also point out that they are both table formatted. the code i'm using is below, but it's just not working. any assistance is greatly appreciated...