Workbook Related Problems & Solutions

22 tags
Refine Tags
Search Tags:

Start a discussion

Results 1 - 22 of 22
[Solved] Refer to a Range on an External Closed Worksheet (VBA)
Summary: Hello, In my code instead of referring to a sheet internally, I need to refer to a sheet externally which is also, preferably, closed. I was wondering...

[Solved] I am trying to automate printing schedules at work.
Summary: I have a list of names of people on a crew on one sheet of my workbook. On another sheet is the schedule. I want to be able, using a command button,...

[Solved] workbook to another workbook
Summary: hi.. Please help. I have a project which needs to transfer data from 7 tracking files into 1 consolidated file. Each workbook has the same format as w...

[Solved] hit counters in excel
Summary: I would like to add hit counter in my work book so that every time when workbook has opened whether read only , the count increase ...

[Solved] Linking multiple workbooks to one workbook
Summary: I have five team workbooks, each set up with up to 15 employee names in colum A, employee tasks set up on row 6, c6-m6, with dates as the worksheet na...

[Solved] Workbook always hidden when opened.
Summary: Even when I use the Ribbon to unhide the workbook and re-save as unhidden, the workbook always opens as hidden. The file extension is xlsx, I couldn't...

Drag and fill series, multiple tabs
Summary: Using Excel, I want to drag and fill down a column. The cell is linked to another sheet in the workbook (such as ='TQA 1'!$B$15) There are 23 Tabs (TQ...

Searching multiple sheets and tallying values
Summary: I have a workbook with 24 sheets. Each sheet has a parts list F11:K100. On sheet 25, I have a list of all the part numbers used on all of the parts li...

[Solved] hyperlink a sheet within same workbook
Summary: hello friends I have a workbook conting 100 worksheets named 1 to 100 & a summary sheet. I would like to open the specific sheet as i click on a hype...

Facing issue in pasting data from one excel to another
Summary: Hi Team, I am facing issue in copying data from one excel to another.I cannot do paste,where as paste special works fine for me.I am having MS 2007. T...

Unable to Copy & Paste from one Excel to another Excel 2007
Summary: Hi Team, I am facing issue in copying data from one excel to another.I cannot do paste,where as paste special works fine for me.I am having MS 2007. T...

I cannot Copy from one workbook and Paste into another...
Summary: The issue I'm having is that I cannot simply copy a cell containing number values and paste them into another cell in different workbook. HOWEVER, if ...

Excel: looking for sum of cells associated with drop downs
Summary: Hi I am trying to create a spreadsheet/workbook to record financials for a volunteer organization. Was hoping to have a sheet that fed a cashflow (to ...

[Solved] Can you copywrite a excel workbook?
Summary: If a workbook and be copywrited where do I start. ...

[Solved] can I count a particular nonempty cell of sheets of workbook
Summary: I have a work containg no of worksheets, I want to count non empty cell (particular cell) of all sheets in a single sheet. eg: I have 5 sheets Having ...

[Solved] how to clear contents of linked cell without losing link
Summary: i have a code to clear cells. here is the thing: i have a main workbook that has some cells linked to other workbooks. the other workbooks will be upd...

[Solved] conditional formatting depending upon another workbook
Summary: I want to do conditional formatting in a range in a sheet say sheet1 in workbook1, depending upon a range in another workbook without coping that rang...

[Solved] Select new Workbook and new Worksheet
Summary: I just cannot get this VBA code to do what it is suppose to do. The first command (Copy and Paste) is in 1 workbook and the second command in another ...

Excel- Getting info from a workbook
Summary: Hello, I am having troubles figuring out a way to search and copy data from one workbook into another. I have 2 spreadsheets that have 1 common colum...

Auto open a diff. workbook, then hide it
Summary: Workbook 1 uses data (for a dropdown) from Workbook 2. In order for workbook 1 to be able to pull the data, both workbooks need to be open. Is there s...

open 2 workbooks at once but keep one hidden
Summary: Workbook 1 uses data (for a dropdown) from Workbook 2. In order for workbook 1 to be able to pull the data, both workbooks need to be open. Is there s...

Always open workbook and hide it
Summary: Workbook 1 uses data (for a dropdown) from Workbook 2. In order for workbook 1 to be able to pull the data, both workbooks need to be open. Is there...

1


Ask Question