Hi Excel Users!
I need some assistance in having a formula created that will highlight a cell red when the following conditions are met, however, some of the information is on different sheet tabs.
I have an events spreadsheet and would like to do the following.
The tab with the information is called Events Notices as follows:
50's Sock Hop
Toss on your bobbi socks & poodle skirts then head down to where DJ (this needs to pick up the...
I've got an idea for a spreadsheet but am not sure where to get started. I have two tabs (Tab A and Tab B); each tab contains materials for a job. Each group of materials "A" column is the system into which the material was taken off. I would like to have all of my column A from Tab A...
I work in Finance and I need to send out our budget model to one of our business partners, but she can't see all the salary info we have in there.
One option is to go tab by tab (there are probably 30) and manually copy/paste values in the person-by-person salary calc, then delete the person by...
I have a customer order form spreadsheet with 3 existing tabs, each tab has a different product range and there are rows for each different product with columns for price, description, SKU and quantity ordered.
I need some help please with what formula to use so that on a new fourth tab...
I’m trying to find a solution to automate a stock sheet.
I have a register of various sizes based on diameter and length on one tab.
On other tabs I’m trying to look at the first tab and automatically add new items or down date quantities
you can see on the used / create tab, it has two...
My workbook has a tab for each month. When I’m in a specific month, I run the macro below to add a name to the Totals tab. It places the name on the first available row for that months chart. I created name rages for column A for each months chart on the totals tab. Example...
I have a macro that puts data that is in a cell on the tab. Currently I turn the date into Week XX and currently names the tab of the current sheet Week XX. I know you can not put / on the tab. Is there anyway I can Create Week 45 11.3.19 on the tab? I need to replace the / in the date...
Should be a simple piece of code, but I'm getting a timeout error.
I've got a workbook, let's call it "summary", which I want to put a macro in that will open another workbook, select all the data from a specific tab "CFG", and paste it into a tab, of the same name "CFG" within the...
I have a column of data on a tab called "Data Dump" in column A. The column contains 5 different product codes. I'm trying to do something along the lines of:
If A2 on the "Data Dump" tab equals "S-7", copy and paste A2, B2, C2, and D2 to a new tab called "S-7" starting with cell A9.
I have a spreadsheet with 2 separate sheets set up as follows:
Hi, how can I hide the 'right click' options on a Worksheet Tab (not the Worksheet Cells) pls... I have a Worksheet that I lock with VBA (password) and I dont want users to be able to unlock hte Sheet through the 'right click' option, eg: Insert / Delete / Rename, etc
Hi, is it possible to use a macro to insert 10 empty rows in row 1 of a workbook and do this for every tab in the workbook? Then I would like to copy a table and I insert this into the 10 blank rows created? I have 100 tabs on the workbook so want to avoid doing things manually.
Is it possible to have multiple people share the same workbook with different permissions?
Let's say everyone has access to the workbook file, but they have to have a passcode to view a certain tab?
If you create the spreadsheet tabs to be very hidden, is it possible that the person who...
BLUF - I looked through the threads best I could and did not see this answer, so I am very sorry if this scenario has already been answered.
What I have is a workbook with 6 tabs (one "data" tab and 5 other tabs representing the days of the week). The data tab contains a list of 22 students...
I would like a formula to grab new products and add them to a list. For example, I have two tabs. In tab A, I keep track of how much we sell/buy by product (so we bought 10 apples and 15 oranges and sold 10 oranges) and in tab B is a sumif formula to add up the sum so we know how much of each...
I have data I want to split up into clients names.
In range K5:"Last column" & 5
I have a list of clients names
I want to create a tab for each client and add there data to that page but I have a umber of problems please help if you can?
So for each name I want to create a tab...
I have an excel document that details the projects we're working on and who the PM is. plus a lot more detail about that project this is one a tab called Team POAP.
I want to create a summary overview on a different tab (called Timer Tracker) that shows the PM down column A and then in each...