content

Hello - I am trying to figure out how to copy and paste cell (for example) A1's content into cell A2, A3 and on but only if cell B2, B3 etc has content in it, otherwise, stop the copy/pasting. I also need this to be a relative reference. Please help :eeek::) TY so much [/IMG] [/IMG]

Hi everybody, I am new, this is my first post. Anyone can help me with the following question? Given an excel cell with line breaks (Alt+Enter or line breaks from text copied and pasted), is there a way to adjust the height of the cell so that it fits the number of text lines without wrapping/...

Hi I can hide the content of a cell using this custom formatting ;;; which is great but when i click on a cell, i see the content in the formula box! how can i hide the content from the formula box as well? thank you so much.

Hi all, I've been trying to piece this together but my experience is limited -- thought I could accomplish this with a simple formula initially, but now not sure. Appreciate any help. I have a workbook that lists jobs for a company that has 3 divisons. I need to start maintaining separate...

Hi, I understand it's not possible to format text in a vba textbox, I need to copy the textbox content to a cell eg. in the textbox I have: 1. bla bla bla 2. bla bla bla 3. bla bla bla What I want to see in the cell is: 1. bla bla bla 2. bla bla bla 3. bla bla bla Is it possible to do this...

Hi, I have a formula that is working at a subsistence level that I want to get operating in a better way. What the Formula I have does Take Data from Cells in Sheet2 and Populate the first 1,000 rows in sheet 1 with it. What I'd like this formula to do instead is Create two new columns...

I cannot open access. The following message appears: A potential security concern has been identified. Warning: It is not possible to determine that this content came from a trustworthy source. You should leave this content disabled unless the content provides critical functionality and you...

I'm working on a tracking sheet for a manager that includes automatically-generated file numbers for any new content--so whenever I enter a new line, the number "2018-x" (where "x" is the next number in the series) populates. Because these tracking items will include follow up content, I need to...

Hi everyone, i have two excel files say "mail-team1" and "mail-team2" Both are same and the cloumn headers like date, time, mail from, content, Action taken, target, remarks. Everytime a new mail comes, team1 will insert a row below the header and add the details (ie, recent mail is on top)...

I have an Excel spreadsheet with multiple sheets with same layout, but with different content in some of the cells on the sheets. The cells that have different content on each sheet have the same location on each sheet. I would like a macro that creates a table (overview) with the contents of...

I am looking to create a spreadsheet that will color cells based on content. Example... So basically it will shade the cell color based on the value in column A.. changing when the customer # changes. Thanks for your help!

Hello -- I am looking for an efficient VBA solution to arrange the cells of my data so that all of the data is aligned to the right-most cell. In the example below, the numbers are in column A and I would like those to stay in A and I would like all of the z's to be align in column M, the...

Hi, I have some columns I'd like to make read only - can't edit content - but content can be selected to copy, how do I do this? Thanks for any help David

Hello, I'm using Excel 2013. I'm hoping you can help me achieve the following outcome using macro: 1) Copy current worksheet and create a new workbook. 2) this newly created workbook much be identical to the source worksheet, except there should be no formulae (content and formatting...

Hi! I have two separate files. File 1 has text+number content in a column: A1, A2, A3, etc. File 2 has the same content, and in addition, each one of these values has a corresponding string, in an adjacent column. For example: A1=A1 B1=abc, A2=A2, B2=cde I want to replace the content of each...

Hi, I am using FSO in the following way to read the content of 2 files into 2 string variables. Is this correct or can I create a FSO just once and read both files into separate variables in the same code block? Also when writing data to a file is complete the file is normally closed. Can I...

I would be a time saver if it is possible to use the content of a cell to link to a sheet. For example: I have a sheet named Jan, Feb, Mar, etc.. and a A1-A100 contains Jan, A101-A200 contains Feb, etc... In B1, instead of =Jan!B1, is there a way to make something like =(A1)!B1 work so I can...

Hi there! I have a series of content data (blog posts, social media posts, etc) that has been tagged according to content. For instance, for each blog post, it is categorized as one or more of the following: Wineries Educational/Info tips Recipes Crafts Events Seasonal Each post can have up to...

Hi I have column like the one below and at the bottom I have a function that count how many empty cells = countif(A1:A10, "") so Initially I have 3 cells empty. when I tried to empty a cell content in that range using Spacebar, the countif() would not count that cell but if I delete the...

Hi everyone I need to setup a table of content in the following format: 1. Introduction >>(Indent)1.1 Implementation >>1.2 Policy >>1.3 Test >>>>1.3.1 Testing1 >>>>1.3.2 Testing 2 So there are 3 levels of number format. However it is not included in the default format...