The discussions

Is there a way to export data fro table to a pdf form

I would like to send data from an access table to a pre designed pdf is there a way to

Last reply on 16 Mar 2019 by
ac3mark

Help with filtering not working

Hello, I am having issues with my excel at work we have about 8 columns an they have filters an when I type in data an click the filter to go to tha...

Last reply on 14 Mar 2019 by
ac3mark

Copy a range of data in column with a loop

Dear all, May I ask your help for a macro which allowed me to copy a range (column) 16350 times :-) On D5 to D369 I have a formula which do a rando...

Last reply on 13 Mar 2019 by
ChrisZ

Carrupt damage pdf file not open

plz solve my pdf recovery data file pdf not open

Last reply on 11 Mar 2019 by
ac3mark

User form to search all result and edit selected

I'm newbie in VBA excel. I want to create usesform to add, search all result and edit selected. Any one have code like this? Thanks

Last reply on 8 Mar 2019 by
ac3mark

Compare 2 sheets with particular columns

 Solved

Hello, hear is the situation, sheet1 is having "item code (ex. 150007) in column A", and "Rack ID in column B (ex. AA001)" & other side in she...

Last reply on 5 Mar 2019 by
SunilD

Add data to row that already contains data

 Solved

I want to enter data for the same product but it needs to be done on different days, with two different entry forms, so the row will already contain d...

Last reply on 1 Mar 2019 by
aileen

Automatically copy data from main sheet to child sheets.

 Solved

Hello, I know this question was asked in another thread (https://ccm.net/forum/affich-800808-need-to-automatically-copy-data-from-one-sheet-to-ano...

Last reply on 1 Mar 2019 by
vcoolio

How do i make my ranking

how do i make my ranking result be 1st, 2nd, 3rd instead of 1. 2. 3

Last reply on 28 Feb 2019 by
ac3mark

Montlhy service

I have an increasing excel sheet where i keep the service records for customers per customer, per branch and per date (per year, month and exact servi...

Last reply on 26 Feb 2019 by
TrowaD

If function?

I am trying to figure out a function, that will give me a result of Yes or No, if the dates are matching or not. This is the function I am using, ...

Last reply on 20 Feb 2019 by
ac3mark

Inserting pictures

Hello, Please I need help, I want to insert pictures into a particular sheet remotely without opening the sheet. And the picture will be base in ...

Last reply on 16 Feb 2019 by
Udomakpan

I want to convert figure or digit to word but without rupees or dollar

Hello, i want to convert figure or digit to word but without rupees or dollar, i just need only at the end of words, please help

Last reply on 16 Feb 2019 by
Munir

Populating multiple cells with information pasted on a main sheet

I am trying to paste data every week in the same cells (B2-B12) on my main page and have that data populate cells on 12 separate pages. All 12 pages w...

Last reply on 15 Feb 2019 by
ac3mark

Help getting data from one worksheet to the next.

Hello, I am trying to set up a master job sheet for all of our field employees to have the information in the field. The links to the 2 sheets are...

Last reply on 14 Feb 2019 by
TrowaD

Adding date depending on the day of the week

Hello, I want to automatically calculate a date when an invoice is due depending on the day of the week. For example: the service is provided o...

Last reply on 12 Feb 2019 by
TrowaD

Transpose vba excel

Hi, I require a macro that performs a specific transpose action. Please see pre table example and desired post data set. I have searched for t...

Last reply on 11 Feb 2019 by
TrowaD

Autocad 2010

Hello, I tried to install autocad 2010 but it keeps saying insert disc 1after when i install DirectX. So I opened acad.msi but it says install direct...

Last reply on 9 Feb 2019 by
TIMORO

Help me to convert my file without spelling mistakes

Hello, I want to convert one PDF file to word file. My file was an tamil documenr. I tried many times but the spelling was not correct in converted ...

Last reply on 8 Feb 2019 by
Ambucias

Updating other excel sheets automatically from master sheet.

Hi, I have been trying to sort this for a while. I have entered data in my master sheet and I have 4 other sheets. When I put new data into the mas...

Last reply on 6 Feb 2019 by
vcoolio

If function with time

Hello, cell A = Time in, Cell B = Time out I need to round the duration in between as below if sum(B1-A1)= 0:00:00 the answer should be 0:...

Last reply on 4 Feb 2019 by
1man1diot

Copying formulas to multiple worksheets

 Solved

Hi, I have a workbook that contains 32 worksheets. 31 identical sheets that are basically days of the month. Last one is a summary sheet. I have t...

Last reply on 2 Feb 2019 by
subodh

Give a cell zero value depending on another cell's value

I have an interesting challenge I am a altra marathon runner busy creating a "log program" for my running Cell A1 = Distance Ran Cell B1 = Hours C...

Last reply on 1 Feb 2019 by
ac3mark

Copy data and pasting multiple times using macro

Hello, So I am having trouble determining what code to use to past value. The situations is as follows: On Sheet1 I have a list of names in co...

Last reply on 31 Jan 2019 by
ac3mark

Auto xfer specific data to a new wkst

Hello, I have a raw data file of sales opportunities and would like to automatically identify and copy the TOP 10 Optys onto a new Wkst. Further, ...

Last reply on 31 Jan 2019 by
ac3mark

Excel vba- copying data from newest worksheet to a new workbook

Hi all, Newbie here. I've been fumbling around with VBA and managed to get some parts working, but now I'm stumped. I have an Excel workbook tha...

Last reply on 30 Jan 2019 by
1aman1diot

Copy data onto sheet only if cell has text

 Solved/Closed

Hello, I need to copy formulas and data from a selection of cells in a worksheet (Figures) onto a seperate sheet (summary). I would like the inf...

Last reply on 29 Jan 2019 by
checjb

Repeat a set of rows in excel

Hello, I have some set of unique row in a1 to a10, and I want to repeat the whole set of row in same column eg."A" by some given no. Of time by a p...

Last reply on 28 Jan 2019 by
Daniel Telele  

Conditional format "match range"

 Solved

I am stumped and can't find an answer to this issue for Excel 2010 The best way I can describe this is that I am attempting to build an Excel based...

Last reply on 24 Jan 2019 by
SadBingoDude

How to repair a pdf corrupted doc

 Solved/Closed

Hi, I am having a problem trying to open a PDF file. Ever time I attempt to open, Adobe Reader loads, but displays error message: There was an error ...

Last reply on 24 Jan 2019 by
Markdc

Watermark to some pages not all

 Solved

Hello Office Software Geek, I am currently writing a lengthy document and want to add my name as a watermark to some pages and another name to othe...

Last reply on 19 Jan 2019 by
Catherine

Formatting a cell for multiple functions in excel

Hello, I would like to have my dates be highlighted red when expired and yellow highlighting the dates when 30 days prior to being expired. I alrea...

Last reply on 18 Jan 2019 by
ac3mark

App android

Hello, App android

Last reply on 18 Jan 2019 by
Ratnendra Ashok  

Split data into several rows of same data

Hello, I would like to split a row of data into several rows of same data in MS Excel. I will try to explain the situation. I need a macro that...

Last reply on 14 Jan 2019 by
ac3mark

I need a pdf to word 2007 converter

 Solved

can you recommend a reliable pdf to word office 2007 converter? I downloaded pdfsmall converter and when I load the pdf file to be converted it gives...

Last reply on 11 Jan 2019 by
subsystems

Send automatic emails using macros

If column F in any worksheet in entire workbook is changed to "Pending" send an email. Below is my macro so far. Sub Request() Dim OutApp As Ob...

Last reply on 10 Jan 2019 by
ac3mark

Copy more than one cell in excel if a condition is met

Hi, I need to copy more than one cell if a condition is met. It’s about student degree. If the degree between specific range, then I need to copy m...

Last reply on 9 Jan 2019 by
ac3mark

How can i convert a docx file to pdf ?

 Solved

DOCX to PDF Converter software - you can convert your files from DOC or DOCX format to PDF format in just a few seconds with no other external compone...

Last reply on 8 Jan 2019 by
kieferschild

Pulling data from multiple sheets to master sheet

Hello, I am working on a project and I could definitely use some help. I have an excel file with four sheets: Master Sheet, Project A, Project...

Last reply on 7 Jan 2019 by
ac3mark

Vba code to open non excel programs

 Solved

Hello, I need vba code to open other documents besides excel doc's e.g open a word file, access file etc.. Can anyone help?? thanks PM

Last reply on 7 Jan 2019 by
Billybob

Problem with copy in one sheet

 Solved/Closed

Hello, There is a table on sheet1 for example. A B C D E 1 2 3 4 5 In cell A1 I drag the data from sheet2 cell A10 In cell A2 I drag t...

Last reply on 4 Jan 2019 by
ac3mark

I have a problem regarding how to automatically update data in other sheets.

Hello, I m looking to have few different sheets that automatically updated based on information that is added or changed in master sheet. One shee...

Last reply on 4 Jan 2019 by
ac3mark

Automatically move an entire row of expired item from one sheet to another sheet

Hi, I have a problem with the code below. I am a store officer in the firm I am currently with, and monitory of expiring date of a product is par...

Last reply on 30 Dec 2019 by
Ratnendra Ashok  

Free activation key for ms office 2016

Hi, I have MS Office 2016 but it isn't activated. I tried every key to activate it but none of them worked. So, can someone help me about this?

Last reply on 29 Dec 2018 by
Mastema

Copy worksheet from one workbook to another workbook in ms office excel

Hello, In the Move/ Copy dialogue box, the destination workbook is not visible to copy the worksheet from the source file.

Last reply on 28 Dec 2018 by
ac3mark

I need vba that creates a new sheet for every data entered in column d

 Solved

Hi, I need a formula that create a new sheet for every data in "D" column cells and sheet name is like the cell ,also add that cell whole row data ...

Last reply on 26 Dec 2018 by
ac3mark

How to convert date into words

 Solved

Hello, Hello i want to know how to convert date into words(english) for 05.05.1999 Thanks System Configuration: Windows Vista / Chrome 49.0...

Last reply on 25 Dec 2018 by
2massive-head

I forgot my password

Hello, I forgot my password.

Last reply on 23 Dec 2018 by
Daniel Telele  

Budgeting forumla in excel

 Solved/Closed

Hi! So I'm trying to write a budget for my household. Payments are made from different accounts. I've included an example. If anything in Colu...

Last reply on 22 Dec 2018 by
nfez
Results 501 - 550 out of a total of 12,264