Worksheet Related Problems & Solutions

24 tags
Refine Tags
Search Tags:

Start a discussion

Results 1 - 24 of 24
save worksheet as pdf in current location
Summary: hello everyone I would like to save the active worksheet as pdf in the current directory with name as a cell value. Please sort out this problem. Than...

Excel placing an X with stylus
Summary: I am developing a worksheet where employees will need to place only a X in a excel cell box. No formula just an X to indicate a yes or no status. I ...

[Solved] top & Wrap formatting stop working
Summary: I formatt a whole worksheet to align "top" and "wrap text". It works for a while, then I go in to enter data and have to re-format. The "wrap text" bo...

[Solved] Search Values Across Excel Sheet and Highlight Any Hits
Summary: I have a lengthy list of values (20,000 or more) in an Excel column (call that Worksheet 2). I want to search for the occurrence of any of those valu...

I want to copy text/value and skip blanks between worksheets
Summary: How do I create macro to copy only text/value and not blanks from worksheet1 to worksheet2? Hope my explanation below is clear. Thanks. Example: Wor...

create a copies of template worksheet based on a template
Summary: Hi there, I want to create copies of a "template" worksheet. The number of times it needs to copy is based on the number of location which can be deri...

[Solved] How to automatically name a worksheet from the date in a cel
Summary: What I am trying to acomplish is a work log. I have in row A5 through A11 the dates of the week and these are calculated from the date I put in B3. So...

[Solved] Set column focus in VBA
Summary: I am using VBA in Excel. How do I get my code to run only for Column E. Right now it is running for the entire worksheet. How do I set the focus for ...

[Solved] Countif across multiple worksheets
Summary: hello I have 100 worksheets names 1 to 100 having same format having "YES" or "NO" in B2 of each worksheet I would like to count no of YES in B2 of ea...

[Solved] Need help with vlookup formula
Summary: I have several worksheet I am working from in Excel 2010. One worksheet has rows with account ID numbers. Also, there ae columns with the months for y...

[Solved] Display worksheet name based on a condition
Summary: I have an excel sheet with worksheets say A, B, C,D representing each of the sales unit. each of these sheets has rows of different sales risk say 1, ...

[Solved] VBA coding in Excel
Summary: I have produced a worksheet called 'Students' with a different record on each row. When a case is cleared I select 'Y' or "W" in column F. Is it poss...

Excel Worksheet data range
Summary: Okay so here is what i am trying to do I have a worksheet called template and i was modifying the below VBA to copy that Worksheet and then change the...

[Solved] I want to use a macro to save an Excel worksheet to a .pdf.
Summary: I have a worksheet that I want to concurrently print a hard copy and save to a .pdf file in a folder on my computer. The worksheet that I want to pri...

[Solved] Unprotecting a cell when On Focus
Summary: I have a worksheet that is protected except for the cells that require user input. In two of those cells, upper case inputs required. I have inserted...

[Solved] I want to print an Excel spreadsheet using a print button.
Summary: I have two worksheets in my workbook. I want to create a "Print" button on Worksheet 1 (the worksheet that I use to enter data) that will print Works...

[Solved] How to copy all data from one sheet to another excel vba?
Summary: What is the correct way to copy a whole sheet to another existing sheet in the same workbook? i would like sheet4 to store my data and copy it to shee...

[Solved] Keeping Cell Data Once Transferred To Another Sheet By Macro
Summary: Does anyone know how to keep formulas in cells. I am making a calculator of sorts that is using data in various cells within the same worksheet. Once ...

Create Worksheets Using Macros
Summary: Hi All, I have pretty basic knowledge of writing macros and i am struggling with creating a macro to automate my invoicing process. (I am using Excel ...

Info mess to show when spec excel tab opens
Summary: Hi I have an excel spreadsheet with lots of different worksheets. When the tab called "Orange" is opened I need a message box to appear and say "If yo...

Creating worksheets with a macro
Summary: I would really appreciate some help creating a macro. My skills in VB are virtually none. Basically, my spreadsheet has four columns which contain: ...

copy line to new sheet macro
Summary: I was wondering if anyone here can help me. what im trying to do is: Create a macro to sort data line by line from a "Dump" worksheet to other existi...

Trying to find the right formula/function
Summary: Hello, I am trying to find the correct formula or function for something I am trying to do in Excel 2007. I have six three-digit binary codes (which h...

combine Header worksheet to print with Graph
Summary: i have inherited a workbook that has 3 worksheets, one with raw data, one called Graph and another called Header. from the raw data, a scatter plot...

1


Ask Question